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.PON_UDA_IMPORT_PKG dependencies on EGO_COL_NAME_VALUE_PAIR_OBJ

Line 422: EGO_COL_NAME_VALUE_PAIR_OBJ

418:
419: PON_UDA_IMPORT_PKG.DEBUG('Before constructing Class codes Array', d_progress);
420: x_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY
421: (
422: EGO_COL_NAME_VALUE_PAIR_OBJ
423: (
424: 'UDA_TEMPLATE_ID'
425: ,l_uda_template_id || ''
426: )

Line 750: l_pk_name_value_pair EGO_COL_NAME_VALUE_PAIR_OBJ;

746: l_data_level VARCHAR2(200);
747: l_sql_query VARCHAR2(4000);
748: l_check NUMBER;
749: v_query_hdl NUMBER;
750: l_pk_name_value_pair EGO_COL_NAME_VALUE_PAIR_OBJ;
751: l_attr_row_obj EGO_USER_ATTR_ROW_OBJ;
752: l_rows_processed NUMBER;
753: l_attr_grp_loc_index NUMBER;
754: l_row_identifier NUMBER;

Line 1252: ext_name_val_obj EGO_COL_NAME_VALUE_PAIR_OBJ;

1248: l_attr_id_index1 NUMBER;
1249: l_attr_obj EGO_USER_ATTR_DATA_OBJ;
1250: l_attr_obj1 EGO_USER_ATTR_DATA_OBJ;
1251: ext_attr_value_pairs_ind NUMBER;
1252: ext_name_val_obj EGO_COL_NAME_VALUE_PAIR_OBJ;
1253:
1254: g_uda_return_status VARCHAR2(2);
1255: uda_msg_data VARCHAR2(2000);
1256: uda_return_status VARCHAR2(2);

Line 1274: l_pk_column_name_value EGO_COL_NAME_VALUE_PAIR_OBJ;

1270: l_attr_name_value_pairs_ind NUMBER;
1271: l_attributes_row_table_ind NUMBER;
1272: l_ext_attr_value_pairs_ind NUMBER;
1273:
1274: l_pk_column_name_value EGO_COL_NAME_VALUE_PAIR_OBJ;
1275: l_attr_name_value EGO_USER_ATTR_DATA_OBJ;
1276: l_attributes_row ego_user_attr_row_obj;
1277: l_external_attr_value EGO_COL_NAME_VALUE_PAIR_OBJ;
1278:

Line 1277: l_external_attr_value EGO_COL_NAME_VALUE_PAIR_OBJ;

1273:
1274: l_pk_column_name_value EGO_COL_NAME_VALUE_PAIR_OBJ;
1275: l_attr_name_value EGO_USER_ATTR_DATA_OBJ;
1276: l_attributes_row ego_user_attr_row_obj;
1277: l_external_attr_value EGO_COL_NAME_VALUE_PAIR_OBJ;
1278:
1279: l_err_txt VARCHAR2(2000);
1280:
1281: BEGIN

Line 1385: ,p_dtlevel_col_value_pairs => EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ(l_data_level_name, l_data_level_id))

1381: EGO_EXT_FWK_PUB.EXECUTE_FUNCTION
1382: (
1383: p_Action_Id => l_action_id
1384: ,p_pk_col_value_pairs => x_pk_column_name_value_pairs
1385: ,p_dtlevel_col_value_pairs => EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ(l_data_level_name, l_data_level_id))
1386: ,x_attributes_row_table => l_attributes_row_table
1387: ,x_attributes_data_table => l_attr_name_value_pairs
1388: ,x_external_attrs_value_pairs => x_external_attr_value_pairs
1389: ,x_return_status => x_return_status

Line 2319: x_pk_column_name_value_pairs(x_pk_column_name_value_pairs.COUNT) := EGO_COL_NAME_VALUE_PAIR_OBJ

2315: END;
2316:
2317: IF p_pk1_value IS NOT NULL THEN
2318: x_pk_column_name_value_pairs.EXTEND(1);
2319: x_pk_column_name_value_pairs(x_pk_column_name_value_pairs.COUNT) := EGO_COL_NAME_VALUE_PAIR_OBJ
2320: (
2321: l_pk1_column_name, p_pk1_value
2322: );
2323: END IF;

Line 2326: x_pk_column_name_value_pairs(x_pk_column_name_value_pairs.COUNT) := EGO_COL_NAME_VALUE_PAIR_OBJ

2322: );
2323: END IF;
2324: IF p_pk2_value IS NOT NULL THEN
2325: x_pk_column_name_value_pairs.EXTEND(1);
2326: x_pk_column_name_value_pairs(x_pk_column_name_value_pairs.COUNT) := EGO_COL_NAME_VALUE_PAIR_OBJ
2327: (
2328: l_pk2_column_name, p_pk2_value
2329: );
2330: END IF;

Line 2333: x_pk_column_name_value_pairs(x_pk_column_name_value_pairs.COUNT) := EGO_COL_NAME_VALUE_PAIR_OBJ

2329: );
2330: END IF;
2331: IF p_pk3_value IS NOT NULL THEN
2332: x_pk_column_name_value_pairs.EXTEND(1);
2333: x_pk_column_name_value_pairs(x_pk_column_name_value_pairs.COUNT) := EGO_COL_NAME_VALUE_PAIR_OBJ
2334: (
2335: l_pk3_column_name, p_pk3_value
2336: );
2337: END IF;

Line 2340: x_pk_column_name_value_pairs(x_pk_column_name_value_pairs.COUNT) := EGO_COL_NAME_VALUE_PAIR_OBJ

2336: );
2337: END IF;
2338: IF p_pk4_value IS NOT NULL THEN
2339: x_pk_column_name_value_pairs.EXTEND(1);
2340: x_pk_column_name_value_pairs(x_pk_column_name_value_pairs.COUNT) := EGO_COL_NAME_VALUE_PAIR_OBJ
2341: (
2342: l_pk4_column_name, p_pk4_value
2343: );
2344: END IF;

Line 2347: x_pk_column_name_value_pairs(x_pk_column_name_value_pairs.COUNT) := EGO_COL_NAME_VALUE_PAIR_OBJ

2343: );
2344: END IF;
2345: IF p_pk5_value IS NOT NULL THEN
2346: x_pk_column_name_value_pairs.EXTEND(1);
2347: x_pk_column_name_value_pairs(x_pk_column_name_value_pairs.COUNT) := EGO_COL_NAME_VALUE_PAIR_OBJ
2348: (
2349: l_pk5_column_name, p_pk5_value
2350: );
2351: END IF;

Line 2394: EGO_COL_NAME_VALUE_PAIR_OBJ

2390: PON_UDA_IMPORT_PKG.DEBUG(' p_ext_attr_value ' || p_ext_attr_value, 0);
2391:
2392: IF x_external_attr_value_pairs IS NULL THEN
2393: x_external_attr_value_pairs := EGO_COL_NAME_VALUE_PAIR_TABLE(
2394: EGO_COL_NAME_VALUE_PAIR_OBJ
2395: (
2396: 'x_msg_data'
2397: ,NULL
2398: ),

Line 2399: EGO_COL_NAME_VALUE_PAIR_OBJ

2395: (
2396: 'x_msg_data'
2397: ,NULL
2398: ),
2399: EGO_COL_NAME_VALUE_PAIR_OBJ
2400: (
2401: 'x_msg_count'
2402: ,NULL
2403: ),

Line 2404: EGO_COL_NAME_VALUE_PAIR_OBJ

2400: (
2401: 'x_msg_count'
2402: ,NULL
2403: ),
2404: EGO_COL_NAME_VALUE_PAIR_OBJ
2405: (
2406: 'x_errorcode'
2407: ,NULL
2408: ),

Line 2409: EGO_COL_NAME_VALUE_PAIR_OBJ

2405: (
2406: 'x_errorcode'
2407: ,NULL
2408: ),
2409: EGO_COL_NAME_VALUE_PAIR_OBJ
2410: (
2411: 'x_return_status'
2412: ,NULL
2413: ),

Line 2414: EGO_COL_NAME_VALUE_PAIR_OBJ

2410: (
2411: 'x_return_status'
2412: ,NULL
2413: ),
2414: EGO_COL_NAME_VALUE_PAIR_OBJ
2415: (
2416: 'VENDOR_CONTACT_ID'
2417: ,NULL
2418: ),

Line 2419: EGO_COL_NAME_VALUE_PAIR_OBJ

2415: (
2416: 'VENDOR_CONTACT_ID'
2417: ,NULL
2418: ),
2419: EGO_COL_NAME_VALUE_PAIR_OBJ
2420: (
2421: 'VENDOR_SITE_ID'
2422: ,NULL
2423: ),

Line 2424: EGO_COL_NAME_VALUE_PAIR_OBJ

2420: (
2421: 'VENDOR_SITE_ID'
2422: ,NULL
2423: ),
2424: EGO_COL_NAME_VALUE_PAIR_OBJ
2425: (
2426: 'VENDOR_ID'
2427: ,NULL
2428: ),

Line 2429: EGO_COL_NAME_VALUE_PAIR_OBJ

2425: (
2426: 'VENDOR_ID'
2427: ,NULL
2428: ),
2429: EGO_COL_NAME_VALUE_PAIR_OBJ
2430: (
2431: 'ITEM_ID'
2432: ,NULL
2433: ),

Line 2434: EGO_COL_NAME_VALUE_PAIR_OBJ

2430: (
2431: 'ITEM_ID'
2432: ,NULL
2433: ),
2434: EGO_COL_NAME_VALUE_PAIR_OBJ
2435: (
2436: 'LINE_TYPE_ID'
2437: ,NULL
2438: ),

Line 2439: EGO_COL_NAME_VALUE_PAIR_OBJ

2435: (
2436: 'LINE_TYPE_ID'
2437: ,NULL
2438: ),
2439: EGO_COL_NAME_VALUE_PAIR_OBJ
2440: (
2441: 'SHIP_TO_LOC_ID'
2442: ,NULL
2443: ),

Line 2444: EGO_COL_NAME_VALUE_PAIR_OBJ

2440: (
2441: 'SHIP_TO_LOC_ID'
2442: ,NULL
2443: ),
2444: EGO_COL_NAME_VALUE_PAIR_OBJ
2445: (
2446: 'ORG_ID'
2447: ,NULL
2448: ),

Line 2449: EGO_COL_NAME_VALUE_PAIR_OBJ

2445: (
2446: 'ORG_ID'
2447: ,NULL
2448: ),
2449: EGO_COL_NAME_VALUE_PAIR_OBJ
2450: (
2451: 'AGENT_ID'
2452: ,NULL
2453: ),

Line 2454: EGO_COL_NAME_VALUE_PAIR_OBJ

2450: (
2451: 'AGENT_ID'
2452: ,NULL
2453: ),
2454: EGO_COL_NAME_VALUE_PAIR_OBJ
2455: (
2456: 'CONTRACT_TYPE'
2457: ,NULL
2458: ),

Line 2459: EGO_COL_NAME_VALUE_PAIR_OBJ

2455: (
2456: 'CONTRACT_TYPE'
2457: ,NULL
2458: ),
2459: EGO_COL_NAME_VALUE_PAIR_OBJ
2460: (
2461: 'CATEGORY_ID'
2462: ,NULL
2463: ),

Line 2464: EGO_COL_NAME_VALUE_PAIR_OBJ

2460: (
2461: 'CATEGORY_ID'
2462: ,NULL
2463: ),
2464: EGO_COL_NAME_VALUE_PAIR_OBJ
2465: (
2466: 'PREPARER_ID'
2467: ,NULL
2468: ),

Line 2469: EGO_COL_NAME_VALUE_PAIR_OBJ

2465: (
2466: 'PREPARER_ID'
2467: ,NULL
2468: ),
2469: EGO_COL_NAME_VALUE_PAIR_OBJ
2470: (
2471: 'BASE_AUCTION_HEADER_ID'
2472: ,NULL
2473: ),

Line 2474: EGO_COL_NAME_VALUE_PAIR_OBJ

2470: (
2471: 'BASE_AUCTION_HEADER_ID'
2472: ,NULL
2473: ),
2474: EGO_COL_NAME_VALUE_PAIR_OBJ
2475: (
2476: 'DELIMITER'
2477: ,NULL
2478: ),

Line 2479: EGO_COL_NAME_VALUE_PAIR_OBJ

2475: (
2476: 'DELIMITER'
2477: ,NULL
2478: ),
2479: EGO_COL_NAME_VALUE_PAIR_OBJ
2480: (
2481: 'p_source_doc_number'
2482: ,NULL
2483: )

Line 2528: x_external_attr_value_pairs(l_index) := EGO_COL_NAME_VALUE_PAIR_OBJ(p_ext_attr_name, p_ext_attr_value);

2524: PON_UDA_IMPORT_PKG.DEBUG('The Name Value Pair does not have an index defined (Check PON_UDA_IMPORT_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR)', 0);
2525: RETURN;
2526: END IF;
2527:
2528: x_external_attr_value_pairs(l_index) := EGO_COL_NAME_VALUE_PAIR_OBJ(p_ext_attr_name, p_ext_attr_value);
2529: EXCEPTION
2530: WHEN OTHERS THEN
2531: PON_UDA_IMPORT_PKG.DEBUG(SQLERRM, 0);
2532: RAISE;

Line 2539: ,x_ext_name_val_obj OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_OBJ

2535: PROCEDURE GET_EXT_ATTR_NAME_VALUE_PAIR
2536: (
2537: p_ext_attr_name IN VARCHAR2
2538: ,x_external_attr_value_pairs IN OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_TABLE
2539: ,x_ext_name_val_obj OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_OBJ
2540: )
2541: IS
2542: MSG_DATA_IND NUMBER := 1;
2543: MSG_COUNT_IND NUMBER := 2;

Line 2619: l_structure EGO_COL_NAME_VALUE_PAIR_OBJ;

2615: ,p_progress IN NUMBER
2616: )
2617: IS
2618: l_structure_ind NUMBER;
2619: l_structure EGO_COL_NAME_VALUE_PAIR_OBJ;
2620: BEGIN
2621: IF p_structure_array IS NOT NULL THEN
2622: l_structure_ind := p_structure_array.FIRST;
2623: WHILE (l_structure_ind IS NOT NULL AND l_structure_ind <= p_structure_array.LAST)

Line 2646: l_structure EGO_COL_NAME_VALUE_PAIR_OBJ;

2642: ,p_progress IN NUMBER
2643: )
2644: IS
2645: l_structure_ind NUMBER;
2646: l_structure EGO_COL_NAME_VALUE_PAIR_OBJ;
2647: BEGIN
2648: IF p_structure_array IS NOT NULL THEN
2649: l_structure_ind := p_structure_array.FIRST;
2650: WHILE (l_structure_ind IS NOT NULL AND l_structure_ind <= p_structure_array.LAST)