DBA Data[Home] [Help]

APPS.DPP_LISTPRICE_PVT dependencies on INV_ITEM_GRP

Line 61: l_item_rec INV_ITEM_GRP.Item_rec_type;

57: l_exchange_rate_type VARCHAR2(30);
58: l_exchange_rate NUMBER;
59: l_execution_status VARCHAR2(10);
60:
61: l_item_rec INV_ITEM_GRP.Item_rec_type;
62: l_x_item_rec INV_ITEM_GRP.Item_rec_type;
63: l_error_tbl INV_ITEM_GRP.Error_tbl_type;
64: l_revision_rec INV_ITEM_GRP.Item_Revision_Rec_Type;
65:

Line 62: l_x_item_rec INV_ITEM_GRP.Item_rec_type;

58: l_exchange_rate NUMBER;
59: l_execution_status VARCHAR2(10);
60:
61: l_item_rec INV_ITEM_GRP.Item_rec_type;
62: l_x_item_rec INV_ITEM_GRP.Item_rec_type;
63: l_error_tbl INV_ITEM_GRP.Error_tbl_type;
64: l_revision_rec INV_ITEM_GRP.Item_Revision_Rec_Type;
65:
66: l_output_xml CLOB;

Line 63: l_error_tbl INV_ITEM_GRP.Error_tbl_type;

59: l_execution_status VARCHAR2(10);
60:
61: l_item_rec INV_ITEM_GRP.Item_rec_type;
62: l_x_item_rec INV_ITEM_GRP.Item_rec_type;
63: l_error_tbl INV_ITEM_GRP.Error_tbl_type;
64: l_revision_rec INV_ITEM_GRP.Item_Revision_Rec_Type;
65:
66: l_output_xml CLOB;
67: l_queryCtx dbms_xmlquery.ctxType;

Line 64: l_revision_rec INV_ITEM_GRP.Item_Revision_Rec_Type;

60:
61: l_item_rec INV_ITEM_GRP.Item_rec_type;
62: l_x_item_rec INV_ITEM_GRP.Item_rec_type;
63: l_error_tbl INV_ITEM_GRP.Error_tbl_type;
64: l_revision_rec INV_ITEM_GRP.Item_Revision_Rec_Type;
65:
66: l_output_xml CLOB;
67: l_queryCtx dbms_xmlquery.ctxType;
68: l_Transaction_Number CLOB;

Line 188: inv_item_grp.Update_Item(p_commit => fnd_api.g_FALSE

184: l_item_rec.organization_id := Item_rec.organization_id;
185: l_item_rec.list_price_per_unit := NVL(l_to_amount,l_item_cost_tbl(i).new_price);
186: l_count := l_count + 1;
187:
188: inv_item_grp.Update_Item(p_commit => fnd_api.g_FALSE
189: , p_lock_rows => fnd_api.g_TRUE
190: , p_validation_level => fnd_api.g_VALID_LEVEL_FULL
191: , p_Item_rec => l_item_rec
192: , x_Item_rec => l_x_item_rec