[Home] [Help]
607: --IN:
608: -- 1. p_pk_column_name_value_pairs
609: -- This variable would contain an array of type EGO_COL_NAME_VALUE_PAIR_ARRAY with the PK values
610: -- 2. p_external_attr_value_pairs
611: -- This variable wsould contain an array of attribute value pairs (EGO_COL_NAME_VALUE_PAIR_TABLE)
612: --IN/OUT:
613: -- 1. x_po_uda_usage_object_array
614: -- This variable of type PO_UDA_USAGE_OBJECT_ARRAY contains data of hhe usages.
615: -- 2. x_attr_name_value_pairs
627: PROCEDURE POPULATE_EMPTY_AGS
628: (
629: p_template_id IN NUMBER
630: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
631: ,p_external_attr_value_pairs IN EGO_COL_NAME_VALUE_PAIR_TABLE
632: ,p_address_lookup_type IN VARCHAR2 DEFAULT NULL
633: ,x_po_uda_usage_object_array IN OUT NOCOPY PO_UDA_USAGE_OBJECT_ARRAY
634: ,x_attr_name_value_pairs IN OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
635: ,x_attributes_row_table IN OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
1137: -- 2. p_event
1138: -- This variable would contain the event type (execution code)
1139: --IN/OUT:
1140: -- 1. x_external_attr_value_pairs
1141: -- This variable wsould contain an array of attribute value pairs (EGO_COL_NAME_VALUE_PAIR_TABLE)
1142: -- 2. x_pk_column_name_value_pairs
1143: -- This variable would contain an array of type EGO_COL_NAME_VALUE_PAIR_ARRAY with the PK values
1144: -- 3. x_attr_name_value_pairs
1145: -- This variable would contain an array of type EGO_USER_ATTR_DATA_TABLE with the template details
1156: PROCEDURE EXECUTE_IMPORT_UDA_FUNCTION
1157: (
1158: p_template_id IN NUMBER
1159: ,p_event IN VARCHAR2
1160: ,x_external_attr_value_pairs IN OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_TABLE
1161: ,x_pk_column_name_value_pairs IN OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_ARRAY
1162: ,x_attr_name_value_pairs IN OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
1163: ,x_attributes_row_table IN OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
1164: ,x_return_status OUT NOCOPY VARCHAR2
1496: --IN/OUT:
1497: -- 1. x_po_uda_usage_object_array
1498: -- This variable of type PO_UDA_USAGE_OBJECT_ARRAY contains data of hhe usages.
1499: -- 2. x_external_attr_value_pairs
1500: -- This variable would contain an array of attribute value pairs (EGO_COL_NAME_VALUE_PAIR_TABLE)
1501: --OUT:
1502: -- 1. x_return_status - Generic Out parameter having return status
1503: -- 2. x_errorcode - Generic Out parameter having error code
1504: -- 3. x_msg_count - Generic Out parameter having return msg Count
1514: ,p_pk3_value IN NUMBER DEFAULT NULL
1515: ,p_pk4_value IN NUMBER DEFAULT NULL
1516: ,p_pk5_value IN NUMBER DEFAULT NULL
1517: ,x_po_uda_usage_object_array IN OUT NOCOPY PO_UDA_USAGE_OBJECT_ARRAY
1518: ,x_external_attr_value_pairs IN OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_TABLE
1519: ,x_return_status OUT NOCOPY VARCHAR2
1520: ,x_errorcode OUT NOCOPY NUMBER
1521: ,x_msg_count OUT NOCOPY NUMBER
1522: ,x_msg_data OUT NOCOPY VARCHAR2
1906: d_progress := 390;
1907:
1908: IF x_external_attr_value_pairs IS NULL THEN
1909: d_progress := 400;
1910: x_external_attr_value_pairs := EGO_COL_NAME_VALUE_PAIR_TABLE();
1911: END IF;
1912: d_progress := 410;
1913:
1914: PO_UDA_DEFAULTING_PKG.DEBUG('Before EXECUTE_IMPORT_UDA_FUNCTION (XV) ' || x_return_status, d_progress);
2214: l_po_lines_tbl po_tbl_number;
2215: l_template_id_tbl po_tbl_number;
2216: l_draft_id_tbl po_tbl_number;
2217: x_po_uda_usage_object_array PO_UDA_USAGE_OBJECT_ARRAY;
2218: x_external_attr_value_pairs EGO_COL_NAME_VALUE_PAIR_TABLE;-- := new EGO_COL_NAME_VALUE_PAIR_TABLE();
2219: x_return_status VARCHAR2(100) := null;
2220: x_msg_data VARCHAR2(100) := null;
2221: x_errorcode NUMBER := null;
2222: x_msg_count NUMBER := 0;