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 682: l_compare_tbl SYSTEM.EGO_COMPARE_VIEW_TABLE ;

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

Line 683: err_compare_tbl SYSTEM.EGO_COMPARE_VIEW_TABLE ;

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

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

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

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

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

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

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