DBA Data[Home] [Help]

APPS.EGO_IMPORT_UTIL_PVT dependencies on EGO_COMMON_PVT

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

1488: l_pdh_ss_id NUMBER := EGO_IMPORT_PVT.Get_Pdh_Source_System_Id;
1489: BEGIN
1490: RETCODE := '0';
1491: Debug_Conc_Log('Copy_New_Cat_Assgns_From_Style: Starting');
1492: l_def_style_catg_option := EGO_COMMON_PVT.GET_OPTION_VALUE('EGO_DEFAULT_STYLE_ALTERNATE_CATALOG');
1493: Debug_Conc_Log('Copy_New_Cat_Assgns_From_Style: l_def_style_catg_option='||l_def_style_catg_option);
1494: IF NVL(l_def_style_catg_option, 'N') <> 'Y' THEN
1495: Debug_Conc_Log('Copy_New_Cat_Assgns_From_Style: Defaulting is set to NO, so returning');
1496: RETCODE := '0';

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

1574: l_def_style_catg_option VARCHAR2(1);
1575: BEGIN
1576: RETCODE := '0';
1577: Debug_Conc_Log('Copy_Category_Assignments: Starting p_skus_only='||p_skus_only);
1578: l_def_style_catg_option := EGO_COMMON_PVT.GET_OPTION_VALUE('EGO_DEFAULT_STYLE_ALTERNATE_CATALOG');
1579: Debug_Conc_Log('Copy_Category_Assignments: l_def_style_catg_option='||l_def_style_catg_option);
1580: IF NVL(l_def_style_catg_option, 'N') <> 'Y' AND NVL(p_skus_only, 'Y') = 'Y' THEN
1581: Debug_Conc_Log('Copy_Category_Assignments: Defaulting is set to NO, so returning');
1582: RETCODE := '0';

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

4247: l_source_system_id NUMBER;
4248: l_def_style_org_option VARCHAR2(1);
4249: BEGIN
4250: Debug_Conc_Log('Default_Org_Assignments: Starting');
4251: l_def_style_org_option := EGO_COMMON_PVT.GET_OPTION_VALUE('EGO_DEFAULT_STYLE_ITEM_ORG');
4252: Debug_Conc_Log('Default_Org_Assignments: l_def_style_org_option='||l_def_style_org_option);
4253: IF NVL(l_def_style_org_option, 'N') <> 'Y' THEN
4254: RETCODE := '0';
4255: ERRBUF := NULL;

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

4738: l_end_date DATE;
4739: BEGIN
4740: Debug_Conc_Log('Default_Item_People: Starting');
4741: RETCODE := '0';
4742: l_def_style_people_option := EGO_COMMON_PVT.GET_OPTION_VALUE('EGO_DEFAULT_STYLE_PEOPLE');
4743:
4744: Debug_Conc_Log('Default_Item_People: Style to SKU copy option value-'||l_def_style_people_option);
4745: BEGIN
4746: SELECT SELECTION_FLAG INTO l_copy_people_option

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

4922: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
4923: BEGIN
4924: Debug_Conc_Log('Copy_Item_People_From_Style: Starting');
4925: RETCODE := '0';
4926: l_def_style_people_option := EGO_COMMON_PVT.GET_OPTION_VALUE('EGO_DEFAULT_STYLE_PEOPLE');
4927:
4928: Debug_Conc_Log('Copy_Item_People_From_Style: Style to SKU copy option value-'||l_def_style_people_option);
4929:
4930: IF NVL(l_def_style_people_option, 'N') = 'N' THEN

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

5030: l_organization_id NUMBER;
5031: BEGIN
5032: Debug_Conc_Log('Copy_LC_Projects: Starting');
5033: RETCODE := '0';
5034: l_def_style_project_option := EGO_COMMON_PVT.GET_OPTION_VALUE('EGO_DEFAULT_STYLE_LC_PROJS');
5035:
5036: Debug_Conc_Log('Copy_LC_Projects: Style to SKU copy option value-'||l_def_style_project_option);
5037:
5038: IF NVL(l_def_style_project_option, 'N') = 'N' THEN