eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BNE_INTEGRATOR_UTILS dependencies on BNE_INTERFACE_COLS_TL

Line 875: -- Generate the interface columns in the BNE_INTERFACE_COLS_B and BNE_INTERFACE_COLS_TL tables

871: P_SOURCE_LANG,
872: P_USER_ID)
873: LOOP
874:
875: -- Generate the interface columns in the BNE_INTERFACE_COLS_B and BNE_INTERFACE_COLS_TL tables
876:
877: INSERT INTO BNE_INTERFACE_COLS_B
878: (APPLICATION_ID, INTERFACE_CODE, OBJECT_VERSION_NUMBER, SEQUENCE_NUM, INTERFACE_COL_TYPE,
879: INTERFACE_COL_NAME, ENABLED_FLAG, REQUIRED_FLAG, DISPLAY_FLAG, READ_ONLY_FLAG, NOT_NULL_FLAG,

Line 906: INSERT INTO BNE_INTERFACE_COLS_TL

902: TABLE_COLUMN_REC.LAST_UPDATE_DATE);
903:
904: -- Generate the BNE_INTEFACE_COLS_TL columns
905:
906: INSERT INTO BNE_INTERFACE_COLS_TL
907: (APPLICATION_ID, INTERFACE_CODE, SEQUENCE_NUM, LANGUAGE, SOURCE_LANG, PROMPT_LEFT,
908: PROMPT_ABOVE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE)
909: VALUES
910: (TABLE_COLUMN_REC.APPLICATION_ID,

Line 934: -- Generate the interface columns in the BNE_INTERFACE_COLS_B and BNE_INTERFACE_COLS_TL tables

930: P_USER_ID,
931: P_INTERFACE_TABLE_OWNER)
932: LOOP
933:
934: -- Generate the interface columns in the BNE_INTERFACE_COLS_B and BNE_INTERFACE_COLS_TL tables
935:
936: INSERT INTO BNE_INTERFACE_COLS_B
937: (APPLICATION_ID, INTERFACE_CODE, OBJECT_VERSION_NUMBER, SEQUENCE_NUM, INTERFACE_COL_TYPE,
938: INTERFACE_COL_NAME, ENABLED_FLAG, REQUIRED_FLAG, DISPLAY_FLAG, READ_ONLY_FLAG, NOT_NULL_FLAG,

Line 965: INSERT INTO BNE_INTERFACE_COLS_TL

961: TABLE_COLUMN_REC.LAST_UPDATE_DATE);
962:
963: -- Generate the BNE_INTEFACE_COLS_TL columns
964:
965: INSERT INTO BNE_INTERFACE_COLS_TL
966: (APPLICATION_ID, INTERFACE_CODE, SEQUENCE_NUM, LANGUAGE, SOURCE_LANG, PROMPT_LEFT,
967: PROMPT_ABOVE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE)
968: VALUES
969: (TABLE_COLUMN_REC.APPLICATION_ID,

Line 1034: -- BNE_INTERFACE_COLS/TL tables. --

1030: -- DESCRIPTION: Procedure creates an interface in the Web ADI --
1031: -- repository for the first time. The Interface consists --
1032: -- of API Parameters. --
1033: -- This procedure inserts records into the BNE_INTERFACES, --
1034: -- BNE_INTERFACE_COLS/TL tables. --
1035: -- --
1036: -- --
1037: -- MODIFICATION HISTORY --
1038: -- Date Username Description --

Line 1298: -- Generate the Interface columns in table BNE_INTERFACE_COLS_TL

1294: API_PARAM_REC.LAST_UPDATE_DATE,
1295: API_PARAM_REC.DISPLAY_ORDER,
1296: API_PARAM_REC.UPLOAD_PARAM_LIST_ITEM_NUM);
1297:
1298: -- Generate the Interface columns in table BNE_INTERFACE_COLS_TL
1299:
1300: INSERT INTO BNE_INTERFACE_COLS_TL
1301: (APPLICATION_ID,
1302: INTERFACE_CODE,

Line 1300: INSERT INTO BNE_INTERFACE_COLS_TL

1296: API_PARAM_REC.UPLOAD_PARAM_LIST_ITEM_NUM);
1297:
1298: -- Generate the Interface columns in table BNE_INTERFACE_COLS_TL
1299:
1300: INSERT INTO BNE_INTERFACE_COLS_TL
1301: (APPLICATION_ID,
1302: INTERFACE_CODE,
1303: SEQUENCE_NUM,
1304: LANGUAGE,

Line 1503: -- Generate the Interface Columns in the BNE_INTERFACE_COLS_TL table

1499: FROM BNE_CONTENT_COLS_B BCC
1500: WHERE BCC.APPLICATION_ID = P_APPLICATION_ID
1501: AND BCC.CONTENT_CODE = P_CONTENT_CODE;
1502:
1503: -- Generate the Interface Columns in the BNE_INTERFACE_COLS_TL table
1504:
1505: INSERT INTO BNE_INTERFACE_COLS_TL
1506: (APPLICATION_ID, INTERFACE_CODE, SEQUENCE_NUM, PROMPT_LEFT, PROMPT_ABOVE, LANGUAGE, SOURCE_LANG,
1507: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE)

Line 1505: INSERT INTO BNE_INTERFACE_COLS_TL

1501: AND BCC.CONTENT_CODE = P_CONTENT_CODE;
1502:
1503: -- Generate the Interface Columns in the BNE_INTERFACE_COLS_TL table
1504:
1505: INSERT INTO BNE_INTERFACE_COLS_TL
1506: (APPLICATION_ID, INTERFACE_CODE, SEQUENCE_NUM, PROMPT_LEFT, PROMPT_ABOVE, LANGUAGE, SOURCE_LANG,
1507: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE)
1508: SELECT P_APPLICATION_ID APPLICATION_ID,
1509: P_INTERFACE_CODE INTERFACE_CODE,

Line 1618: -- Insert the required row in BNE_INTERFACE_COLS_TL only if P_LANGUAGE is populated

1614: P_VAL_TYPE, P_VAL_ID_COL, P_VAL_MEAN_COL, P_VAL_DESC_COL, P_VAL_OBJ_NAME, P_VAL_ADDL_W_C, P_VAL_COMPONENT_APP_ID,
1615: P_VAL_COMPONENT_CODE, P_OA_FLEX_NUM, P_OA_FLEX_APPLICATION_ID, P_DISPLAY_ORDER, P_UPLOAD_PARAM_LIST_ITEM_NUM,
1616: P_EXPANDED_SQL_QUERY, P_LOV_TYPE, P_OFFLINE_LOV_ENABLED_FLAG, P_VARIABLE_DATA_TYPE_CLASS, P_USER_ID, SYSDATE, P_USER_ID, SYSDATE);
1617:
1618: -- Insert the required row in BNE_INTERFACE_COLS_TL only if P_LANGUAGE is populated
1619:
1620: IF (P_LANGUAGE IS NOT NULL) THEN
1621: INSERT INTO BNE_INTERFACE_COLS_TL
1622: (APPLICATION_ID, INTERFACE_CODE, SEQUENCE_NUM, LANGUAGE, SOURCE_LANG, USER_HINT, PROMPT_LEFT,

Line 1621: INSERT INTO BNE_INTERFACE_COLS_TL

1617:
1618: -- Insert the required row in BNE_INTERFACE_COLS_TL only if P_LANGUAGE is populated
1619:
1620: IF (P_LANGUAGE IS NOT NULL) THEN
1621: INSERT INTO BNE_INTERFACE_COLS_TL
1622: (APPLICATION_ID, INTERFACE_CODE, SEQUENCE_NUM, LANGUAGE, SOURCE_LANG, USER_HINT, PROMPT_LEFT,
1623: USER_HELP_TEXT, PROMPT_ABOVE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE)
1624: VALUES
1625: (P_APPLICATION_ID, P_INTERFACE_CODE, P_SEQUENCE_NUM, P_LANGUAGE, P_SOURCE_LANG, P_USER_HINT, P_PROMPT_LEFT,

Line 1673: -- Update the required row in BNE_INTERFACE_COLS_TL only where P_LANGUAGE is populated

1669: WHERE APPLICATION_ID = P_APPLICATION_ID
1670: AND INTERFACE_CODE = P_INTERFACE_CODE
1671: AND SEQUENCE_NUM = P_SEQUENCE_NUM;
1672:
1673: -- Update the required row in BNE_INTERFACE_COLS_TL only where P_LANGUAGE is populated
1674:
1675: IF (P_LANGUAGE IS NOT NULL) THEN
1676: UPDATE BNE_INTERFACE_COLS_TL
1677: SET USER_HINT = P_USER_HINT,

Line 1676: UPDATE BNE_INTERFACE_COLS_TL

1672:
1673: -- Update the required row in BNE_INTERFACE_COLS_TL only where P_LANGUAGE is populated
1674:
1675: IF (P_LANGUAGE IS NOT NULL) THEN
1676: UPDATE BNE_INTERFACE_COLS_TL
1677: SET USER_HINT = P_USER_HINT,
1678: PROMPT_LEFT = P_PROMPT_LEFT,
1679: USER_HELP_TEXT = P_USER_HELP_TEXT,
1680: PROMPT_ABOVE = P_PROMPT_ABOVE,

Line 1846: -- Generate the Interface columns in table BNE_INTERFACE_COLS_TL

1842: API_PARAM_REC.LAST_UPDATE_DATE,
1843: VN_SEQUENCE_NUM,
1844: VN_SEQUENCE_NUM);
1845:
1846: -- Generate the Interface columns in table BNE_INTERFACE_COLS_TL
1847:
1848: INSERT INTO BNE_INTERFACE_COLS_TL
1849: (APPLICATION_ID,
1850: INTERFACE_CODE,

Line 1848: INSERT INTO BNE_INTERFACE_COLS_TL

1844: VN_SEQUENCE_NUM);
1845:
1846: -- Generate the Interface columns in table BNE_INTERFACE_COLS_TL
1847:
1848: INSERT INTO BNE_INTERFACE_COLS_TL
1849: (APPLICATION_ID,
1850: INTERFACE_CODE,
1851: SEQUENCE_NUM,
1852: LANGUAGE,

Line 2980: UPDATE BNE_INTERFACE_COLS_TL

2976: END IF;
2977:
2978: IF VV_INTERFACE_COL.REQUIRED_FLAG = 'Y'
2979: THEN
2980: UPDATE BNE_INTERFACE_COLS_TL
2981: SET USER_HINT = '*List - '||VV_DATA_TYPE
2982: WHERE APPLICATION_ID = P_APPLICATION_ID
2983: AND INTERFACE_CODE = VV_INTERFACE_COL.INTERFACE_CODE
2984: AND SEQUENCE_NUM = VV_INTERFACE_COL.SEQUENCE_NUM

Line 2987: UPDATE BNE_INTERFACE_COLS_TL

2983: AND INTERFACE_CODE = VV_INTERFACE_COL.INTERFACE_CODE
2984: AND SEQUENCE_NUM = VV_INTERFACE_COL.SEQUENCE_NUM
2985: ;
2986: ELSE
2987: UPDATE BNE_INTERFACE_COLS_TL
2988: SET USER_HINT = 'List - '||VV_DATA_TYPE
2989: WHERE APPLICATION_ID = P_APPLICATION_ID
2990: AND INTERFACE_CODE = VV_INTERFACE_COL.INTERFACE_CODE
2991: AND SEQUENCE_NUM = VV_INTERFACE_COL.SEQUENCE_NUM

Line 3196: UPDATE BNE_INTERFACE_COLS_TL

3192: END IF;
3193:
3194: IF VV_INTERFACE_COL.REQUIRED_FLAG = 'Y'
3195: THEN
3196: UPDATE BNE_INTERFACE_COLS_TL
3197: SET USER_HINT = '*List - '||VV_DATA_TYPE
3198: WHERE APPLICATION_ID = P_APPLICATION_ID
3199: AND INTERFACE_CODE = VV_INTERFACE_COL.INTERFACE_CODE
3200: AND SEQUENCE_NUM = VV_INTERFACE_COL.SEQUENCE_NUM

Line 3203: UPDATE BNE_INTERFACE_COLS_TL

3199: AND INTERFACE_CODE = VV_INTERFACE_COL.INTERFACE_CODE
3200: AND SEQUENCE_NUM = VV_INTERFACE_COL.SEQUENCE_NUM
3201: ;
3202: ELSE
3203: UPDATE BNE_INTERFACE_COLS_TL
3204: SET USER_HINT = 'List - '||VV_DATA_TYPE
3205: WHERE APPLICATION_ID = P_APPLICATION_ID
3206: AND INTERFACE_CODE = VV_INTERFACE_COL.INTERFACE_CODE
3207: AND SEQUENCE_NUM = VV_INTERFACE_COL.SEQUENCE_NUM

Line 3344: UPDATE BNE_INTERFACE_COLS_TL

3340: END IF;
3341:
3342: IF VV_INTERFACE_COL.REQUIRED_FLAG = 'Y'
3343: THEN
3344: UPDATE BNE_INTERFACE_COLS_TL
3345: SET USER_HINT = '*List - '||VV_DATA_TYPE
3346: WHERE APPLICATION_ID = P_APPLICATION_ID
3347: AND INTERFACE_CODE = VV_INTERFACE_COL.INTERFACE_CODE
3348: AND SEQUENCE_NUM = VV_INTERFACE_COL.SEQUENCE_NUM

Line 3351: UPDATE BNE_INTERFACE_COLS_TL

3347: AND INTERFACE_CODE = VV_INTERFACE_COL.INTERFACE_CODE
3348: AND SEQUENCE_NUM = VV_INTERFACE_COL.SEQUENCE_NUM
3349: ;
3350: ELSE
3351: UPDATE BNE_INTERFACE_COLS_TL
3352: SET USER_HINT = 'List - '||VV_DATA_TYPE
3353: WHERE APPLICATION_ID = P_APPLICATION_ID
3354: AND INTERFACE_CODE = VV_INTERFACE_COL.INTERFACE_CODE
3355: AND SEQUENCE_NUM = VV_INTERFACE_COL.SEQUENCE_NUM

Line 4116: UPDATE BNE_INTERFACE_COLS_TL

4112: WHERE APPLICATION_ID = P_APPLICATION_ID
4113: AND INTERFACE_CODE = VV_INTERFACE_CODE
4114: AND INTERFACE_COL_NAME = VV_INTERFACE_COL_NAME;
4115:
4116: UPDATE BNE_INTERFACE_COLS_TL
4117: SET
4118: USER_HINT = TRIM(P_USER_HINT),
4119: PROMPT_LEFT = TRIM(P_PROMPT_LEFT),
4120: PROMPT_ABOVE = TRIM(P_PROMPT_ABOVE),

Line 4514: DELETE FROM BNE_INTERFACE_COLS_TL

4510: WHERE APPLICATION_ID = P_APPLICATION_ID
4511: AND INTERFACE_CODE = P_INTERFACE_CODE
4512: AND SEQUENCE_NUM = P_SEQUENCE_NUM;
4513:
4514: DELETE FROM BNE_INTERFACE_COLS_TL
4515: WHERE APPLICATION_ID = P_APPLICATION_ID
4516: AND INTERFACE_CODE = P_INTERFACE_CODE
4517: AND SEQUENCE_NUM = P_SEQUENCE_NUM;
4518:

Line 5675: -- BNE_INTERFACE_COLS_TL table. --

5671: --------------------------------------------------------------------------------
5672: -- PROCEDURE: UPDATE_INTERFACE_COLUMN_TEXT --
5673: -- --
5674: -- DESCRIPTION: Procedure updates the user text in the --
5675: -- BNE_INTERFACE_COLS_TL table. --
5676: -- --
5677: -- PARAMETERS: --
5678: -- --
5679: -- MODIFICATION HISTORY --

Line 5692: -- Update the required row in BNE_INTERFACE_COLS_TL only where P_LANGUAGE is populated

5688: P_USER_HELP_TEXT IN VARCHAR2, P_USER_ID IN NUMBER)
5689: IS
5690: BEGIN
5691:
5692: -- Update the required row in BNE_INTERFACE_COLS_TL only where P_LANGUAGE is populated
5693: IF (P_LANGUAGE IS NOT NULL) THEN
5694: UPDATE BNE_INTERFACE_COLS_TL
5695: SET USER_HINT = P_USER_HINT,
5696: PROMPT_LEFT = P_PROMPT_LEFT,

Line 5694: UPDATE BNE_INTERFACE_COLS_TL

5690: BEGIN
5691:
5692: -- Update the required row in BNE_INTERFACE_COLS_TL only where P_LANGUAGE is populated
5693: IF (P_LANGUAGE IS NOT NULL) THEN
5694: UPDATE BNE_INTERFACE_COLS_TL
5695: SET USER_HINT = P_USER_HINT,
5696: PROMPT_LEFT = P_PROMPT_LEFT,
5697: USER_HELP_TEXT = P_USER_HELP_TEXT,
5698: PROMPT_ABOVE = P_PROMPT_ABOVE,