APPS.EGO_IMPORT_BATCH_COMPARE_PVT dependencies on EGO_COMPARE_VIEW_TABLE

Line 207: PROCEDURE populate_compare_tbl ( p_compare_table IN OUT NOCOPY SYSTEM.EGO_COMPARE_VIEW_TABLE ,

203:
204: /******************************************************************************
205: Populate data in sql table type to return the data.
206: *****************************************************************************/
207: PROCEDURE populate_compare_tbl ( p_compare_table IN OUT NOCOPY SYSTEM.EGO_COMPARE_VIEW_TABLE ,
208: p_index IN NUMBER ,
209: p_sel_item IN NUMBER ,
210: p_value IN VARCHAR2 ,
211: p_item1 IN NUMBER ,

Line 267: RETURN SYSTEM.EGO_COMPARE_VIEW_TABLE

263: p_supplier_id NUMBER DEFAULT NULL, -- R12C: New Parameter: Supplier Id
264: p_supplier_site_id NUMBER DEFAULT NULL, -- R12C: New Parameter: Supplier Site Id
265: p_bundle_id NUMBER DEFAULT NULL -- R12C: New Parameter passed only in case of GDSN Enable batches.
266: )
267: RETURN SYSTEM.EGO_COMPARE_VIEW_TABLE
268: IS
269: --------------------------------------------------------------
270: -- CURSOR FOR GETTING META DATA OF ITEM OPERATIONAL ATTRIBUTES
271: --------------------------------------------------------------

Line 683: l_compare_tbl SYSTEM.EGO_COMPARE_VIEW_TABLE ;

679: AND SOURCE_SYSTEM_REFERENCE = p_ss_record
680: AND BATCH_ID = p_batch_id
681: AND ORGANIZATION_id = p_org_id;
682:
683: l_compare_tbl SYSTEM.EGO_COMPARE_VIEW_TABLE ;
684: err_compare_tbl SYSTEM.EGO_COMPARE_VIEW_TABLE ;
685: l_compare_REc SYSTEM.EGO_COMPARE_VIEW_REC;
686: err_compare_rec SYSTEM.EGO_COMPARE_VIEW_REC;
687: l_str_value VARCHAR2(4000); --EGO_MTL_SY_ITEMS_EXT_B.C_EXT_ATTR40%TYPE;

Line 684: err_compare_tbl SYSTEM.EGO_COMPARE_VIEW_TABLE ;

680: AND BATCH_ID = p_batch_id
681: AND ORGANIZATION_id = p_org_id;
682:
683: l_compare_tbl SYSTEM.EGO_COMPARE_VIEW_TABLE ;
684: err_compare_tbl SYSTEM.EGO_COMPARE_VIEW_TABLE ;
685: l_compare_REc SYSTEM.EGO_COMPARE_VIEW_REC;
686: err_compare_rec SYSTEM.EGO_COMPARE_VIEW_REC;
687: l_str_value VARCHAR2(4000); --EGO_MTL_SY_ITEMS_EXT_B.C_EXT_ATTR40%TYPE;
688: l_sel_clause VARCHAR2(32000); --keeping the max limit

Line 811: err_compare_tbl := SYSTEM.EGO_COMPARE_VIEW_TABLE();

807: SELECT party_id INTO l_party_id_num
808: FROM ego_user_v
809: WHERE user_id = l_user_id;
810: EXCEPTION WHEN NO_DATA_FOUND THEN
811: err_compare_tbl := SYSTEM.EGO_COMPARE_VIEW_TABLE();
812: err_compare_rec := SYSTEM.EGO_COMPARE_VIEW_REC('', '', '','', '', '','', '', '','', '','','','','');
813: --err_compare_rec.ATTR_GROUP_DISP_NAME := 'Encountered error, No search conducted';
814: err_compare_rec.ATTR_GROUP_DISP_NAME := FND_MESSAGE.GET_STRING('EGO', 'EGO_PERSON_INVALID');
815: err_compare_tbl.EXTEND();

Line 855: l_compare_tbl := SYSTEM.EGO_COMPARE_VIEW_TABLE();

851: l_itemSupSiteOrg_lable := FND_MESSAGE.GET();
852: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_REVISION');
853: l_itemRev_lable := FND_MESSAGE.GET();
854:
855: l_compare_tbl := SYSTEM.EGO_COMPARE_VIEW_TABLE();
856: l_compare_rec := SYSTEM.EGO_COMPARE_VIEW_REC('', '', '','','','','','','','','','','','','');
857:
858: Debug_Message('Processing Item attributes (Primary and Operational) for Source System');
859: -- If called form confirmed tab - p_mode = 1

Line 2900: err_compare_tbl := SYSTEM.EGO_COMPARE_VIEW_TABLE();

2896: Debug_Message('Done GET_COMPARED_DATA Successfully at - '||TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS'));
2897: RETURN l_compare_tbl;
2898: EXCEPTION
2899: WHEN OTHERS THEN
2900: err_compare_tbl := SYSTEM.EGO_COMPARE_VIEW_TABLE();
2901: err_compare_rec := SYSTEM.EGO_COMPARE_VIEW_REC('', '', '','', '', '','', '', '','', '','','','','');
2902: --err_compare_rec.ATTR_GROUP_DISP_NAME := 'Encountered error, No search conducted';
2903: err_compare_rec.ATTR_GROUP_DISP_NAME := SQLERRM;
2904: err_compare_tbl.EXTEND();