APPS.EGO_ORCHESTRATION_UTIL_PUB dependencies on EGO_ITM_USR_ATTR_INTRFC

Line 565: UPDATE EGO_ITM_USR_ATTR_INTRFC EIUAI

561: WHERE BUNDLE_COLLECTION_ID = X_BUNDLE_COLLECTION_ID)
562: AND ITEM_NUMBER IS NOT NULL;
563:
564: -- Updating items user attribute rows
565: UPDATE EGO_ITM_USR_ATTR_INTRFC EIUAI
566: SET TRANSACTION_TYPE = C_TRANSACTION_SYNC,
567: PROCESS_STATUS = C_INIT_PROCESS_FLAG,
568: SOURCE_SYSTEM_ID = (SELECT SOURCE_SYSTEM_ID
569: FROM EGO_IMPORT_BATCHES_B

Line 674: UPDATE EGO_ITM_USR_ATTR_INTRFC EIUAI

670: (SELECT BUNDLE_ID
671: FROM MTL_ITEM_BULKLOAD_RECS
672: WHERE BUNDLE_COLLECTION_ID = X_BUNDLE_COLLECTION_ID);
673:
674: UPDATE EGO_ITM_USR_ATTR_INTRFC EIUAI
675: SET pk2_value = (SELECT asa.VENDOR_SITE_ID
676: FROM ap_supplier_sites_all asa,
677: ap_supplier_sites_all asa2,
678: mtl_system_items_interface msii

Line 710: UPDATE EGO_ITM_USR_ATTR_INTRFC EIUAI

706: (SELECT BUNDLE_ID
707: FROM MTL_ITEM_BULKLOAD_RECS
708: WHERE BUNDLE_COLLECTION_ID = X_BUNDLE_COLLECTION_ID);
709:
710: UPDATE EGO_ITM_USR_ATTR_INTRFC EIUAI
711: SET pk2_value = (SELECT asa.VENDOR_SITE_ID
712: FROM ap_supplier_sites_all asa,
713: ap_supplier_sites_all asa2,
714: mtl_system_items_interface msii

Line 920: l_attr_numeric_value EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_NUM%TYPE;

916: l_row_identifier NUMBER;
917: l_attr_group_int_name VARCHAR2(255);
918: l_attr_int_name VARCHAR2(255);
919: l_attr_text_value VARCHAR2(255);
920: l_attr_numeric_value EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_NUM%TYPE;
921: l_attr_quant_unit_code EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE;
922: l_is_trans BOOLEAN;
923: l_xml_trans XMLTYPE;
924:

Line 921: l_attr_quant_unit_code EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE;

917: l_attr_group_int_name VARCHAR2(255);
918: l_attr_int_name VARCHAR2(255);
919: l_attr_text_value VARCHAR2(255);
920: l_attr_numeric_value EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_NUM%TYPE;
921: l_attr_quant_unit_code EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE;
922: l_is_trans BOOLEAN;
923: l_xml_trans XMLTYPE;
924:
925: l_xml_attr_grp_int_nm XMLTYPE;

Line 928: l_date_value EGO_ITM_USR_ATTR_INTRFC.attr_value_date%TYPE;

924:
925: l_xml_attr_grp_int_nm XMLTYPE;
926: l_xml_attr_int_nm XMLTYPE;
927: l_xml_attr_val XMLTYPE;
928: l_date_value EGO_ITM_USR_ATTR_INTRFC.attr_value_date%TYPE;
929:
930: BEGIN
931: FOR l_xml_AttrGrps IN c_AttributeGrps(p_xml, p_entity_name)
932: LOOP

Line 989: INSERT INTO EGO_ITM_USR_ATTR_INTRFC(

985: l_attr_numeric_value := l_xml_attr_val.getNumberVal();
986: l_attr_quant_unit_code := l_xml_Attrs.attributes.extract('/Attribute/ValueQuantity/@unitCode').getStringVal();
987: END IF;
988:
989: INSERT INTO EGO_ITM_USR_ATTR_INTRFC(
990: transaction_id,
991: bundle_id,
992: source_system_id,
993: source_system_reference,

Line 1049: PROCESS_TL_ROWS(p_table_name => 'EGO_ITM_USR_ATTR_INTRFC',

1045: FROM DUAL;
1046:
1047: IF l_xml_trans IS NOT NULL
1048: THEN
1049: PROCESS_TL_ROWS(p_table_name => 'EGO_ITM_USR_ATTR_INTRFC',
1050: p_batch_id => p_data_set_id,
1051: p_unique_id => l_row_identifier,
1052: p_bundle_id => p_bundle_id,
1053: p_xml_data => l_xml_trans,