DBA Data[Home] [Help]

APPS.OE_AUDIT_HISTORY_PVT dependencies on FND_DESCR_FLEX_COL_USAGE_VL

Line 1648: FROM FND_DESCR_FLEX_COL_USAGE_VL

1644: p_column_label VARCHAR2(500);
1645: BEGIN
1646: SELECT NVL(FORM_LEFT_PROMPT,FORM_ABOVE_PROMPT)
1647: INTO p_column_label
1648: FROM FND_DESCR_FLEX_COL_USAGE_VL
1649: WHERE APPLICATION_ID=660
1650: AND APPLICATION_COLUMN_NAME=p_appl_column_name
1651: AND DESCRIPTIVE_FLEXFIELD_NAME=p_flexfield_name
1652: AND DESCRIPTIVE_FLEX_CONTEXT_CODE IN ('Global Data Elements',p_context_value);

Line 1658: FROM FND_DESCR_FLEX_COL_USAGE_VL

1654: EXCEPTION WHEN NO_DATA_FOUND THEN
1655: BEGIN
1656: SELECT NVL(FORM_LEFT_PROMPT,FORM_ABOVE_PROMPT)
1657: INTO p_column_label
1658: FROM FND_DESCR_FLEX_COL_USAGE_VL
1659: WHERE APPLICATION_ID=660
1660: AND APPLICATION_COLUMN_NAME=p_appl_column_name
1661: AND DESCRIPTIVE_FLEXFIELD_NAME=p_flexfield_name
1662: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = p_old_context_value;

Line 1686: FROM FND_DESCR_FLEX_COL_USAGE_VL

1682: BEGIN
1683:
1684: SELECT DESCRIPTIVE_FLEX_CONTEXT_CODE
1685: INTO v_context
1686: FROM FND_DESCR_FLEX_COL_USAGE_VL
1687: WHERE APPLICATION_ID=660
1688: AND APPLICATION_COLUMN_NAME=p_appl_column_name
1689: AND DESCRIPTIVE_FLEXFIELD_NAME=p_flexfield_name
1690: AND DESCRIPTIVE_FLEX_CONTEXT_CODE IN ('Global Data Elements',p_context_value);