Using PL/SQL to define DFF
612970Jan 6 2008 — edited Feb 24 2008Hi, I have the code below from my senior, and the code is used to insert Descriptive Flex Fields into the oracle application. Can someone please help to explain the code below? I cannot understand the code at all. For e.g, how do I know which oracle table is this code inserting the DFF, and what does each line of the code means etc. Please kindly help. Thank you.
PROCEDURE new_flex_pkg (p_appl_id in number,
p_flex_name in varchar2)
IS
BEGIN
FND_DESCRIPTIVE_FLEXS_PKG.INSERT_ROW (
v_rowid, p_appl_id, p_flex_name,
'FND_SRS_MASTER', --X_APPLICATION_TABLE_NAME in VARCHAR2,
0, -- X_TABLE_APPLICATION_ID in NUMBER,
'N', --X_CONTEXT_REQUIRED_FLAG in VARCHAR2,
'STRUCTURE_COLUMN', --X_CONTEXT_COLUMN_NAME in VARCHAR2,
'N', --X_CONTEXT_USER_OVERRIDE_FLAG in VARCHAR2,
':', --X_CONCATENATED_SEGMENT_DELIMIT in VARCHAR2,
'Y', --X_FREEZE_FLEX_DEFINITION_FLAG in VARCHAR2,
'S', --X_PROTECTED_FLAG in VARCHAR2,
NULL, --X_DESCRIPTION in VARCHAR2,
NULL, --X_DEFAULT_CONTEXT_FIELD_NAME in VARCHAR2,
NULL, --X_DEFAULT_CONTEXT_VALUE in VARCHAR2,
p_flex_name, -- X_TITLE in VARCHAR2,
'Context Value', --X_FORM_CONTEXT_PROMPT in VARCHAR2,
sysdate, -- X_CREATION_DATE in DATE,
v_userid, -- X_CREATED_BY in NUMBER,
sysdate, -- X_LAST_UPDATE_DATE in DATE,
v_userid, -- X_LAST_UPDATED_BY in NUMBER,
v_userid);
EXCEPTION
WHEN OTHERS THEN
DBMS_OUTPUT.PUT_LINE('Error registering descriptive flexfield '||p_flex_name);
DBMS_OUTPUT.PUT_LINE(SQLERRM);
RAISE OTHER_ERRORS;
END;