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_PARAM_LIST_ITEMS

Line 234: -- BNE_ATTRIBUTES and BNE_PARAM_LIST_ITEMS. --

230: -- the API Parameters. --
231: -- If the Parameter List already exists, no new seed --
232: -- data will be generated. --
233: -- Inserts into tables BNE_PARAM_LISTS_B/TL, --
234: -- BNE_ATTRIBUTES and BNE_PARAM_LIST_ITEMS. --
235: -- --
236: -- PARAMETERS: --
237: -- --
238: -- MODIFICATION HISTORY --

Line 248: -- BNE_PARAM_LIST_ITEMS table. --

244: -- removing the need to use ATTRIBUTE30 to store the --
245: -- INTERFACE_ID (This was previously a fix that gave --
246: -- us a way of linking the Attributes to the Param --
247: -- List Items in order to insert ATTRIBUTE_ID in the --
248: -- BNE_PARAM_LIST_ITEMS table. --
249: -- 30-JUL-2002 KPEET Removed check for existing API call in --
250: -- BNE_ATTRIBUTES table as customers will sometimes --
251: -- need to define overloaded APIs. The check against --
252: -- BNE_PARAM_LIST is sufficient as this is based on --

Line 462: INSERT INTO BNE_PARAM_LIST_ITEMS

458: API_PARAMS_REC.LAST_UPDATE_DATE);
459:
460: -- Generate the Parameter List Items
461:
462: INSERT INTO BNE_PARAM_LIST_ITEMS
463: (APPLICATION_ID,
464: PARAM_LIST_CODE,
465: SEQUENCE_NUM,
466: OBJECT_VERSION_NUMBER,

Line 2297: BNE_PARAM_LIST_ITEMS_PKG.LOAD_ROW (

2293:
2294: IF P_EFFECTIVE_DATE_COL IS NOT NULL
2295: THEN
2296: VV_PARAM_SEQ_NUM := VV_PARAM_SEQ_NUM + 1;
2297: BNE_PARAM_LIST_ITEMS_PKG.LOAD_ROW (
2298: x_param_list_asn => P_APPLICATION_SHORT_NAME,
2299: x_param_list_code => P_PARAM_LIST_CODE,
2300: x_sequence_num => VV_PARAM_SEQ_NUM,
2301: x_object_version_number => 1,

Line 2322: BNE_PARAM_LIST_ITEMS_PKG.LOAD_ROW (

2318:
2319: IF P_VRULE IS NOT NULL
2320: THEN
2321: VV_PARAM_SEQ_NUM := VV_PARAM_SEQ_NUM + 1;
2322: BNE_PARAM_LIST_ITEMS_PKG.LOAD_ROW (
2323: x_param_list_asn => P_APPLICATION_SHORT_NAME,
2324: x_param_list_code => P_PARAM_LIST_CODE,
2325: x_sequence_num => VV_PARAM_SEQ_NUM,
2326: x_object_version_number => 1,

Line 2390: BNE_PARAM_LIST_ITEMS_PKG.LOAD_ROW (

2386: x_oa_flex_code => NULL,
2387: x_oa_flex_num => NULL
2388: );
2389:
2390: BNE_PARAM_LIST_ITEMS_PKG.LOAD_ROW (
2391: x_param_list_asn => P_APPLICATION_SHORT_NAME,
2392: x_param_list_code => P_PARAM_LIST_CODE,
2393: x_sequence_num => VV_PARAM_SEQ_NUM,
2394: x_object_version_number => 1,

Line 2415: BNE_PARAM_LIST_ITEMS_PKG.LOAD_ROW (

2411:
2412: IF P_WINDOW_WIDTH IS NOT NULL AND P_WINDOW_WIDTH > 0
2413: THEN
2414: VV_PARAM_SEQ_NUM := VV_PARAM_SEQ_NUM + 1;
2415: BNE_PARAM_LIST_ITEMS_PKG.LOAD_ROW (
2416: x_param_list_asn => P_APPLICATION_SHORT_NAME,
2417: x_param_list_code => P_PARAM_LIST_CODE,
2418: x_sequence_num => VV_PARAM_SEQ_NUM,
2419: x_object_version_number => 1,

Line 2440: BNE_PARAM_LIST_ITEMS_PKG.LOAD_ROW (

2436:
2437: IF P_WINDOW_HEIGHT IS NOT NULL AND P_WINDOW_HEIGHT > 0
2438: THEN
2439: VV_PARAM_SEQ_NUM := VV_PARAM_SEQ_NUM + 1;
2440: BNE_PARAM_LIST_ITEMS_PKG.LOAD_ROW (
2441: x_param_list_asn => P_APPLICATION_SHORT_NAME,
2442: x_param_list_code => P_PARAM_LIST_CODE,
2443: x_sequence_num => VV_PARAM_SEQ_NUM,
2444: x_object_version_number => 1,

Line 2560: BNE_PARAM_LIST_ITEMS_PKG.LOAD_ROW (

2556: x_oa_flex_num => NULL
2557: );
2558:
2559:
2560: BNE_PARAM_LIST_ITEMS_PKG.LOAD_ROW (
2561: x_param_list_asn => P_APPLICATION_SHORT_NAME,
2562: x_param_list_code => P_PARAM_LIST_CODE,
2563: x_sequence_num => VV_PARAM_SEQ_NUM,
2564: x_object_version_number => 1,

Line 2585: BNE_PARAM_LIST_ITEMS_PKG.LOAD_ROW (

2581:
2582: IF P_TABLE_COLUMNS IS NOT NULL
2583: THEN
2584: VV_PARAM_SEQ_NUM := VV_PARAM_SEQ_NUM + 1;
2585: BNE_PARAM_LIST_ITEMS_PKG.LOAD_ROW (
2586: x_param_list_asn => P_APPLICATION_SHORT_NAME,
2587: x_param_list_code => P_PARAM_LIST_CODE,
2588: x_sequence_num => VV_PARAM_SEQ_NUM,
2589: x_object_version_number => 1,

Line 2610: BNE_PARAM_LIST_ITEMS_PKG.LOAD_ROW (

2606:
2607: IF P_TABLE_SELECT_COLUMNS IS NOT NULL
2608: THEN
2609: VV_PARAM_SEQ_NUM := VV_PARAM_SEQ_NUM + 1;
2610: BNE_PARAM_LIST_ITEMS_PKG.LOAD_ROW (
2611: x_param_list_asn => P_APPLICATION_SHORT_NAME,
2612: x_param_list_code => P_PARAM_LIST_CODE,
2613: x_sequence_num => VV_PARAM_SEQ_NUM,
2614: x_object_version_number => 1,

Line 2635: BNE_PARAM_LIST_ITEMS_PKG.LOAD_ROW (

2631:
2632: IF P_TABLE_COLUMN_ALIAS IS NOT NULL
2633: THEN
2634: VV_PARAM_SEQ_NUM := VV_PARAM_SEQ_NUM + 1;
2635: BNE_PARAM_LIST_ITEMS_PKG.LOAD_ROW (
2636: x_param_list_asn => P_APPLICATION_SHORT_NAME,
2637: x_param_list_code => P_PARAM_LIST_CODE,
2638: x_sequence_num => VV_PARAM_SEQ_NUM,
2639: x_object_version_number => 1,

Line 2661: BNE_PARAM_LIST_ITEMS_PKG.LOAD_ROW (

2657:
2658: IF P_TABLE_SORT_ORDER IS NOT NULL
2659: THEN
2660: VV_PARAM_SEQ_NUM := VV_PARAM_SEQ_NUM + 1;
2661: BNE_PARAM_LIST_ITEMS_PKG.LOAD_ROW (
2662: x_param_list_asn => P_APPLICATION_SHORT_NAME,
2663: x_param_list_code => P_PARAM_LIST_CODE,
2664: x_sequence_num => VV_PARAM_SEQ_NUM,
2665: x_object_version_number => 1,

Line 2729: BNE_PARAM_LIST_ITEMS_PKG.LOAD_ROW (

2725: x_oa_flex_code => NULL,
2726: x_oa_flex_num => NULL
2727: );
2728:
2729: BNE_PARAM_LIST_ITEMS_PKG.LOAD_ROW (
2730: x_param_list_asn => P_APPLICATION_SHORT_NAME,
2731: x_param_list_code => P_PARAM_LIST_CODE,
2732: x_sequence_num => VV_PARAM_SEQ_NUM,
2733: x_object_version_number => 1,

Line 2754: BNE_PARAM_LIST_ITEMS_PKG.LOAD_ROW (

2750:
2751: IF P_WINDOW_WIDTH IS NOT NULL AND P_WINDOW_WIDTH > 0
2752: THEN
2753: VV_PARAM_SEQ_NUM := VV_PARAM_SEQ_NUM + 1;
2754: BNE_PARAM_LIST_ITEMS_PKG.LOAD_ROW (
2755: x_param_list_asn => P_APPLICATION_SHORT_NAME,
2756: x_param_list_code => P_PARAM_LIST_CODE,
2757: x_sequence_num => VV_PARAM_SEQ_NUM,
2758: x_object_version_number => 1,

Line 2779: BNE_PARAM_LIST_ITEMS_PKG.LOAD_ROW (

2775:
2776: IF P_WINDOW_HEIGHT IS NOT NULL AND P_WINDOW_HEIGHT > 0
2777: THEN
2778: VV_PARAM_SEQ_NUM := VV_PARAM_SEQ_NUM + 1;
2779: BNE_PARAM_LIST_ITEMS_PKG.LOAD_ROW (
2780: x_param_list_asn => P_APPLICATION_SHORT_NAME,
2781: x_param_list_code => P_PARAM_LIST_CODE,
2782: x_sequence_num => VV_PARAM_SEQ_NUM,
2783: x_object_version_number => 1,

Line 2805: BNE_PARAM_LIST_ITEMS_PKG.LOAD_ROW (

2801:
2802: IF P_TABLE_BLOCK_SIZE IS NOT NULL AND P_TABLE_BLOCK_SIZE > 0
2803: THEN
2804: VV_PARAM_SEQ_NUM := VV_PARAM_SEQ_NUM + 1;
2805: BNE_PARAM_LIST_ITEMS_PKG.LOAD_ROW (
2806: x_param_list_asn => P_APPLICATION_SHORT_NAME,
2807: x_param_list_code => P_PARAM_LIST_CODE,
2808: x_sequence_num => VV_PARAM_SEQ_NUM,
2809: x_object_version_number => 1,

Line 5194: FROM BNE_PARAM_LIST_ITEMS

5190: AND ATTRIBUTE_APP_ID IS NOT NULL
5191: AND ATTRIBUTE_CODE IS NOT NULL
5192: UNION
5193: SELECT ATTRIBUTE_APP_ID, ATTRIBUTE_CODE
5194: FROM BNE_PARAM_LIST_ITEMS
5195: WHERE APPLICATION_ID = P_APPLICATION_ID
5196: AND PARAM_LIST_CODE = P_PARAM_LIST_CODE
5197: AND ATTRIBUTE_APP_ID IS NOT NULL
5198: AND ATTRIBUTE_CODE IS NOT NULL

Line 5201: FROM BNE_PARAM_LIST_ITEMS I, BNE_PARAM_DEFNS_B D

5197: AND ATTRIBUTE_APP_ID IS NOT NULL
5198: AND ATTRIBUTE_CODE IS NOT NULL
5199: UNION
5200: SELECT D.ATTRIBUTE_APP_ID, D.ATTRIBUTE_CODE
5201: FROM BNE_PARAM_LIST_ITEMS I, BNE_PARAM_DEFNS_B D
5202: WHERE I.APPLICATION_ID = P_APPLICATION_ID
5203: AND I.PARAM_LIST_CODE = P_PARAM_LIST_CODE
5204: AND I.PARAM_DEFN_APP_ID = D.APPLICATION_ID
5205: AND I.PARAM_DEFN_CODE = D.PARAM_DEFN_CODE

Line 5218: FROM BNE_PARAM_LIST_ITEMS I

5214: BEGIN
5215: SELECT PARAM_DEFN_APP_ID, PARAM_DEFN_CODE
5216: BULK COLLECT
5217: INTO VV_DEFN_KEYS
5218: FROM BNE_PARAM_LIST_ITEMS I
5219: WHERE APPLICATION_ID = P_APPLICATION_ID
5220: AND PARAM_LIST_CODE = P_PARAM_LIST_CODE
5221: AND PARAM_DEFN_APP_ID IS NOT NULL
5222: AND PARAM_DEFN_CODE IS NOT NULL;

Line 5236: DELETE FROM BNE_PARAM_LIST_ITEMS

5232: DELETE FROM BNE_PARAM_LISTS_TL
5233: WHERE APPLICATION_ID = P_APPLICATION_ID
5234: AND PARAM_LIST_CODE = P_PARAM_LIST_CODE;
5235:
5236: DELETE FROM BNE_PARAM_LIST_ITEMS
5237: WHERE APPLICATION_ID = P_APPLICATION_ID
5238: AND PARAM_LIST_CODE = P_PARAM_LIST_CODE;
5239:
5240: DELETE FROM BNE_PARAM_GROUPS_B

Line 5260: FROM BNE_PARAM_LIST_ITEMS

5256: FOR I IN 1..VV_DEFN_KEYS.LAST
5257: LOOP
5258: SELECT COUNT(*)
5259: INTO VV_DUMMY
5260: FROM BNE_PARAM_LIST_ITEMS
5261: WHERE PARAM_DEFN_APP_ID = VV_DEFN_KEYS(I).APP_ID
5262: AND PARAM_DEFN_CODE = VV_DEFN_KEYS(I).CODE;
5263:
5264: IF VV_DUMMY = 0

Line 5321: FROM BNE_PARAM_LIST_ITEMS

5317: FROM BNE_PARAM_GROUPS_B
5318: WHERE ATTRIBUTE_APP_ID = VV_ATTRIBUTE_KEYS(I).APP_ID
5319: AND ATTRIBUTE_CODE = VV_ATTRIBUTE_KEYS(I).CODE)
5320: AND NOT EXISTS (SELECT 1
5321: FROM BNE_PARAM_LIST_ITEMS
5322: WHERE ATTRIBUTE_APP_ID = VV_ATTRIBUTE_KEYS(I).APP_ID
5323: AND ATTRIBUTE_CODE = VV_ATTRIBUTE_KEYS(I).CODE)
5324: AND NOT EXISTS (SELECT 1
5325: FROM BNE_PARAM_DEFNS_B