APPS.PO_PDOI_POSTPROC_PVT dependencies on PO_DISTRIBUTIONS_ALL

Line 1884: FROM po_distributions_all

1880: ,CLM_MISC_LOA,''
1881: BULK COLLECT INTO l_distribution_id_tbl,
1882: l_charge_acc_tbl, l_ACRN_tbl
1883: ,L_LOA_TBL,L_CHANGE_STAT_TBL
1884: FROM po_distributions_all
1885: WHERE po_header_id = p_doc_rec.PHI_PO_HEADER_ID;
1886:
1887: po_account_helper.BUILD_ACRN
1888: (p_doc_rec.PHI_PO_HEADER_ID, l_distribution_id_tbl, l_charge_acc_tbl, l_ACRN_tbl,

Line 1897: UPDATE po_distributions_all

1893: --ACRN Regenerate Changes End
1894: IF(l_return_status='S') THEN
1895: FOR i IN 1 .. l_distribution_id_tbl.COUNT LOOP
1896:
1897: UPDATE po_distributions_all
1898: SET ACRN = l_ACRN_tbl(i)
1899: WHERE po_distribution_id = l_distribution_id_tbl(i);
1900: END LOOP;
1901:

Line 1968: FROM po_distributions_all

1964: IF (l_is_clm = 'Y') THEN
1965:
1966: SELECT po_distribution_id, partial_funded_flag, funded_value
1967: BULK COLLECT INTO l_distribution_id_tbl, l_partial_funded_flag_tbl, l_funded_value_tbl
1968: FROM po_distributions_all
1969: WHERE po_header_id = p_doc_rec.PHI_PO_HEADER_ID;
1970:
1971: FOR i IN 1 .. l_distribution_id_tbl.COUNT LOOP
1972:

Line 1988: UPDATE po_distributions_all

1984: END IF;
1985:
1986: IF (l_partial_funded_flag_tbl(i) = 'N') THEN
1987:
1988: UPDATE po_distributions_all
1989: SET funded_value = l_amount_ordered,
1990: change_in_funded_value = l_amount_ordered
1991: WHERE po_distribution_id = l_distribution_id_tbl(i)
1992: AND budget_account_id IS NOT NULL;

Line 2313: FROM po_distributions_all

2309: CLM_MISC_LOA ,''
2310: BULK COLLECT INTO l_distribution_id_tbl,
2311: l_charge_acc_tbl, l_ACRN_tbl
2312: ,L_LOA_TBL,L_CHANGE_STAT_TBL
2313: FROM po_distributions_all
2314: WHERE po_header_id = p_doc_rec.PHI_PO_HEADER_ID;
2315:
2316: po_account_helper.BUILD_ACRN
2317: (p_doc_rec.PHI_PO_HEADER_ID, l_distribution_id_tbl, l_charge_acc_tbl, l_ACRN_tbl

Line 2326: UPDATE po_distributions_all

2322: IF(l_return_status='S') THEN
2323:
2324: FOR i IN 1 .. l_distribution_id_tbl.COUNT LOOP
2325:
2326: UPDATE po_distributions_all
2327: SET ACRN = l_ACRN_tbl(i)
2328: WHERE po_distribution_id = l_distribution_id_tbl(i);
2329: END LOOP;
2330: