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.

[Home] [Help]

APPS.BNE_INTEGRATOR_UTILS dependencies on BNE_INTERFACE_COLS_TL

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

838: P_SOURCE_LANG,
839: P_USER_ID)
840: LOOP
841:
842: -- Generate the interface columns in the BNE_INTERFACE_COLS_B and BNE_INTERFACE_COLS_TL tables
843:
844: INSERT INTO BNE_INTERFACE_COLS_B
845: (APPLICATION_ID, INTERFACE_CODE, OBJECT_VERSION_NUMBER, SEQUENCE_NUM, INTERFACE_COL_TYPE,
846: INTERFACE_COL_NAME, ENABLED_FLAG, REQUIRED_FLAG, DISPLAY_FLAG, READ_ONLY_FLAG, NOT_NULL_FLAG,

Line 873: INSERT INTO BNE_INTERFACE_COLS_TL

869: TABLE_COLUMN_REC.LAST_UPDATE_DATE);
870:
871: -- Generate the BNE_INTEFACE_COLS_TL columns
872:
873: INSERT INTO BNE_INTERFACE_COLS_TL
874: (APPLICATION_ID, INTERFACE_CODE, SEQUENCE_NUM, LANGUAGE, SOURCE_LANG, PROMPT_LEFT,
875: PROMPT_ABOVE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE)
876: VALUES
877: (TABLE_COLUMN_REC.APPLICATION_ID,

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

938: -- DESCRIPTION: Procedure creates an interface in the Web ADI --
939: -- repository for the first time. The Interface consists --
940: -- of API Parameters. --
941: -- This procedure inserts records into the BNE_INTERFACES, --
942: -- BNE_INTERFACE_COLS/TL tables. --
943: -- --
944: -- --
945: -- MODIFICATION HISTORY --
946: -- Date Username Description --

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

1202: API_PARAM_REC.LAST_UPDATE_DATE,
1203: API_PARAM_REC.DISPLAY_ORDER,
1204: API_PARAM_REC.UPLOAD_PARAM_LIST_ITEM_NUM);
1205:
1206: -- Generate the Interface columns in table BNE_INTERFACE_COLS_TL
1207:
1208: INSERT INTO BNE_INTERFACE_COLS_TL
1209: (APPLICATION_ID,
1210: INTERFACE_CODE,

Line 1208: INSERT INTO BNE_INTERFACE_COLS_TL

1204: API_PARAM_REC.UPLOAD_PARAM_LIST_ITEM_NUM);
1205:
1206: -- Generate the Interface columns in table BNE_INTERFACE_COLS_TL
1207:
1208: INSERT INTO BNE_INTERFACE_COLS_TL
1209: (APPLICATION_ID,
1210: INTERFACE_CODE,
1211: SEQUENCE_NUM,
1212: LANGUAGE,

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

1407: FROM BNE_CONTENT_COLS_B BCC
1408: WHERE BCC.APPLICATION_ID = P_APPLICATION_ID
1409: AND BCC.CONTENT_CODE = P_CONTENT_CODE;
1410:
1411: -- Generate the Interface Columns in the BNE_INTERFACE_COLS_TL table
1412:
1413: INSERT INTO BNE_INTERFACE_COLS_TL
1414: (APPLICATION_ID, INTERFACE_CODE, SEQUENCE_NUM, PROMPT_LEFT, PROMPT_ABOVE, LANGUAGE, SOURCE_LANG,
1415: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE)

Line 1413: INSERT INTO BNE_INTERFACE_COLS_TL

1409: AND BCC.CONTENT_CODE = P_CONTENT_CODE;
1410:
1411: -- Generate the Interface Columns in the BNE_INTERFACE_COLS_TL table
1412:
1413: INSERT INTO BNE_INTERFACE_COLS_TL
1414: (APPLICATION_ID, INTERFACE_CODE, SEQUENCE_NUM, PROMPT_LEFT, PROMPT_ABOVE, LANGUAGE, SOURCE_LANG,
1415: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE)
1416: SELECT P_APPLICATION_ID APPLICATION_ID,
1417: P_INTERFACE_CODE INTERFACE_CODE,

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

1522: 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,
1523: P_VAL_COMPONENT_CODE, P_OA_FLEX_NUM, P_OA_FLEX_APPLICATION_ID, P_DISPLAY_ORDER, P_UPLOAD_PARAM_LIST_ITEM_NUM,
1524: 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);
1525:
1526: -- Insert the required row in BNE_INTERFACE_COLS_TL only if P_LANGUAGE is populated
1527:
1528: IF (P_LANGUAGE IS NOT NULL) THEN
1529: INSERT INTO BNE_INTERFACE_COLS_TL
1530: (APPLICATION_ID, INTERFACE_CODE, SEQUENCE_NUM, LANGUAGE, SOURCE_LANG, USER_HINT, PROMPT_LEFT,

Line 1529: INSERT INTO BNE_INTERFACE_COLS_TL

1525:
1526: -- Insert the required row in BNE_INTERFACE_COLS_TL only if P_LANGUAGE is populated
1527:
1528: IF (P_LANGUAGE IS NOT NULL) THEN
1529: INSERT INTO BNE_INTERFACE_COLS_TL
1530: (APPLICATION_ID, INTERFACE_CODE, SEQUENCE_NUM, LANGUAGE, SOURCE_LANG, USER_HINT, PROMPT_LEFT,
1531: USER_HELP_TEXT, PROMPT_ABOVE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE)
1532: VALUES
1533: (P_APPLICATION_ID, P_INTERFACE_CODE, P_SEQUENCE_NUM, P_LANGUAGE, P_SOURCE_LANG, P_USER_HINT, P_PROMPT_LEFT,

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

1577: WHERE APPLICATION_ID = P_APPLICATION_ID
1578: AND INTERFACE_CODE = P_INTERFACE_CODE
1579: AND SEQUENCE_NUM = P_SEQUENCE_NUM;
1580:
1581: -- Update the required row in BNE_INTERFACE_COLS_TL only where P_LANGUAGE is populated
1582:
1583: IF (P_LANGUAGE IS NOT NULL) THEN
1584: UPDATE BNE_INTERFACE_COLS_TL
1585: SET USER_HINT = P_USER_HINT,

Line 1584: UPDATE BNE_INTERFACE_COLS_TL

1580:
1581: -- Update the required row in BNE_INTERFACE_COLS_TL only where P_LANGUAGE is populated
1582:
1583: IF (P_LANGUAGE IS NOT NULL) THEN
1584: UPDATE BNE_INTERFACE_COLS_TL
1585: SET USER_HINT = P_USER_HINT,
1586: PROMPT_LEFT = P_PROMPT_LEFT,
1587: USER_HELP_TEXT = P_USER_HELP_TEXT,
1588: PROMPT_ABOVE = P_PROMPT_ABOVE,

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

1751: API_PARAM_REC.LAST_UPDATE_DATE,
1752: VN_SEQUENCE_NUM,
1753: VN_SEQUENCE_NUM);
1754:
1755: -- Generate the Interface columns in table BNE_INTERFACE_COLS_TL
1756:
1757: INSERT INTO BNE_INTERFACE_COLS_TL
1758: (APPLICATION_ID,
1759: INTERFACE_CODE,

Line 1757: INSERT INTO BNE_INTERFACE_COLS_TL

1753: VN_SEQUENCE_NUM);
1754:
1755: -- Generate the Interface columns in table BNE_INTERFACE_COLS_TL
1756:
1757: INSERT INTO BNE_INTERFACE_COLS_TL
1758: (APPLICATION_ID,
1759: INTERFACE_CODE,
1760: SEQUENCE_NUM,
1761: LANGUAGE,

Line 2889: UPDATE BNE_INTERFACE_COLS_TL

2885: END IF;
2886:
2887: IF VV_INTERFACE_COL.REQUIRED_FLAG = 'Y'
2888: THEN
2889: UPDATE BNE_INTERFACE_COLS_TL
2890: SET USER_HINT = '*List - '||VV_DATA_TYPE
2891: WHERE APPLICATION_ID = P_APPLICATION_ID
2892: AND INTERFACE_CODE = VV_INTERFACE_COL.INTERFACE_CODE
2893: AND SEQUENCE_NUM = VV_INTERFACE_COL.SEQUENCE_NUM

Line 2896: UPDATE BNE_INTERFACE_COLS_TL

2892: AND INTERFACE_CODE = VV_INTERFACE_COL.INTERFACE_CODE
2893: AND SEQUENCE_NUM = VV_INTERFACE_COL.SEQUENCE_NUM
2894: ;
2895: ELSE
2896: UPDATE BNE_INTERFACE_COLS_TL
2897: SET USER_HINT = 'List - '||VV_DATA_TYPE
2898: WHERE APPLICATION_ID = P_APPLICATION_ID
2899: AND INTERFACE_CODE = VV_INTERFACE_COL.INTERFACE_CODE
2900: AND SEQUENCE_NUM = VV_INTERFACE_COL.SEQUENCE_NUM

Line 3105: UPDATE BNE_INTERFACE_COLS_TL

3101: END IF;
3102:
3103: IF VV_INTERFACE_COL.REQUIRED_FLAG = 'Y'
3104: THEN
3105: UPDATE BNE_INTERFACE_COLS_TL
3106: SET USER_HINT = '*List - '||VV_DATA_TYPE
3107: WHERE APPLICATION_ID = P_APPLICATION_ID
3108: AND INTERFACE_CODE = VV_INTERFACE_COL.INTERFACE_CODE
3109: AND SEQUENCE_NUM = VV_INTERFACE_COL.SEQUENCE_NUM

Line 3112: UPDATE BNE_INTERFACE_COLS_TL

3108: AND INTERFACE_CODE = VV_INTERFACE_COL.INTERFACE_CODE
3109: AND SEQUENCE_NUM = VV_INTERFACE_COL.SEQUENCE_NUM
3110: ;
3111: ELSE
3112: UPDATE BNE_INTERFACE_COLS_TL
3113: SET USER_HINT = 'List - '||VV_DATA_TYPE
3114: WHERE APPLICATION_ID = P_APPLICATION_ID
3115: AND INTERFACE_CODE = VV_INTERFACE_COL.INTERFACE_CODE
3116: AND SEQUENCE_NUM = VV_INTERFACE_COL.SEQUENCE_NUM

Line 3253: UPDATE BNE_INTERFACE_COLS_TL

3249: END IF;
3250:
3251: IF VV_INTERFACE_COL.REQUIRED_FLAG = 'Y'
3252: THEN
3253: UPDATE BNE_INTERFACE_COLS_TL
3254: SET USER_HINT = '*List - '||VV_DATA_TYPE
3255: WHERE APPLICATION_ID = P_APPLICATION_ID
3256: AND INTERFACE_CODE = VV_INTERFACE_COL.INTERFACE_CODE
3257: AND SEQUENCE_NUM = VV_INTERFACE_COL.SEQUENCE_NUM

Line 3260: UPDATE BNE_INTERFACE_COLS_TL

3256: AND INTERFACE_CODE = VV_INTERFACE_COL.INTERFACE_CODE
3257: AND SEQUENCE_NUM = VV_INTERFACE_COL.SEQUENCE_NUM
3258: ;
3259: ELSE
3260: UPDATE BNE_INTERFACE_COLS_TL
3261: SET USER_HINT = 'List - '||VV_DATA_TYPE
3262: WHERE APPLICATION_ID = P_APPLICATION_ID
3263: AND INTERFACE_CODE = VV_INTERFACE_COL.INTERFACE_CODE
3264: AND SEQUENCE_NUM = VV_INTERFACE_COL.SEQUENCE_NUM

Line 4025: UPDATE BNE_INTERFACE_COLS_TL

4021: WHERE APPLICATION_ID = P_APPLICATION_ID
4022: AND INTERFACE_CODE = VV_INTERFACE_CODE
4023: AND INTERFACE_COL_NAME = VV_INTERFACE_COL_NAME;
4024:
4025: UPDATE BNE_INTERFACE_COLS_TL
4026: SET
4027: USER_HINT = TRIM(P_USER_HINT),
4028: PROMPT_LEFT = TRIM(P_PROMPT_LEFT),
4029: PROMPT_ABOVE = TRIM(P_PROMPT_ABOVE),

Line 4423: DELETE FROM BNE_INTERFACE_COLS_TL

4419: WHERE APPLICATION_ID = P_APPLICATION_ID
4420: AND INTERFACE_CODE = P_INTERFACE_CODE
4421: AND SEQUENCE_NUM = P_SEQUENCE_NUM;
4422:
4423: DELETE FROM BNE_INTERFACE_COLS_TL
4424: WHERE APPLICATION_ID = P_APPLICATION_ID
4425: AND INTERFACE_CODE = P_INTERFACE_CODE
4426: AND SEQUENCE_NUM = P_SEQUENCE_NUM;
4427:

Line 5617: -- BNE_INTERFACE_COLS_TL table. --

5613: --------------------------------------------------------------------------------
5614: -- PROCEDURE: UPDATE_INTERFACE_COLUMN_TEXT --
5615: -- --
5616: -- DESCRIPTION: Procedure updates the user text in the --
5617: -- BNE_INTERFACE_COLS_TL table. --
5618: -- --
5619: -- PARAMETERS: --
5620: -- --
5621: -- MODIFICATION HISTORY --

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

5630: P_USER_HELP_TEXT IN VARCHAR2, P_USER_ID IN NUMBER)
5631: IS
5632: BEGIN
5633:
5634: -- Update the required row in BNE_INTERFACE_COLS_TL only where P_LANGUAGE is populated
5635: IF (P_LANGUAGE IS NOT NULL) THEN
5636: UPDATE BNE_INTERFACE_COLS_TL
5637: SET USER_HINT = P_USER_HINT,
5638: PROMPT_LEFT = P_PROMPT_LEFT,

Line 5636: UPDATE BNE_INTERFACE_COLS_TL

5632: BEGIN
5633:
5634: -- Update the required row in BNE_INTERFACE_COLS_TL only where P_LANGUAGE is populated
5635: IF (P_LANGUAGE IS NOT NULL) THEN
5636: UPDATE BNE_INTERFACE_COLS_TL
5637: SET USER_HINT = P_USER_HINT,
5638: PROMPT_LEFT = P_PROMPT_LEFT,
5639: USER_HELP_TEXT = P_USER_HELP_TEXT,
5640: PROMPT_ABOVE = P_PROMPT_ABOVE,