APPS.PO_DRAFTS_PVT dependencies on PO_HEADERS_DRAFT_ALL

Line 780: FROM PO_HEADERS_DRAFT_ALL PHD

776: NVL(PHD.global_agreement_flag, 'N')
777: INTO l_type_lookup_code,
778: l_quote_type_lookup_code,
779: x_draft_info.ga_flag
780: FROM PO_HEADERS_DRAFT_ALL PHD
781: WHERE PHD.po_header_id = p_po_header_id
782: AND PHD.draft_id = p_draft_id;
783: ELSE
784: d_position := 20;

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

3757: d_api_name CONSTANT VARCHAR2(30) := 'update_acceptance_status';
3758: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
3759: d_position NUMBER;
3760:
3761: l_change_accepted_flag PO_HEADERS_DRAFT_ALL.change_accepted_flag%TYPE := NULL;
3762:
3763: BEGIN
3764:
3765: d_position := 0;

Line 3780: UPDATE po_headers_draft_all

3776: d_position := 20;
3777:
3778: IF (l_change_accepted_flag IS NOT NULL) THEN
3779: d_position := 30;
3780: UPDATE po_headers_draft_all
3781: SET change_accepted_flag = l_change_accepted_flag
3782: WHERE draft_id = p_draft_id
3783: AND change_accepted_flag IS NULL;
3784:

Line 4114: FROM po_headers_all pha, po_headers_draft_all phd

4110:
4111: -- chk for uda enabled
4112: SELECT pha.TYPE_LOOKUP_CODE, pha.STYLE_ID,phd.po_header_id
4113: INTO l_document_type_code, l_document_style_id, l_po_header_id
4114: FROM po_headers_all pha, po_headers_draft_all phd
4115: WHERE pha.PO_HEADER_ID = phd.PO_HEADER_ID
4116: AND phd.draft_id=p_draft_id ;
4117:
4118: d_position := 20;

Line 4343: FROM po_headers_draft_all pohd,

4339: NVL(pohd.umbrella_program_id ,G_NULL_NUM),
4340: NVL(pohd.clm_contract_finance_code, G_NULL_CHAR),
4341: NVL(pohd.clm_payment_instr_code, G_NULL_CHAR)
4342: ) p_lock_attrs
4343: FROM po_headers_draft_all pohd,
4344: po_session_gt pogt
4345: WHERE pohd.draft_id = p_draft_id
4346: AND pohd.po_header_id = pogt.char1 -- po_header_id
4347: AND pogt.index_char1 = G_CHANGED_ENTTIES_ID

Line 5891: FROM po_headers_draft_all phda,

5887: G_LOCK_HEADER_ENTITY,
5888: phda.po_header_id,
5889: p_draft_id,
5890: 'P'
5891: FROM po_headers_draft_all phda,
5892: po_session_gt pogt
5893: WHERE phda.draft_id= p_draft_id
5894: AND phda.po_header_id = pogt.char1 -- po_header_id
5895: AND pogt.index_char1 = G_CHANGED_ENTTIES_ID

Line 5945: FROM po_headers_draft_all pohd,

5941: G_LOCK_HEADER_ENTITY,
5942: pohd.po_header_id,
5943: pohd.draft_id,
5944: 'P'
5945: FROM po_headers_draft_all pohd,
5946: po_session_gt pogt
5947: WHERE pohd.draft_id = p_draft_id
5948: AND pohd.po_header_id = pogt.char1 -- po_header_id
5949: AND pogt.index_char1 = G_CHANGED_ENTTIES_ID