APPS.PO_DRAFTS_PVT dependencies on PO_HEADERS_DRAFT_ALL

Line 451: FROM PO_HEADERS_DRAFT_ALL PHD

447: NVL(PHD.global_agreement_flag, 'N')
448: INTO l_type_lookup_code,
449: l_quote_type_lookup_code,
450: x_draft_info.ga_flag
451: FROM PO_HEADERS_DRAFT_ALL PHD
452: WHERE PHD.po_header_id = p_po_header_id
453: AND PHD.draft_id = p_draft_id;
454: ELSE
455: d_position := 20;

Line 3205: l_change_accepted_flag PO_HEADERS_DRAFT_ALL.change_accepted_flag%TYPE := NULL;

3201: d_api_name CONSTANT VARCHAR2(30) := 'update_acceptance_status';
3202: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
3203: d_position NUMBER;
3204:
3205: l_change_accepted_flag PO_HEADERS_DRAFT_ALL.change_accepted_flag%TYPE := NULL;
3206:
3207: BEGIN
3208:
3209: d_position := 0;

Line 3224: UPDATE po_headers_draft_all

3220: d_position := 20;
3221:
3222: IF (l_change_accepted_flag IS NOT NULL) THEN
3223: d_position := 30;
3224: UPDATE po_headers_draft_all
3225: SET change_accepted_flag = l_change_accepted_flag
3226: WHERE draft_id = p_draft_id
3227: AND change_accepted_flag IS NULL;
3228: