APPS.PO_DRAFTS_PVT dependencies on PO_LINES_DRAFT_ALL

Line 388: FROM po_lines_draft_all pld

384: AND poel.entity_name = G_LOCK_LINE_ENTITY
385: )
386: -- : Stamping revision_num for newly added lines on mod.
387: OR EXISTS ( SELECT 'New Line'
388: FROM po_lines_draft_all pld
389: WHERE pld.po_line_id = pla.po_line_id
390: AND pld.draft_id = p_draft_id
391: AND pld.change_status = 'NEW'
392: )

Line 621: from po_lines_draft_all pold

617: d_position := 5;
618: IF p_draft_id IS NOT NULL AND p_draft_id <> -1 THEN
619: Select po_line_id
620: BULK Collect into po_line_ids_tbl
621: from po_lines_draft_all pold
622: where pold.draft_id = p_draft_id;
623: --Calling delete line UCAS
624: delete_line_ucas(p_po_draft_id => p_draft_id,
625: po_line_ids_tbl => po_line_ids_tbl);

Line 3786: UPDATE po_lines_draft_all

3782: WHERE draft_id = p_draft_id
3783: AND change_accepted_flag IS NULL;
3784:
3785: d_position := 40;
3786: UPDATE po_lines_draft_all
3787: SET change_accepted_flag = l_change_accepted_flag
3788: WHERE draft_id = p_draft_id
3789: AND change_accepted_flag IS NULL;
3790:

Line 4705: FROM po_lines_draft_all pold,

4701: NVL(pold.from_header_id, G_NULL_NUM),
4702: NVL(pold.from_line_id, G_NULL_NUM),
4703: NVL(pold.clm_idc_type, G_NULL_CHAR)
4704: ) f_lock_attrs
4705: FROM po_lines_draft_all pold,
4706: po_session_gt pogt
4707: WHERE pold.draft_id = p_draft_id
4708: AND pold.po_line_id = pogt.char1 -- po_line_id
4709: AND pogt.index_char1 = G_CHANGED_ENTTIES_ID

Line 7044: FROM po_lines_draft_all plbd,

7040: G_LOCK_LINE_ENTITY,
7041: plbd.po_line_id,
7042: p_draft_id,
7043: 'P'
7044: FROM po_lines_draft_all plbd,
7045: po_session_gt pogt
7046: WHERE plbd.draft_id = p_draft_id
7047: AND plbd.po_line_id = pogt.char1 -- po_line_id
7048: AND pogt.index_char1 = G_CHANGED_ENTTIES_ID

Line 8534: FROM po_lines_draft_all

8530:
8531:
8532: FORALL i IN 1..po_line_ids_tbl.Count()
8533: DELETE
8534: FROM po_lines_draft_all
8535: WHERE po_line_id = po_line_ids_tbl(i)
8536: AND draft_id = p_po_draft_id;
8537:
8538: FORALL i IN 1..po_line_ids_tbl.Count()

Line 8639: FROM po_lines_draft_all

8635: --delete line data
8636: SELECT po_line_id
8637: BULK COLLECT
8638: INTO l_line_id_tbl
8639: FROM po_lines_draft_all
8640: WHERE delete_flag = 'Y'
8641: AND draft_id = p_draft_id
8642: AND NVL(change_accepted_flag, 'Y') = 'Y';
8643:

Line 8677: DELETE FROM po_lines_draft_all

8673: --UCA Changes End.
8674:
8675:
8676: FORALL i IN 1..l_line_id_tbl.Count()
8677: DELETE FROM po_lines_draft_all
8678: WHERE po_line_id = l_line_id_tbl(i)
8679: AND draft_id = p_draft_id;
8680:
8681: FORALL i IN 1..l_line_id_tbl.Count()

Line 9266: AND NOT EXISTS (SELECT 1 FROM po_lines_draft_all PLD

9262: WHERE ex.po_header_id = p_po_header_id
9263: AND ex.draft_id = p_draft_id
9264: AND ex.is_cdrl = 'N'
9265: AND Nvl(ex.delete_flag,'N') <> 'Y'
9266: AND NOT EXISTS (SELECT 1 FROM po_lines_draft_all PLD
9267: WHERE PLD.draft_id = ex.draft_id
9268: AND ex.exhibit_name = PLD.clm_exhibit_name
9269: AND NVL(PLD.delete_flag, 'N') <> 'Y')
9270: AND NOT EXISTS (SELECT 1 FROM po_lines_all pl

Line 9273: AND NOT EXISTS (SELECT 1 FROM po_lines_draft_all pd

9269: AND NVL(PLD.delete_flag, 'N') <> 'Y')
9270: AND NOT EXISTS (SELECT 1 FROM po_lines_all pl
9271: WHERE pl.po_header_id = p_po_header_id
9272: AND ex.exhibit_name = pl.clm_exhibit_name
9273: AND NOT EXISTS (SELECT 1 FROM po_lines_draft_all pd
9274: WHERE pl.po_line_id = pd.po_line_id
9275: AND NVL(pd.delete_flag, 'N') = 'Y')
9276: );
9277: