APPS.PO_MOD_SYNC_PROCESS_PVT dependencies on PO_HEADERS_DRAFT_ALL

Line 1190: ,po_headers_draft_all phd

1186: l_draft_amount_limit,
1187: l_draft_old_amount_limit,
1188: l_change_status
1189: FROM po_headers_all pha
1190: ,po_headers_draft_all phd
1191: WHERE pha.po_header_id = phd.po_header_id
1192: AND phd.draft_id = p_draft_id
1193: AND pha.po_header_id = l_po_header_id;
1194:

Line 1232: UPDATE po_headers_draft_all pohd

1228:
1229: /*if the draft revision num is less than base revision num then a sync is required*/
1230: IF( p_ignore_rev_number = 'Y' OR (l_header_draft_rev_num < l_header_base_rev_num OR l_draft_rev_num = -1)) THEN
1231: IF( p_ignore_rev_number = 'Y' OR ( l_lock_type = 'S' OR l_lock_type IS NULL)) THEN
1232: UPDATE po_headers_draft_all pohd
1233: SET ( pohd.amount_limit ,
1234: pohd.user_document_status,
1235: pohd.vendor_site_id,
1236: pohd.vendor_contact_id,

Line 1452: UPDATE po_headers_draft_all

1448: /*we need to update the delta values for the concurrent update attributes in case of both shared and partial lock*/
1449: IF l_lock_type IN ('S','P') THEN
1450: -- Update only if either of base/drat amount limit is not null
1451: IF l_base_amount_limit IS NOT NULL OR l_draft_amount_limit IS NOT NULL THEN
1452: UPDATE po_headers_draft_all
1453: SET old_amount_limit = l_base_amount_limit,
1454: amount_limit = NVL(l_base_amount_limit, 0) +
1455: ( NVL(l_draft_amount_limit, 0) -
1456: NVL(l_draft_old_amount_limit, 0) )

Line 1486: UPDATE po_headers_draft_all

1482: PO_LOG.stmt(d_module,d_position ,'synced uda_address tables');
1483: END IF;
1484:
1485: /*we need to update revision_num , change_status*/
1486: UPDATE po_headers_draft_all
1487: SET revision_num = l_header_base_rev_num,
1488: change_status = l_change_status
1489: WHERE po_header_id = l_po_header_id
1490: AND draft_id = p_draft_id;

Line 4814: FROM po_headers_draft_all

4810: WHERE po_header_id = l_document_id;
4811:
4812: SELECT revision_num
4813: INTO l_mod_rev_num
4814: FROM po_headers_draft_all
4815: WHERE po_header_id = l_document_id
4816: AND draft_id = l_draftid;
4817:
4818: IF NVL(l_base_rev_num, 0) > NVL(l_mod_rev_num, 0) THEN

Line 5110: SELECT revision_num INTO l_draft_rev_num FROM po_headers_draft_all WHERE po_header_id = l_po_header_id AND draft_id = l_draft_id;

5106: INTO l_po_header_id
5107: FROM po_drafts
5108: WHERE draft_id = l_draft_id;
5109:
5110: SELECT revision_num INTO l_draft_rev_num FROM po_headers_draft_all WHERE po_header_id = l_po_header_id AND draft_id = l_draft_id;
5111: SELECT revision_num INTO l_header_base_rev_num FROM po_headers_all WHERE po_header_id = l_po_header_id;
5112: SELECT revision_num INTO draft_revision_num FROM po_drafts WHERE draft_id = l_draft_id;
5113:
5114: x_progress := 'PO_MOD_SYNC_PROCESS_PVT.IS_SGD_GENERATION_REQUIRED: Draft_id: '