APPS.EGO_IMPORT_BATCH_COMPARE_PVT dependencies on EGO_COMPARE_VIEW_REC

Line 684: l_compare_REc SYSTEM.EGO_COMPARE_VIEW_REC;

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
688: l_int_val VARCHAR2(4000); --EGO_MTL_SY_ITEMS_EXT_B.C_EXT_ATTR40%TYPE;

Line 685: err_compare_rec SYSTEM.EGO_COMPARE_VIEW_REC;

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
688: l_int_val VARCHAR2(4000); --EGO_MTL_SY_ITEMS_EXT_B.C_EXT_ATTR40%TYPE;
689: l_val_set_clause VARCHAR2(12000); --keeping it that long for safety

Line 811: err_compare_rec := SYSTEM.EGO_COMPARE_VIEW_REC('', '', '','', '', '','', '', '','', '','','','','');

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();
815: err_compare_tbl(1) := err_compare_rec;

Line 855: l_compare_rec := SYSTEM.EGO_COMPARE_VIEW_REC('', '', '','','','','','','','','','','','','');

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
859: -- when p_mode is 1, THEN we need to compute the change policy

Line 2900: err_compare_rec := SYSTEM.EGO_COMPARE_VIEW_REC('', '', '','', '', '','', '', '','', '','','','','');

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();
2904: err_compare_tbl(1) := err_compare_rec;