DBA Data[Home] [Help]

APPS.EGO_IMPORT_UTIL_PVT dependencies on EGO_ITEM_USER_ATTRS_CP_PUB

Line 904: EGO_ITEM_USER_ATTRS_CP_PUB.Copy_data_to_Intf

900: AND ext_prod.ATTR_GROUP_ID = eico.ATTR_GROUP_ID #';
901:
902: Debug_Conc_Log('Copy_UDA_Attributes: Calling copy for data level-'||i.DATA_LEVEL_ID);
903:
904: EGO_ITEM_USER_ATTRS_CP_PUB.Copy_data_to_Intf
905: (
906: p_api_version => 1.0
907: ,p_commit => 'F'
908: ,p_copy_from_intf_table => 'F'

Line 2185: EGO_ITEM_USER_ATTRS_CP_PUB.Copy_data_to_Intf

2181: ) #';
2182:
2183: Debug_Conc_Log('Default_User_Attrs_From_Prod: Defaulting Item Level UDAs from Style to SKUs');
2184:
2185: EGO_ITEM_USER_ATTRS_CP_PUB.Copy_data_to_Intf
2186: (
2187: p_api_version => 1.0
2188: ,p_commit => 'F'
2189: ,p_copy_from_intf_table => 'F'

Line 2301: EGO_ITEM_USER_ATTRS_CP_PUB.Copy_data_to_Intf

2297: ) #';
2298:
2299: Debug_Conc_Log('Default_User_Attrs_From_Prod: Defaulting Item Revision Level UDAs from Style to SKUs');
2300:
2301: EGO_ITEM_USER_ATTRS_CP_PUB.Copy_data_to_Intf
2302: (
2303: p_api_version => 1.0
2304: ,p_commit => 'F'
2305: ,p_copy_from_intf_table => 'F'

Line 2405: EGO_ITEM_USER_ATTRS_CP_PUB.Copy_data_to_Intf

2401: ) #';
2402:
2403: Debug_Conc_Log('Default_User_Attrs_From_Prod: Defaulting Item Revision Level UDAs for newly created revisions-'||l_src_sql);
2404:
2405: EGO_ITEM_USER_ATTRS_CP_PUB.Copy_data_to_Intf
2406: (
2407: p_api_version => 1.0
2408: ,p_commit => 'F'
2409: ,p_copy_from_intf_table => 'F'

Line 2515: EGO_ITEM_USER_ATTRS_CP_PUB.Copy_data_to_Intf

2511: )#';
2512:
2513: Debug_Conc_Log('Default_User_Attrs_From_Prod: Defaulting Item Org Level UDAs ');
2514:
2515: EGO_ITEM_USER_ATTRS_CP_PUB.Copy_data_to_Intf
2516: (
2517: p_api_version => 1.0
2518: ,p_commit => 'F'
2519: ,p_copy_from_intf_table => 'F'

Line 2671: EGO_ITEM_USER_ATTRS_CP_PUB.Copy_data_to_Intf

2667: ) #';
2668:
2669: Debug_Conc_Log('Default_User_Attrs_From_Prod: Defaulting Item Supplier Level UDAs ');
2670:
2671: EGO_ITEM_USER_ATTRS_CP_PUB.Copy_data_to_Intf
2672: (
2673: p_api_version => 1.0
2674: ,p_commit => 'F'
2675: ,p_copy_from_intf_table => 'F'

Line 2794: EGO_ITEM_USER_ATTRS_CP_PUB.Copy_data_to_Intf

2790: ) #';
2791:
2792: Debug_Conc_Log('Default_User_Attrs_From_Prod: Defaulting Item Supplier Site Level UDAs');
2793:
2794: EGO_ITEM_USER_ATTRS_CP_PUB.Copy_data_to_Intf
2795: (
2796: p_api_version => 1.0
2797: ,p_commit => 'F'
2798: ,p_copy_from_intf_table => 'F'

Line 2925: EGO_ITEM_USER_ATTRS_CP_PUB.Copy_data_to_Intf

2921: ) #';
2922:
2923: Debug_Conc_Log('Default_User_Attrs_From_Prod: Defaulting Item Supplier Site Org Level UDAs');
2924:
2925: EGO_ITEM_USER_ATTRS_CP_PUB.Copy_data_to_Intf
2926: (
2927: p_api_version => 1.0
2928: ,p_commit => 'F'
2929: ,p_copy_from_intf_table => 'F'

Line 3068: EGO_ITEM_USER_ATTRS_CP_PUB.Copy_data_to_Intf

3064: -- when copying from interface to interface, we do not need l_ag_sql, so passing dummy value
3065: l_ag_sql := 'SELECT NULL AS ATTR_GROUP_ID FROM DUAL WHERE 1 = 2';
3066: Debug_Conc_Log('Default_User_Attrs_From_Intf: Defaulting Item Org Level UDAs');
3067:
3068: EGO_ITEM_USER_ATTRS_CP_PUB.Copy_data_to_Intf
3069: (
3070: p_api_version => 1.0
3071: ,p_commit => 'F'
3072: ,p_copy_from_intf_table => 'T'

Line 3165: EGO_ITEM_USER_ATTRS_CP_PUB.Copy_data_to_Intf

3161: -- when copying from interface to interface, we do not need l_ag_sql, so passing dummy value
3162: l_ag_sql := 'SELECT NULL AS ATTR_GROUP_ID FROM DUAL WHERE 1 = 2';
3163: Debug_Conc_Log('Default_User_Attrs_From_Intf: Defaulting Item Supplier Level UDAs');
3164:
3165: EGO_ITEM_USER_ATTRS_CP_PUB.Copy_data_to_Intf
3166: (
3167: p_api_version => 1.0
3168: ,p_commit => 'F'
3169: ,p_copy_from_intf_table => 'T'

Line 3265: EGO_ITEM_USER_ATTRS_CP_PUB.Copy_data_to_Intf

3261: -- when copying from interface to interface, we do not need l_ag_sql, so passing dummy value
3262: l_ag_sql := 'SELECT NULL AS ATTR_GROUP_ID FROM DUAL WHERE 1 = 2';
3263: Debug_Conc_Log('Default_User_Attrs_From_Intf: Defaulting Item Supplier Site Level UDAs');
3264:
3265: EGO_ITEM_USER_ATTRS_CP_PUB.Copy_data_to_Intf
3266: (
3267: p_api_version => 1.0
3268: ,p_commit => 'F'
3269: ,p_copy_from_intf_table => 'T'

Line 3367: EGO_ITEM_USER_ATTRS_CP_PUB.Copy_data_to_Intf

3363: -- when copying from interface to interface, we do not need l_ag_sql, so passing dummy value
3364: l_ag_sql := 'SELECT NULL AS ATTR_GROUP_ID FROM DUAL WHERE 1 = 2';
3365: Debug_Conc_Log('Default_User_Attrs_From_Intf: Defaulting Item Supplier Site Org Level UDAs');
3366:
3367: EGO_ITEM_USER_ATTRS_CP_PUB.Copy_data_to_Intf
3368: (
3369: p_api_version => 1.0
3370: ,p_commit => 'F'
3371: ,p_copy_from_intf_table => 'T'

Line 4077: EGO_ITEM_USER_ATTRS_CP_PUB.Process_Item_User_Attrs_Data

4073: Debug_Conc_Log('Preprocess_Import: Done Resolve_PKs_For_Child');
4074:
4075: -- call UDA bulkloader in Validate Mode with security check
4076: Debug_Conc_Log('Preprocess_Import: Before calling UDA bulkloader in Validate Mode, with security check');
4077: EGO_ITEM_USER_ATTRS_CP_PUB.Process_Item_User_Attrs_Data
4078: (
4079: ERRBUF => l_errbuf,
4080: RETCODE => l_retcode,
4081: p_data_set_id => p_batch_id,

Line 4086: 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);

4082: p_validate_only => FND_API.G_TRUE,
4083: p_ignore_security_for_validate => FND_API.G_FALSE
4084: );
4085:
4086: 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);
4087: IF NVL(l_retcode, '0') > RETCODE THEN
4088: RETCODE := l_retcode;
4089: ERRBUF := l_errbuf;
4090: END IF;

Line 4151: EGO_ITEM_USER_ATTRS_CP_PUB.Process_Item_User_Attrs_Data

4147: END IF;
4148:
4149: -- call UDA bulkloader in Validate Mode ignoring security check
4150: Debug_Conc_Log('Preprocess_Import: Before calling UDA bulkloader in Validate Mode, ignoring security check');
4151: EGO_ITEM_USER_ATTRS_CP_PUB.Process_Item_User_Attrs_Data
4152: (
4153: ERRBUF => l_errbuf,
4154: RETCODE => l_retcode,
4155: p_data_set_id => p_batch_id,

Line 4160: 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);

4156: p_validate_only => FND_API.G_TRUE,
4157: p_ignore_security_for_validate => FND_API.G_TRUE
4158: );
4159:
4160: 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);
4161: IF NVL(l_retcode, '0') > RETCODE THEN
4162: RETCODE := l_retcode;
4163: ERRBUF := l_errbuf;
4164: END IF;