DBA Data[Home] [Help]

APPS.PO_R12_CAT_UPG_VAL_PVT dependencies on MTL_ITEM_REVISIONS

Line 3168: -- Check to see if the item_revision exists in mtl_item_revisions table

3164: -- None.
3165: --Function:
3166: -- If order_type_lookup_code is FIXED PRICE or RATE, or item id is null,
3167: -- then item revision has to be NULL
3168: -- Check to see if the item_revision exists in mtl_item_revisions table
3169: --Parameters:
3170: --IN:
3171: --p_key
3172: -- Key used to access records in PO_SESSION_GT table.

Line 3239: -- exists in MTL_ITEM_REVISIONS table.

3235: l_subscript_array := PO_R12_CAT_UPG_UTL.construct_subscript_array(p_lines_rec.item_id.COUNT);
3236:
3237: l_progress := '050';
3238: -- SQL What: Bulk validate item revision. Check to see if the item_revision
3239: -- exists in MTL_ITEM_REVISIONS table.
3240: -- Insert the error rows into GT table.
3241: -- SQL Why : It will be used to mark the record in plsql table as error.
3242: -- SQL Join: item_id, item_revision
3243: FORALL i IN 1 .. p_lines_rec.item_id.COUNT

Line 3262: FROM MTL_ITEM_REVISIONS MIR

3258: p_lines_rec.action(i) IN (PO_R12_CAT_UPG_PVT.g_action_line_create, 'UPDATE')
3259: AND p_lines_rec.item_revision(i) is not null
3260: AND p_lines_rec.item_id(i) is not null
3261: AND NOT EXISTS (SELECT 1
3262: FROM MTL_ITEM_REVISIONS MIR
3263: WHERE MIR.inventory_item_id = p_lines_rec.item_id(i)
3264: AND MIR.revision = p_lines_rec.item_revision(i));
3265:
3266: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of rows insert into GT table='||SQL%rowcount); END IF;

Line 4039: -- check to see if there are x_item_revision exists in mtl_item_revisions table

4035:
4036: l_progress := '030';
4037: -- if order_type_lookup_code is FIXED PRICE or RATE, or item id is null,
4038: -- then item revision has to be NULL
4039: -- check to see if there are x_item_revision exists in mtl_item_revisions table
4040: validate_item_revision
4041: (
4042: p_key => l_key,
4043: p_lines_rec => p_lines_rec