[Home] [Help]
527: -- 2. p_template_id
528: -- This variable would contain the template id for which the actions are to be executed
529: --IN/OUT:
530: -- 1. x_external_attr_value_pairs
531: -- This variable would contain an array of attribute value pairs (EGO_COL_NAME_VALUE_PAIR_TABLE)
532: --OUT:
533: -- 1. x_return_status - Generic Out parameter having return status
534: -- 2. x_errorcode - Generic Out parameter having error code
535: -- 3. x_msg_count - Generic Out parameter having return msg Count
545: ,p_pk4_value IN NUMBER DEFAULT NULL
546: ,p_pk5_value IN NUMBER DEFAULT NULL
547: ,p_template_id IN NUMBER
548: ,p_address_lookup_type IN VARCHAR2 DEFAULT NULL
549: ,x_external_attr_value_pairs IN OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_TABLE
550: ,x_return_status OUT NOCOPY VARCHAR2
551: ,x_errorcode OUT NOCOPY NUMBER
552: ,x_msg_count OUT NOCOPY NUMBER
553: ,x_msg_data OUT NOCOPY VARCHAR2
987: -- 3. p_address_lookup_type
988: -- This variable would contain the address lookup type to get the address type
989: --OUT:
990: -- 1. x_external_attr_value_pairs
991: -- This variable would contain an array of attribute value pairs (EGO_COL_NAME_VALUE_PAIR_TABLE)
992: -- 2. x_return_status - Generic Out parameter having return status
993: --
994: --End of Comments
995: --------------------------------------------------------------------------------------------------------------------
996: PROCEDURE PO_UDA_SUBMISSION_CHECK
997: (
998: p_po_header_id IN NUMBER
999: ,p_draft_id IN NUMBER
1000: ,x_external_attr_value_pairs OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_TABLE
1001: ,x_return_status OUT NOCOPY VARCHAR2
1002: ,x_msg_count OUT NOCOPY NUMBER
1003: )
1004: IS
1281: -- 3. p_address_lookup_type
1282: -- This variable would contain the address lookup type to get the address type
1283: --OUT:
1284: -- 1. x_external_attr_value_pairs
1285: -- This variable would contain an array of attribute value pairs (EGO_COL_NAME_VALUE_PAIR_TABLE)
1286: -- 2. x_return_status - Generic Out parameter having return status
1287: --
1288: --End of Comments
1289: --------------------------------------------------------------------------------------------------------------------
1291: (
1292: p_po_header_id IN NUMBER
1293: ,p_draft_id IN NUMBER
1294: ,p_doc_type IN VARCHAR2 DEFAULT 'MOD'
1295: ,x_external_attr_value_pairs OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_TABLE
1296: ,x_return_status OUT NOCOPY VARCHAR2
1297: )
1298: IS
1299: d_progress NUMBER := 0;
1710: -- 3. p_address_lookup_type
1711: -- This variable would contain the address lookup type to get the address type
1712: --IN/OUT:
1713: -- 1. x_external_attr_value_pairs
1714: -- This variable would contain an array of attribute value pairs (EGO_COL_NAME_VALUE_PAIR_TABLE)
1715: --OUT:
1716: -- 1. x_return_status - Generic Out parameter having return status
1717: -- 2. x_errorcode - Generic Out parameter having error code
1718: -- 3. x_msg_count - Generic Out parameter having return msg Count
1728: ,p_pk4_value IN NUMBER DEFAULT NULL
1729: ,p_pk5_value IN NUMBER DEFAULT NULL
1730: ,p_template_id IN NUMBER
1731: ,p_address_lookup_type IN VARCHAR2 DEFAULT NULL
1732: ,x_external_attr_value_pairs IN OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_TABLE
1733: ,x_return_status OUT NOCOPY VARCHAR2
1734: ,x_errorcode OUT NOCOPY NUMBER
1735: ,x_msg_count OUT NOCOPY NUMBER
1736: ,x_msg_data OUT NOCOPY VARCHAR2
1851: -- 2. p_template_id
1852: -- This variable would contain the template id for which the actions are to be executed
1853: --IN/OUT:
1854: -- 1. x_external_attr_value_pairs
1855: -- This variable would contain an array of attribute value pairs (EGO_COL_NAME_VALUE_PAIR_TABLE)
1856: -- 2. x_po_uda_usage_object_array
1857: -- This variable of type PO_UDA_USAGE_OBJECT_ARRAY contains data of the usages.
1858: -- 3. p_address_lookup_type
1859: -- This variable would contain the address lookup type to get the address type
1873: ,p_pk4_value IN NUMBER DEFAULT NULL
1874: ,p_pk5_value IN NUMBER DEFAULT NULL
1875: ,p_template_id IN NUMBER
1876: ,p_address_lookup_type IN VARCHAR2 DEFAULT NULL
1877: ,x_external_attr_value_pairs IN OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_TABLE
1878: ,x_po_uda_usage_object_array IN OUT NOCOPY PO_UDA_USAGE_OBJECT_ARRAY
1879: ,x_return_status OUT NOCOPY VARCHAR2
1880: ,x_errorcode OUT NOCOPY NUMBER
1881: ,x_msg_count OUT NOCOPY NUMBER
2244: l_pk_column_name_value EGO_COL_NAME_VALUE_PAIR_OBJ;
2245: l_attr_name_value EGO_USER_ATTR_DATA_OBJ;
2246: l_attributes_row ego_user_attr_row_obj;
2247: l_attr_group_request ego_attr_group_request_obj;
2248: l_external_attr_value_pairs EGO_COL_NAME_VALUE_PAIR_TABLE;
2249: ext_name_val_obj EGO_COL_NAME_VALUE_PAIR_OBJ;
2250:
2251: l_base_object_name VARCHAR2(200);
2252: l_failed_row_id_list VARCHAR2(2000);
2906: PROCEDURE SET_EXT_ATTR_NAME_VALUE_PAIR
2907: (
2908: p_ext_attr_name IN VARCHAR2
2909: ,p_ext_attr_value IN VARCHAR2
2910: ,x_external_attr_value_pairs IN OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_TABLE
2911: )
2912: IS
2913: MSG_DATA_IND NUMBER := 1;
2914: MSG_COUNT_IND NUMBER := 2;
2936: PO_UDA_DEFAULTING_PKG.DEBUG(' p_ext_attr_name ' || p_ext_attr_name, 0);
2937: PO_UDA_DEFAULTING_PKG.DEBUG(' p_ext_attr_value ' || p_ext_attr_value, 0);
2938:
2939: IF x_external_attr_value_pairs IS NULL THEN
2940: x_external_attr_value_pairs := EGO_COL_NAME_VALUE_PAIR_TABLE(
2941: EGO_COL_NAME_VALUE_PAIR_OBJ
2942: (
2943: 'x_msg_data'
2944: ,NULL
3081:
3082: PROCEDURE GET_EXT_ATTR_NAME_VALUE_PAIR
3083: (
3084: p_ext_attr_name IN VARCHAR2
3085: ,x_external_attr_value_pairs IN OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_TABLE
3086: ,x_ext_name_val_obj OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_OBJ
3087: )
3088: IS
3089: MSG_DATA_IND NUMBER := 1;
3189: END DEBUG;
3190:
3191: PROCEDURE DEBUG
3192: (
3193: p_structure_array IN EGO_COL_NAME_VALUE_PAIR_TABLE
3194: ,p_progress IN NUMBER
3195: )
3196: IS
3197: l_structure_ind NUMBER;