DBA Data[Home] [Help]

APPS.PON_UDA_IMPORT_PKG dependencies on EGO_COL_NAME_VALUE_PAIR_TABLE

Line 705: -- This variable wsould contain an array of attribute value pairs (EGO_COL_NAME_VALUE_PAIR_TABLE)

701: --IN:
702: -- 1. p_pk_column_name_value_pairs
703: -- This variable would contain an array of type EGO_COL_NAME_VALUE_PAIR_ARRAY with the PK values
704: -- 2. p_external_attr_value_pairs
705: -- This variable wsould contain an array of attribute value pairs (EGO_COL_NAME_VALUE_PAIR_TABLE)
706: --IN/OUT:
707: -- 1. x_po_uda_usage_object_array
708: -- This variable of type PO_UDA_USAGE_OBJECT_ARRAY contains data of hhe usages.
709: -- 2. x_attr_name_value_pairs

Line 725: ,p_external_attr_value_pairs IN EGO_COL_NAME_VALUE_PAIR_TABLE

721: PROCEDURE POPULATE_EMPTY_AGS
722: (
723: p_template_id IN NUMBER
724: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
725: ,p_external_attr_value_pairs IN EGO_COL_NAME_VALUE_PAIR_TABLE
726: ,p_address_lookup_type IN VARCHAR2 DEFAULT NULL
727: ,x_po_uda_usage_object_array IN OUT NOCOPY PO_UDA_USAGE_OBJECT_ARRAY
728: ,x_attr_name_value_pairs IN OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
729: ,x_attributes_row_table IN OUT NOCOPY EGO_USER_ATTR_ROW_TABLE

Line 1210: -- This variable wsould contain an array of attribute value pairs (EGO_COL_NAME_VALUE_PAIR_TABLE)

1206: -- 2. p_event
1207: -- This variable would contain the event type (execution code)
1208: --IN/OUT:
1209: -- 1. x_external_attr_value_pairs
1210: -- This variable wsould contain an array of attribute value pairs (EGO_COL_NAME_VALUE_PAIR_TABLE)
1211: -- 2. x_pk_column_name_value_pairs
1212: -- This variable would contain an array of type EGO_COL_NAME_VALUE_PAIR_ARRAY with the PK values
1213: -- 3. x_attr_name_value_pairs
1214: -- This variable would contain an array of type EGO_USER_ATTR_DATA_TABLE with the template details

Line 1229: ,x_external_attr_value_pairs IN OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_TABLE

1225: PROCEDURE EXECUTE_IMPORT_UDA_FUNCTION
1226: (
1227: p_template_id IN NUMBER
1228: ,p_event IN VARCHAR2
1229: ,x_external_attr_value_pairs IN OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_TABLE
1230: ,x_pk_column_name_value_pairs IN OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_ARRAY
1231: ,x_attr_name_value_pairs IN OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
1232: ,x_attributes_row_table IN OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
1233: ,x_return_status OUT NOCOPY VARCHAR2

Line 1567: -- This variable would contain an array of attribute value pairs (EGO_COL_NAME_VALUE_PAIR_TABLE)

1563: --IN/OUT:
1564: -- 1. x_po_uda_usage_object_array
1565: -- This variable of type PO_UDA_USAGE_OBJECT_ARRAY contains data of hhe usages.
1566: -- 2. x_external_attr_value_pairs
1567: -- This variable would contain an array of attribute value pairs (EGO_COL_NAME_VALUE_PAIR_TABLE)
1568: --OUT:
1569: -- 1. x_return_status - Generic Out parameter having return status
1570: -- 2. x_errorcode - Generic Out parameter having error code
1571: -- 3. x_msg_count - Generic Out parameter having return msg Count

Line 1585: ,x_external_attr_value_pairs IN OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_TABLE

1581: ,p_pk3_value IN NUMBER DEFAULT NULL
1582: ,p_pk4_value IN NUMBER DEFAULT NULL
1583: ,p_pk5_value IN NUMBER DEFAULT NULL
1584: ,x_po_uda_usage_object_array IN OUT NOCOPY PO_UDA_USAGE_OBJECT_ARRAY
1585: ,x_external_attr_value_pairs IN OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_TABLE
1586: ,x_return_status OUT NOCOPY VARCHAR2
1587: ,x_errorcode OUT NOCOPY NUMBER
1588: ,x_msg_count OUT NOCOPY NUMBER
1589: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1954: x_external_attr_value_pairs := EGO_COL_NAME_VALUE_PAIR_TABLE();

1950: d_progress := 390;
1951:
1952: IF x_external_attr_value_pairs IS NULL THEN
1953: d_progress := 400;
1954: x_external_attr_value_pairs := EGO_COL_NAME_VALUE_PAIR_TABLE();
1955: END IF;
1956: d_progress := 410;
1957:
1958: PON_UDA_IMPORT_PKG.DEBUG('Before EXECUTE_IMPORT_UDA_FUNCTION (XV) ' || x_return_status, d_progress);

Line 2363: ,x_external_attr_value_pairs IN OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_TABLE

2359: PROCEDURE SET_EXT_ATTR_NAME_VALUE_PAIR
2360: (
2361: p_ext_attr_name IN VARCHAR2
2362: ,p_ext_attr_value IN VARCHAR2
2363: ,x_external_attr_value_pairs IN OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_TABLE
2364: )
2365: IS
2366: MSG_DATA_IND NUMBER := 1;
2367: MSG_COUNT_IND NUMBER := 2;

Line 2393: x_external_attr_value_pairs := EGO_COL_NAME_VALUE_PAIR_TABLE(

2389: PON_UDA_IMPORT_PKG.DEBUG(' p_ext_attr_name ' || p_ext_attr_name, 0);
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

Line 2538: ,x_external_attr_value_pairs IN OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_TABLE

2534:
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;

Line 2641: p_structure_array IN EGO_COL_NAME_VALUE_PAIR_TABLE

2637: END DEBUG;
2638:
2639: PROCEDURE DEBUG
2640: (
2641: p_structure_array IN EGO_COL_NAME_VALUE_PAIR_TABLE
2642: ,p_progress IN NUMBER
2643: )
2644: IS
2645: l_structure_ind NUMBER;