DBA Data[Home] [Help]

APPS.EGO_ITEM_USER_ATTRS_CP_PUB dependencies on EGO_USER_ATTRS_BULK_PVT

Line 2349: -- Call the EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data API instead of

2345:
2346:
2347:
2348:
2349: -- Call the EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data API instead of
2350: -- EGO_USER_ATTRS_DATA_PUB.Process_User_Attrs_Data
2351:
2352: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Starting User Attributes Bulk Load', 1);
2353:

Line 2378: EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data (

2374: l_default_dl_edit_priv_list.EXTEND;
2375: l_default_dl_edit_priv_list(l_default_dl_edit_priv_list.COUNT) := l_default_dl_edit_priv_obj;
2376: END LOOP;
2377:
2378: EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data (
2379: p_api_version => G_API_VERSION --IN NUMBER
2380: ,p_application_id => 431 --IN NUMBER
2381: ,p_attr_group_type => 'EGO_ITEMMGMT_GROUP' --IN VARCHAR2
2382: ,p_object_name => G_ITEM_NAME --IN VARCHAR2

Line 2526: EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data (

2522: ----------------------------------------------------
2523: -- Processing data for GDSN Attribute group types --
2524: ----------------------------------------------------
2525:
2526: EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data (
2527: p_api_version => G_API_VERSION --IN NUMBER
2528: ,p_application_id => 431 --IN NUMBER
2529: ,p_attr_group_type => 'EGO_ITEM_GTIN_ATTRS' --IN VARCHAR2
2530: ,p_object_name => G_ITEM_NAME --IN VARCHAR2

Line 2564: EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data (

2560: ELSIF l_user_attrs_return_status = G_FND_RET_STS_WARNING THEN
2561: RETCODE := L_CONC_RET_STS_WARNING;
2562: END IF;
2563:
2564: EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data (
2565: p_api_version => G_API_VERSION --IN NUMBER
2566: ,p_application_id => 431 --IN NUMBER
2567: ,p_attr_group_type => 'EGO_ITEM_GTIN_MULTI_ATTRS' --IN VARCHAR2
2568: ,p_object_name => G_ITEM_NAME --IN VARCHAR2

Line 2609: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Calling EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows for EGO_ITEMMGMT_GROUP ', 1);

2605: -- Calling the API to Mark all such rows which have the same data --
2606: -- as we have for the attribute in the production tables. --
2607: ---------------------------------------------------------------------
2608:
2609: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Calling EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows for EGO_ITEMMGMT_GROUP ', 1);
2610: EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows (
2611: p_api_version =>1.0
2612: ,p_application_id =>431
2613: ,p_attr_group_type =>'EGO_ITEMMGMT_GROUP'

Line 2610: EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows (

2606: -- as we have for the attribute in the production tables. --
2607: ---------------------------------------------------------------------
2608:
2609: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Calling EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows for EGO_ITEMMGMT_GROUP ', 1);
2610: EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows (
2611: p_api_version =>1.0
2612: ,p_application_id =>431
2613: ,p_attr_group_type =>'EGO_ITEMMGMT_GROUP'
2614: ,p_object_name =>'EGO_ITEM'

Line 2621: EGO_USER_ATTRS_DATA_PVT.Debug_Msg(' ... Completed EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows Return Status-'||l_return_status||' '||l_msg_data, 1);

2617: ,p_new_status =>4
2618: ,x_return_status =>l_return_status
2619: ,x_msg_data =>l_msg_data
2620: );
2621: EGO_USER_ATTRS_DATA_PVT.Debug_Msg(' ... Completed EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows Return Status-'||l_return_status||' '||l_msg_data, 1);
2622:
2623: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2624: ERRBUF := l_msg_data;
2625: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2643: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Calling EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows for EGO_ITEM_GTIN_ATTRS ', 1);

2639:
2640:
2641:
2642:
2643: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Calling EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows for EGO_ITEM_GTIN_ATTRS ', 1);
2644: EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows (
2645: p_api_version =>1.0
2646: ,p_application_id =>431
2647: ,p_attr_group_type =>'EGO_ITEM_GTIN_ATTRS'

Line 2644: EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows (

2640:
2641:
2642:
2643: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Calling EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows for EGO_ITEM_GTIN_ATTRS ', 1);
2644: EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows (
2645: p_api_version =>1.0
2646: ,p_application_id =>431
2647: ,p_attr_group_type =>'EGO_ITEM_GTIN_ATTRS'
2648: ,p_object_name =>'EGO_ITEM'

Line 2655: EGO_USER_ATTRS_DATA_PVT.Debug_Msg(' ... Completed EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows Return Status-'||l_return_status||' '||l_msg_data, 1);

2651: ,p_new_status =>4
2652: ,x_return_status =>l_return_status
2653: ,x_msg_data =>l_msg_data
2654: );
2655: EGO_USER_ATTRS_DATA_PVT.Debug_Msg(' ... Completed EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows Return Status-'||l_return_status||' '||l_msg_data, 1);
2656:
2657: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2658: ERRBUF := l_msg_data;
2659: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2674: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Calling EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows for EGO_ITEM_GTIN_MULTI_ATTRS ', 1);

2670: ELSIF l_return_status = G_FND_RET_STS_WARNING THEN
2671: RETCODE := L_CONC_RET_STS_WARNING;
2672: END IF;
2673:
2674: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Calling EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows for EGO_ITEM_GTIN_MULTI_ATTRS ', 1);
2675: EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows (
2676: p_api_version =>1.0
2677: ,p_application_id =>431
2678: ,p_attr_group_type =>'EGO_ITEM_GTIN_MULTI_ATTRS'

Line 2675: EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows (

2671: RETCODE := L_CONC_RET_STS_WARNING;
2672: END IF;
2673:
2674: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Calling EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows for EGO_ITEM_GTIN_MULTI_ATTRS ', 1);
2675: EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows (
2676: p_api_version =>1.0
2677: ,p_application_id =>431
2678: ,p_attr_group_type =>'EGO_ITEM_GTIN_MULTI_ATTRS'
2679: ,p_object_name =>'EGO_ITEM'

Line 2686: EGO_USER_ATTRS_DATA_PVT.Debug_Msg(' ... Completed EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows Return Status-'||l_return_status||' '||l_msg_data, 1);

2682: ,p_new_status =>4
2683: ,x_return_status =>l_return_status
2684: ,x_msg_data =>l_msg_data
2685: );
2686: EGO_USER_ATTRS_DATA_PVT.Debug_Msg(' ... Completed EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows Return Status-'||l_return_status||' '||l_msg_data, 1);
2687:
2688: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2689: ERRBUF := l_msg_data;
2690: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2788: EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data (

2784: -- Here we call the API in DML only mode for --
2785: -- all the attr group types --
2786: ------------------------------------------------
2787: IF p_validate_only = FND_API.G_FALSE THEN
2788: EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data (
2789: p_api_version => G_API_VERSION --IN NUMBER
2790: ,p_application_id => 431 --IN NUMBER
2791: ,p_attr_group_type => 'EGO_ITEMMGMT_GROUP' --IN VARCHAR2
2792: ,p_object_name => G_ITEM_NAME --IN VARCHAR2

Line 2826: EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data (

2822: ELSIF l_user_attrs_return_status = G_FND_RET_STS_WARNING THEN
2823: RETCODE := L_CONC_RET_STS_WARNING;
2824: END IF;
2825:
2826: EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data (
2827: p_api_version => G_API_VERSION --IN NUMBER
2828: ,p_application_id => 431 --IN NUMBER
2829: ,p_attr_group_type => 'EGO_ITEM_GTIN_ATTRS' --IN VARCHAR2
2830: ,p_object_name => G_ITEM_NAME --IN VARCHAR2

Line 2864: EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data (

2860: ELSIF l_user_attrs_return_status = G_FND_RET_STS_WARNING THEN
2861: RETCODE := L_CONC_RET_STS_WARNING;
2862: END IF;
2863:
2864: EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data (
2865: p_api_version => G_API_VERSION --IN NUMBER
2866: ,p_application_id => 431 --IN NUMBER
2867: ,p_attr_group_type => 'EGO_ITEM_GTIN_MULTI_ATTRS' --IN VARCHAR2
2868: ,p_object_name => G_ITEM_NAME --IN VARCHAR2