DBA Data[Home] [Help]

APPS.EGO_IMPORT_UTIL_PVT dependencies on EGO_COMMON_PVT

Line 1662: l_def_style_catg_option := EGO_COMMON_PVT.GET_OPTION_VALUE('EGO_DEFAULT_STYLE_ALTERNATE_CATALOG');

1658: l_pdh_ss_id NUMBER := EGO_IMPORT_PVT.Get_Pdh_Source_System_Id;
1659: BEGIN
1660: RETCODE := '0';
1661: Debug_Conc_Log('Copy_New_Cat_Assgns_From_Style: Starting');
1662: l_def_style_catg_option := EGO_COMMON_PVT.GET_OPTION_VALUE('EGO_DEFAULT_STYLE_ALTERNATE_CATALOG');
1663: Debug_Conc_Log('Copy_New_Cat_Assgns_From_Style: l_def_style_catg_option='||l_def_style_catg_option);
1664: IF NVL(l_def_style_catg_option, 'N') <> 'Y' THEN
1665: Debug_Conc_Log('Copy_New_Cat_Assgns_From_Style: Defaulting is set to NO, so returning');
1666: RETCODE := '0';

Line 1748: l_def_style_catg_option := EGO_COMMON_PVT.GET_OPTION_VALUE('EGO_DEFAULT_STYLE_ALTERNATE_CATALOG');

1744: l_def_style_catg_option VARCHAR2(1);
1745: BEGIN
1746: RETCODE := '0';
1747: Debug_Conc_Log('Copy_Category_Assignments: Starting p_skus_only='||p_skus_only);
1748: l_def_style_catg_option := EGO_COMMON_PVT.GET_OPTION_VALUE('EGO_DEFAULT_STYLE_ALTERNATE_CATALOG');
1749: Debug_Conc_Log('Copy_Category_Assignments: l_def_style_catg_option='||l_def_style_catg_option);
1750: IF NVL(l_def_style_catg_option, 'N') <> 'Y' AND NVL(p_skus_only, 'Y') = 'Y' THEN
1751: Debug_Conc_Log('Copy_Category_Assignments: Defaulting is set to NO, so returning');
1752: RETCODE := '0';

Line 4948: l_def_style_org_option := EGO_COMMON_PVT.GET_OPTION_VALUE('EGO_DEFAULT_STYLE_ITEM_ORG');

4944: l_source_system_id NUMBER;
4945: l_def_style_org_option VARCHAR2(1);
4946: BEGIN
4947: Debug_Conc_Log('Default_Org_Assignments: Starting');
4948: l_def_style_org_option := EGO_COMMON_PVT.GET_OPTION_VALUE('EGO_DEFAULT_STYLE_ITEM_ORG');
4949: Debug_Conc_Log('Default_Org_Assignments: l_def_style_org_option='||l_def_style_org_option);
4950: IF NVL(l_def_style_org_option, 'N') <> 'Y' THEN
4951: RETCODE := '0';
4952: ERRBUF := NULL;

Line 5492: l_def_style_people_option := EGO_COMMON_PVT.GET_OPTION_VALUE('EGO_DEFAULT_STYLE_PEOPLE');

5488: l_end_date DATE;
5489: BEGIN
5490: Debug_Conc_Log('Default_Item_People: Starting');
5491: RETCODE := '0';
5492: l_def_style_people_option := EGO_COMMON_PVT.GET_OPTION_VALUE('EGO_DEFAULT_STYLE_PEOPLE');
5493:
5494: Debug_Conc_Log('Default_Item_People: Style to SKU copy option value-'||l_def_style_people_option);
5495: BEGIN
5496: SELECT SELECTION_FLAG INTO l_copy_people_option

Line 5676: l_def_style_people_option := EGO_COMMON_PVT.GET_OPTION_VALUE('EGO_DEFAULT_STYLE_PEOPLE');

5672: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
5673: BEGIN
5674: Debug_Conc_Log('Copy_Item_People_From_Style: Starting');
5675: RETCODE := '0';
5676: l_def_style_people_option := EGO_COMMON_PVT.GET_OPTION_VALUE('EGO_DEFAULT_STYLE_PEOPLE');
5677:
5678: Debug_Conc_Log('Copy_Item_People_From_Style: Style to SKU copy option value-'||l_def_style_people_option);
5679:
5680: IF NVL(l_def_style_people_option, 'N') = 'N' THEN

Line 5784: l_def_style_project_option := EGO_COMMON_PVT.GET_OPTION_VALUE('EGO_DEFAULT_STYLE_LC_PROJS');

5780: l_organization_id NUMBER;
5781: BEGIN
5782: Debug_Conc_Log('Copy_LC_Projects: Starting');
5783: RETCODE := '0';
5784: l_def_style_project_option := EGO_COMMON_PVT.GET_OPTION_VALUE('EGO_DEFAULT_STYLE_LC_PROJS');
5785:
5786: Debug_Conc_Log('Copy_LC_Projects: Style to SKU copy option value-'||l_def_style_project_option);
5787:
5788: IF NVL(l_def_style_project_option, 'N') = 'N' THEN