APPS.PA_PO_INTEGRATION_UTILS dependencies on PO_DISTRIBUTIONS_ALL

Line 15: FUNCTION Allow_Project_Info_Change ( p_po_distribution_id IN po_distributions_all.po_distribution_id%type)

11: Return : 'Y', if project information on the purchase order distribution can be updated.
12: 'N', if project information on the purchase order distribution cannot be updated.
13: */
14:
15: FUNCTION Allow_Project_Info_Change ( p_po_distribution_id IN po_distributions_all.po_distribution_id%type)
16: RETURN varchar2 IS
17:
18: l_sum_amount_interfaced number := 0;
19: l_uninterfaced_to_pa number := 0;

Line 53: ,po_distributions_all podist/*Bug 3905697*/

49: FROM dual
50: WHERE EXISTS
51: (SELECT 1 FROM rcv_transactions rcv_txn,
52: rcv_receiving_sub_ledger rcv_sub
53: ,po_distributions_all podist/*Bug 3905697*/
54: where rcv_txn.po_distribution_id = l_po_distribution_id
55: and podist.po_distribution_id=rcv_txn.po_distribution_id/*Bug 3905697*/
56: and rcv_sub.code_combination_id = podist.code_combination_id/*Bug 3905697*/
57: and rcv_sub.rcv_transaction_id = rcv_txn.transaction_id

Line 90: ,po_distributions_all podist/*Bug 3905697*/

86: FROM dual
87: WHERE EXISTS
88: (SELECT 1 FROM rcv_transactions rcv_txn,
89: rcv_receiving_sub_ledger rcv_sub
90: ,po_distributions_all podist/*Bug 3905697*/
91: where rcv_txn.po_distribution_id = l_po_distribution_id
92: and podist.po_distribution_id=rcv_txn.po_distribution_id/*Bug 3905697*/
93: and rcv_sub.code_combination_id = podist.code_combination_id/*Bug 3905697*/
94: and rcv_sub.rcv_transaction_id = rcv_txn.transaction_id

Line 145: /*l_project_id po_distributions_all.project_id%type; Bug 5585218 */

141: p_rcv_transaction_id IN NUMBER,
142: p_po_distribution_id IN NUMBER,
143: p_accounting_event_id IN NUMBER)
144: IS
145: /*l_project_id po_distributions_all.project_id%type; Bug 5585218 */
146: l_po_distribution_id po_distributions_all.po_distribution_id%type;
147: l_rcv_transaction_id rcv_receiving_sub_ledger.rcv_transaction_id%type;
148: l_processed Number := 0;
149:

Line 146: l_po_distribution_id po_distributions_all.po_distribution_id%type;

142: p_po_distribution_id IN NUMBER,
143: p_accounting_event_id IN NUMBER)
144: IS
145: /*l_project_id po_distributions_all.project_id%type; Bug 5585218 */
146: l_po_distribution_id po_distributions_all.po_distribution_id%type;
147: l_rcv_transaction_id rcv_receiving_sub_ledger.rcv_transaction_id%type;
148: l_processed Number := 0;
149:
150: PROCEDURE net_zero_adj_po IS

Line 309: po_distributions_all po_dist1

305: ( pa_nl_installed.is_nl_installed = 'Y' --EIB trackable items
306: AND EXISTS (SELECT 'X'
307: FROM mtl_system_items si,
308: po_lines_all pol,
309: po_distributions_all po_dist1
310: WHERE po_dist1.po_line_id = pol.po_line_id
311: AND po_dist1.po_distribution_id = rcv_txn.po_distribution_id
312: AND si.inventory_item_id = pol.item_id
313: AND po_dist1.project_id IS NOT NULL