DBA Data[Home] [Help]

APPS.EGO_IMPORT_UTIL_PVT dependencies on EGO_ITEM_USER_ATTRS_CP_PUB

Line 1005: EGO_ITEM_USER_ATTRS_CP_PUB.Copy_data_to_Intf

1001: AND ext_prod.ATTR_GROUP_ID = eico.ATTR_GROUP_ID #';
1002:
1003: Debug_Conc_Log('Copy_UDA_Attributes: Calling copy for data level-'||i.DATA_LEVEL_ID);
1004:
1005: EGO_ITEM_USER_ATTRS_CP_PUB.Copy_data_to_Intf
1006: (
1007: p_api_version => 1.0
1008: ,p_commit => 'F'
1009: ,p_copy_from_intf_table => 'F'

Line 2359: EGO_ITEM_USER_ATTRS_CP_PUB.Copy_data_to_Intf

2355: ) #';
2356:
2357: Debug_Conc_Log('Default_User_Attrs_From_Prod: Defaulting Item Level UDAs from Style to SKUs');
2358:
2359: EGO_ITEM_USER_ATTRS_CP_PUB.Copy_data_to_Intf
2360: (
2361: p_api_version => 1.0
2362: ,p_commit => 'F'
2363: ,p_copy_from_intf_table => 'F'

Line 2481: EGO_ITEM_USER_ATTRS_CP_PUB.Copy_data_to_Intf

2477: ) #';
2478:
2479: Debug_Conc_Log('Default_User_Attrs_From_Prod: Defaulting Item Revision Level UDAs from Style to SKUs');
2480:
2481: EGO_ITEM_USER_ATTRS_CP_PUB.Copy_data_to_Intf
2482: (
2483: p_api_version => 1.0
2484: ,p_commit => 'F'
2485: ,p_copy_from_intf_table => 'F'

Line 2594: EGO_ITEM_USER_ATTRS_CP_PUB.Copy_data_to_Intf

2590: ) #';
2591:
2592: Debug_Conc_Log('Default_User_Attrs_From_Prod: Defaulting Item Revision Level UDAs for newly created revisions-'||l_src_sql);
2593:
2594: EGO_ITEM_USER_ATTRS_CP_PUB.Copy_data_to_Intf
2595: (
2596: p_api_version => 1.0
2597: ,p_commit => 'F'
2598: ,p_copy_from_intf_table => 'F'

Line 2704: EGO_ITEM_USER_ATTRS_CP_PUB.Copy_data_to_Intf

2700: )#';
2701:
2702: Debug_Conc_Log('Default_User_Attrs_From_Prod: Defaulting Item Org Level UDAs ');
2703:
2704: EGO_ITEM_USER_ATTRS_CP_PUB.Copy_data_to_Intf
2705: (
2706: p_api_version => 1.0
2707: ,p_commit => 'F'
2708: ,p_copy_from_intf_table => 'F'

Line 2860: EGO_ITEM_USER_ATTRS_CP_PUB.Copy_data_to_Intf

2856: ) #';
2857:
2858: Debug_Conc_Log('Default_User_Attrs_From_Prod: Defaulting Item Supplier Level UDAs ');
2859:
2860: EGO_ITEM_USER_ATTRS_CP_PUB.Copy_data_to_Intf
2861: (
2862: p_api_version => 1.0
2863: ,p_commit => 'F'
2864: ,p_copy_from_intf_table => 'F'

Line 2983: EGO_ITEM_USER_ATTRS_CP_PUB.Copy_data_to_Intf

2979: ) #';
2980:
2981: Debug_Conc_Log('Default_User_Attrs_From_Prod: Defaulting Item Supplier Site Level UDAs');
2982:
2983: EGO_ITEM_USER_ATTRS_CP_PUB.Copy_data_to_Intf
2984: (
2985: p_api_version => 1.0
2986: ,p_commit => 'F'
2987: ,p_copy_from_intf_table => 'F'

Line 3114: EGO_ITEM_USER_ATTRS_CP_PUB.Copy_data_to_Intf

3110: ) #';
3111:
3112: Debug_Conc_Log('Default_User_Attrs_From_Prod: Defaulting Item Supplier Site Org Level UDAs');
3113:
3114: EGO_ITEM_USER_ATTRS_CP_PUB.Copy_data_to_Intf
3115: (
3116: p_api_version => 1.0
3117: ,p_commit => 'F'
3118: ,p_copy_from_intf_table => 'F'

Line 3258: EGO_ITEM_USER_ATTRS_CP_PUB.Copy_data_to_Intf

3254: -- when copying from interface to interface, we do not need l_ag_sql, so passing dummy value
3255: l_ag_sql := 'SELECT NULL AS ATTR_GROUP_ID FROM DUAL WHERE 1 = 2';
3256: Debug_Conc_Log('Default_User_Attrs_From_Intf: Defaulting Item Org Level UDAs');
3257:
3258: EGO_ITEM_USER_ATTRS_CP_PUB.Copy_data_to_Intf
3259: (
3260: p_api_version => 1.0
3261: ,p_commit => 'F'
3262: ,p_copy_from_intf_table => 'T'

Line 3355: EGO_ITEM_USER_ATTRS_CP_PUB.Copy_data_to_Intf

3351: -- when copying from interface to interface, we do not need l_ag_sql, so passing dummy value
3352: l_ag_sql := 'SELECT NULL AS ATTR_GROUP_ID FROM DUAL WHERE 1 = 2';
3353: Debug_Conc_Log('Default_User_Attrs_From_Intf: Defaulting Item Supplier Level UDAs');
3354:
3355: EGO_ITEM_USER_ATTRS_CP_PUB.Copy_data_to_Intf
3356: (
3357: p_api_version => 1.0
3358: ,p_commit => 'F'
3359: ,p_copy_from_intf_table => 'T'

Line 3455: EGO_ITEM_USER_ATTRS_CP_PUB.Copy_data_to_Intf

3451: -- when copying from interface to interface, we do not need l_ag_sql, so passing dummy value
3452: l_ag_sql := 'SELECT NULL AS ATTR_GROUP_ID FROM DUAL WHERE 1 = 2';
3453: Debug_Conc_Log('Default_User_Attrs_From_Intf: Defaulting Item Supplier Site Level UDAs');
3454:
3455: EGO_ITEM_USER_ATTRS_CP_PUB.Copy_data_to_Intf
3456: (
3457: p_api_version => 1.0
3458: ,p_commit => 'F'
3459: ,p_copy_from_intf_table => 'T'

Line 3557: EGO_ITEM_USER_ATTRS_CP_PUB.Copy_data_to_Intf

3553: -- when copying from interface to interface, we do not need l_ag_sql, so passing dummy value
3554: l_ag_sql := 'SELECT NULL AS ATTR_GROUP_ID FROM DUAL WHERE 1 = 2';
3555: Debug_Conc_Log('Default_User_Attrs_From_Intf: Defaulting Item Supplier Site Org Level UDAs');
3556:
3557: EGO_ITEM_USER_ATTRS_CP_PUB.Copy_data_to_Intf
3558: (
3559: p_api_version => 1.0
3560: ,p_commit => 'F'
3561: ,p_copy_from_intf_table => 'T'

Line 4731: EGO_ITEM_USER_ATTRS_CP_PUB.Process_Item_User_Attrs_Data

4727: INV_EGO_REVISION_VALIDATE.Set_Process_Control_HTML_API('IMPORT'); -- Bug 10263673, set the flag to IMPORT, so that in EGOCIUAB.pls we check for this flag and do the template application only in this case.
4728:
4729: -- call UDA bulkloader in Validate Mode with security check
4730: Debug_Conc_Log('Preprocess_Import: Before calling UDA bulkloader in Validate Mode, with security check');
4731: EGO_ITEM_USER_ATTRS_CP_PUB.Process_Item_User_Attrs_Data
4732: (
4733: ERRBUF => l_errbuf,
4734: RETCODE => l_retcode,
4735: p_data_set_id => l_batch_id, -- bug 12693246 changed from p_batch_id to l_batch_id

Line 4742: Debug_Conc_Log('Preprocess_Import: Done EGO_ITEM_USER_ATTRS_CP_PUB.Process_Item_User_Attrs_Data with l_retcode, l_errbuf='||l_retcode||','||l_errbuf);

4738: );
4739:
4740: INV_EGO_REVISION_VALIDATE.Set_Process_Control_HTML_API(NULL); -- Bug 10263673
4741:
4742: Debug_Conc_Log('Preprocess_Import: Done EGO_ITEM_USER_ATTRS_CP_PUB.Process_Item_User_Attrs_Data with l_retcode, l_errbuf='||l_retcode||','||l_errbuf);
4743: IF NVL(l_retcode, '0') > RETCODE THEN
4744: RETCODE := l_retcode;
4745: ERRBUF := l_errbuf;
4746: END IF;

Line 4818: EGO_ITEM_USER_ATTRS_CP_PUB.Process_Item_User_Attrs_Data

4814: -- Fix for bug#9336604. Performance Fix Begin. Comment this validation call.
4815: --All Function generation attributes have been validated during previous calls.
4816: --So the defaulted UDAs can be validated later.
4817: /*Debug_Conc_Log('Preprocess_Import: Before calling UDA bulkloader in Validate Mode, ignoring security check');
4818: EGO_ITEM_USER_ATTRS_CP_PUB.Process_Item_User_Attrs_Data
4819: (
4820: ERRBUF => l_errbuf,
4821: RETCODE => l_retcode,
4822: p_data_set_id => l_batch_id, -- bug 12693246 changed from p_batch_id to l_batch_id

Line 4827: Debug_Conc_Log('Preprocess_Import: Done EGO_ITEM_USER_ATTRS_CP_PUB.Process_Item_User_Attrs_Data with l_retcode, l_errbuf='||l_retcode||','||l_errbuf);

4823: p_validate_only => FND_API.G_TRUE,
4824: p_ignore_security_for_validate => FND_API.G_TRUE
4825: );
4826:
4827: Debug_Conc_Log('Preprocess_Import: Done EGO_ITEM_USER_ATTRS_CP_PUB.Process_Item_User_Attrs_Data with l_retcode, l_errbuf='||l_retcode||','||l_errbuf);
4828: IF NVL(l_retcode, '0') > RETCODE THEN
4829: RETCODE := l_retcode;
4830: ERRBUF := l_errbuf;
4831: END IF;