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 235: -- BNE_ATTRIBUTES and BNE_PARAM_LIST_ITEMS. --

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

Line 249: -- BNE_PARAM_LIST_ITEMS table. --

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

Line 463: INSERT INTO BNE_PARAM_LIST_ITEMS

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

Line 2206: BNE_PARAM_LIST_ITEMS_PKG.LOAD_ROW (

2202:
2203: IF P_EFFECTIVE_DATE_COL IS NOT NULL
2204: THEN
2205: VV_PARAM_SEQ_NUM := VV_PARAM_SEQ_NUM + 1;
2206: BNE_PARAM_LIST_ITEMS_PKG.LOAD_ROW (
2207: x_param_list_asn => P_APPLICATION_SHORT_NAME,
2208: x_param_list_code => P_PARAM_LIST_CODE,
2209: x_sequence_num => VV_PARAM_SEQ_NUM,
2210: x_object_version_number => 1,

Line 2231: BNE_PARAM_LIST_ITEMS_PKG.LOAD_ROW (

2227:
2228: IF P_VRULE IS NOT NULL
2229: THEN
2230: VV_PARAM_SEQ_NUM := VV_PARAM_SEQ_NUM + 1;
2231: BNE_PARAM_LIST_ITEMS_PKG.LOAD_ROW (
2232: x_param_list_asn => P_APPLICATION_SHORT_NAME,
2233: x_param_list_code => P_PARAM_LIST_CODE,
2234: x_sequence_num => VV_PARAM_SEQ_NUM,
2235: x_object_version_number => 1,

Line 2299: BNE_PARAM_LIST_ITEMS_PKG.LOAD_ROW (

2295: x_oa_flex_code => NULL,
2296: x_oa_flex_num => NULL
2297: );
2298:
2299: BNE_PARAM_LIST_ITEMS_PKG.LOAD_ROW (
2300: x_param_list_asn => P_APPLICATION_SHORT_NAME,
2301: x_param_list_code => P_PARAM_LIST_CODE,
2302: x_sequence_num => VV_PARAM_SEQ_NUM,
2303: x_object_version_number => 1,

Line 2324: BNE_PARAM_LIST_ITEMS_PKG.LOAD_ROW (

2320:
2321: IF P_WINDOW_WIDTH IS NOT NULL AND P_WINDOW_WIDTH > 0
2322: THEN
2323: VV_PARAM_SEQ_NUM := VV_PARAM_SEQ_NUM + 1;
2324: BNE_PARAM_LIST_ITEMS_PKG.LOAD_ROW (
2325: x_param_list_asn => P_APPLICATION_SHORT_NAME,
2326: x_param_list_code => P_PARAM_LIST_CODE,
2327: x_sequence_num => VV_PARAM_SEQ_NUM,
2328: x_object_version_number => 1,

Line 2349: BNE_PARAM_LIST_ITEMS_PKG.LOAD_ROW (

2345:
2346: IF P_WINDOW_HEIGHT IS NOT NULL AND P_WINDOW_HEIGHT > 0
2347: THEN
2348: VV_PARAM_SEQ_NUM := VV_PARAM_SEQ_NUM + 1;
2349: BNE_PARAM_LIST_ITEMS_PKG.LOAD_ROW (
2350: x_param_list_asn => P_APPLICATION_SHORT_NAME,
2351: x_param_list_code => P_PARAM_LIST_CODE,
2352: x_sequence_num => VV_PARAM_SEQ_NUM,
2353: x_object_version_number => 1,

Line 2469: BNE_PARAM_LIST_ITEMS_PKG.LOAD_ROW (

2465: x_oa_flex_num => NULL
2466: );
2467:
2468:
2469: BNE_PARAM_LIST_ITEMS_PKG.LOAD_ROW (
2470: x_param_list_asn => P_APPLICATION_SHORT_NAME,
2471: x_param_list_code => P_PARAM_LIST_CODE,
2472: x_sequence_num => VV_PARAM_SEQ_NUM,
2473: x_object_version_number => 1,

Line 2494: BNE_PARAM_LIST_ITEMS_PKG.LOAD_ROW (

2490:
2491: IF P_TABLE_COLUMNS IS NOT NULL
2492: THEN
2493: VV_PARAM_SEQ_NUM := VV_PARAM_SEQ_NUM + 1;
2494: BNE_PARAM_LIST_ITEMS_PKG.LOAD_ROW (
2495: x_param_list_asn => P_APPLICATION_SHORT_NAME,
2496: x_param_list_code => P_PARAM_LIST_CODE,
2497: x_sequence_num => VV_PARAM_SEQ_NUM,
2498: x_object_version_number => 1,

Line 2519: BNE_PARAM_LIST_ITEMS_PKG.LOAD_ROW (

2515:
2516: IF P_TABLE_SELECT_COLUMNS IS NOT NULL
2517: THEN
2518: VV_PARAM_SEQ_NUM := VV_PARAM_SEQ_NUM + 1;
2519: BNE_PARAM_LIST_ITEMS_PKG.LOAD_ROW (
2520: x_param_list_asn => P_APPLICATION_SHORT_NAME,
2521: x_param_list_code => P_PARAM_LIST_CODE,
2522: x_sequence_num => VV_PARAM_SEQ_NUM,
2523: x_object_version_number => 1,

Line 2544: BNE_PARAM_LIST_ITEMS_PKG.LOAD_ROW (

2540:
2541: IF P_TABLE_COLUMN_ALIAS IS NOT NULL
2542: THEN
2543: VV_PARAM_SEQ_NUM := VV_PARAM_SEQ_NUM + 1;
2544: BNE_PARAM_LIST_ITEMS_PKG.LOAD_ROW (
2545: x_param_list_asn => P_APPLICATION_SHORT_NAME,
2546: x_param_list_code => P_PARAM_LIST_CODE,
2547: x_sequence_num => VV_PARAM_SEQ_NUM,
2548: x_object_version_number => 1,

Line 2570: BNE_PARAM_LIST_ITEMS_PKG.LOAD_ROW (

2566:
2567: IF P_TABLE_SORT_ORDER IS NOT NULL
2568: THEN
2569: VV_PARAM_SEQ_NUM := VV_PARAM_SEQ_NUM + 1;
2570: BNE_PARAM_LIST_ITEMS_PKG.LOAD_ROW (
2571: x_param_list_asn => P_APPLICATION_SHORT_NAME,
2572: x_param_list_code => P_PARAM_LIST_CODE,
2573: x_sequence_num => VV_PARAM_SEQ_NUM,
2574: x_object_version_number => 1,

Line 2638: BNE_PARAM_LIST_ITEMS_PKG.LOAD_ROW (

2634: x_oa_flex_code => NULL,
2635: x_oa_flex_num => NULL
2636: );
2637:
2638: BNE_PARAM_LIST_ITEMS_PKG.LOAD_ROW (
2639: x_param_list_asn => P_APPLICATION_SHORT_NAME,
2640: x_param_list_code => P_PARAM_LIST_CODE,
2641: x_sequence_num => VV_PARAM_SEQ_NUM,
2642: x_object_version_number => 1,

Line 2663: BNE_PARAM_LIST_ITEMS_PKG.LOAD_ROW (

2659:
2660: IF P_WINDOW_WIDTH IS NOT NULL AND P_WINDOW_WIDTH > 0
2661: THEN
2662: VV_PARAM_SEQ_NUM := VV_PARAM_SEQ_NUM + 1;
2663: BNE_PARAM_LIST_ITEMS_PKG.LOAD_ROW (
2664: x_param_list_asn => P_APPLICATION_SHORT_NAME,
2665: x_param_list_code => P_PARAM_LIST_CODE,
2666: x_sequence_num => VV_PARAM_SEQ_NUM,
2667: x_object_version_number => 1,

Line 2688: BNE_PARAM_LIST_ITEMS_PKG.LOAD_ROW (

2684:
2685: IF P_WINDOW_HEIGHT IS NOT NULL AND P_WINDOW_HEIGHT > 0
2686: THEN
2687: VV_PARAM_SEQ_NUM := VV_PARAM_SEQ_NUM + 1;
2688: BNE_PARAM_LIST_ITEMS_PKG.LOAD_ROW (
2689: x_param_list_asn => P_APPLICATION_SHORT_NAME,
2690: x_param_list_code => P_PARAM_LIST_CODE,
2691: x_sequence_num => VV_PARAM_SEQ_NUM,
2692: x_object_version_number => 1,

Line 2714: BNE_PARAM_LIST_ITEMS_PKG.LOAD_ROW (

2710:
2711: IF P_TABLE_BLOCK_SIZE IS NOT NULL AND P_TABLE_BLOCK_SIZE > 0
2712: THEN
2713: VV_PARAM_SEQ_NUM := VV_PARAM_SEQ_NUM + 1;
2714: BNE_PARAM_LIST_ITEMS_PKG.LOAD_ROW (
2715: x_param_list_asn => P_APPLICATION_SHORT_NAME,
2716: x_param_list_code => P_PARAM_LIST_CODE,
2717: x_sequence_num => VV_PARAM_SEQ_NUM,
2718: x_object_version_number => 1,

Line 5103: FROM BNE_PARAM_LIST_ITEMS

5099: AND ATTRIBUTE_APP_ID IS NOT NULL
5100: AND ATTRIBUTE_CODE IS NOT NULL
5101: UNION
5102: SELECT ATTRIBUTE_APP_ID, ATTRIBUTE_CODE
5103: FROM BNE_PARAM_LIST_ITEMS
5104: WHERE APPLICATION_ID = P_APPLICATION_ID
5105: AND PARAM_LIST_CODE = P_PARAM_LIST_CODE
5106: AND ATTRIBUTE_APP_ID IS NOT NULL
5107: AND ATTRIBUTE_CODE IS NOT NULL

Line 5110: FROM BNE_PARAM_LIST_ITEMS I, BNE_PARAM_DEFNS_B D

5106: AND ATTRIBUTE_APP_ID IS NOT NULL
5107: AND ATTRIBUTE_CODE IS NOT NULL
5108: UNION
5109: SELECT D.ATTRIBUTE_APP_ID, D.ATTRIBUTE_CODE
5110: FROM BNE_PARAM_LIST_ITEMS I, BNE_PARAM_DEFNS_B D
5111: WHERE I.APPLICATION_ID = P_APPLICATION_ID
5112: AND I.PARAM_LIST_CODE = P_PARAM_LIST_CODE
5113: AND I.PARAM_DEFN_APP_ID = D.APPLICATION_ID
5114: AND I.PARAM_DEFN_CODE = D.PARAM_DEFN_CODE

Line 5127: FROM BNE_PARAM_LIST_ITEMS I

5123: BEGIN
5124: SELECT PARAM_DEFN_APP_ID, PARAM_DEFN_CODE
5125: BULK COLLECT
5126: INTO VV_DEFN_KEYS
5127: FROM BNE_PARAM_LIST_ITEMS I
5128: WHERE APPLICATION_ID = P_APPLICATION_ID
5129: AND PARAM_LIST_CODE = P_PARAM_LIST_CODE
5130: AND PARAM_DEFN_APP_ID IS NOT NULL
5131: AND PARAM_DEFN_CODE IS NOT NULL;

Line 5145: DELETE FROM BNE_PARAM_LIST_ITEMS

5141: DELETE FROM BNE_PARAM_LISTS_TL
5142: WHERE APPLICATION_ID = P_APPLICATION_ID
5143: AND PARAM_LIST_CODE = P_PARAM_LIST_CODE;
5144:
5145: DELETE FROM BNE_PARAM_LIST_ITEMS
5146: WHERE APPLICATION_ID = P_APPLICATION_ID
5147: AND PARAM_LIST_CODE = P_PARAM_LIST_CODE;
5148:
5149: DELETE FROM BNE_PARAM_GROUPS_B

Line 5169: FROM BNE_PARAM_LIST_ITEMS

5165: FOR I IN 1..VV_DEFN_KEYS.LAST
5166: LOOP
5167: SELECT COUNT(*)
5168: INTO VV_DUMMY
5169: FROM BNE_PARAM_LIST_ITEMS
5170: WHERE PARAM_DEFN_APP_ID = VV_DEFN_KEYS(I).APP_ID
5171: AND PARAM_DEFN_CODE = VV_DEFN_KEYS(I).CODE;
5172:
5173: IF VV_DUMMY = 0

Line 5230: FROM BNE_PARAM_LIST_ITEMS

5226: FROM BNE_PARAM_GROUPS_B
5227: WHERE ATTRIBUTE_APP_ID = VV_ATTRIBUTE_KEYS(I).APP_ID
5228: AND ATTRIBUTE_CODE = VV_ATTRIBUTE_KEYS(I).CODE)
5229: AND NOT EXISTS (SELECT 1
5230: FROM BNE_PARAM_LIST_ITEMS
5231: WHERE ATTRIBUTE_APP_ID = VV_ATTRIBUTE_KEYS(I).APP_ID
5232: AND ATTRIBUTE_CODE = VV_ATTRIBUTE_KEYS(I).CODE)
5233: AND NOT EXISTS (SELECT 1
5234: FROM BNE_PARAM_DEFNS_B

Line 5593: FROM bne_param_list_items

5589: WHERE application_id
5590: || ':'
5591: || param_list_code IN
5592: (SELECT String_value
5593: FROM bne_param_list_items
5594: WHERE (application_id = P_APPLICATION_ID and param_list_code = P_PARAM_LIST_CODE)
5595: AND String_value is not null
5596: AND substr(string_value, 4, 1) = ':'
5597: );