APPS.PO_AUTOCREATE_POSTPROC_PVT dependencies on PO_DISTRIBUTIONS_DRAFT_ALL

Line 1970: UPDATE po_distributions_draft_all pda

1966: END IF;
1967:
1968: l_progress := 30;
1969:
1970: UPDATE po_distributions_draft_all pda
1971: SET group_line_id = ( SELECT pld.po_line_id
1972: FROM po_lines_draft_all pld , po_lines_interface PLI
1973: WHERE pld.draft_id = po_autocreate_params.g_draft_id
1974: AND pld.po_header_id = po_autocreate_params.g_po_header_id

Line 1993: UPDATE po_distributions_draft_all pda3

1989: END IF;
1990:
1991: /*CLM Phase-2 : Autocreate Grouping*/
1992: -- If you have dist at both clin and slin level, move all dist to clin level.
1993: UPDATE po_distributions_draft_all pda3
1994: SET pda3.group_line_id = NULL
1995: WHERE pda3.po_header_id = po_autocreate_params.g_po_header_id
1996: AND pda3.draft_id = po_autocreate_params.g_draft_id
1997: AND pda3.po_line_id IN ( SELECT pda1.po_line_id

Line 1998: FROM po_distributions_draft_all pda1

1994: SET pda3.group_line_id = NULL
1995: WHERE pda3.po_header_id = po_autocreate_params.g_po_header_id
1996: AND pda3.draft_id = po_autocreate_params.g_draft_id
1997: AND pda3.po_line_id IN ( SELECT pda1.po_line_id
1998: FROM po_distributions_draft_all pda1
1999: WHERE pda1.po_header_id = po_autocreate_params.g_po_header_id
2000: AND pda1.draft_id = po_autocreate_params.g_draft_id
2001: AND pda1.group_line_id IS NULL
2002: AND EXISTS ( SELECT pda2.group_line_id

Line 2003: FROM po_distributions_draft_all pda2

1999: WHERE pda1.po_header_id = po_autocreate_params.g_po_header_id
2000: AND pda1.draft_id = po_autocreate_params.g_draft_id
2001: AND pda1.group_line_id IS NULL
2002: AND EXISTS ( SELECT pda2.group_line_id
2003: FROM po_distributions_draft_all pda2
2004: WHERE pda2.po_line_id = pda1.po_line_id
2005: AND pda2.group_line_id IS NOT NULL
2006: AND pda2.po_header_id = po_autocreate_params.g_po_header_id
2007: AND pda2.draft_id = po_autocreate_params.g_draft_id

Line 2789: update po_distributions_draft_all

2785:
2786: --move distributions
2787: IF p_draft_id_tbl(i) <> -1 THEN
2788: l_progress := '080';
2789: update po_distributions_draft_all
2790: set group_line_id = x_slin_line_id
2791: where po_line_id = p_po_line_id_tbl(i)
2792: AND draft_id = p_draft_id_tbl(i)
2793: AND group_line_id IS NULL;