APPS.RCV_BILL_UPDATING_SV dependencies on PO_DISTRIBUTIONS

Line 8: PROCEDURE ap_update_po_distributions( X_po_distribution_id IN NUMBER,

4: /** June 07, 1999, bgu
5: * AP is no longer maintaining base_amount_billed, po will remove all reference
6: * to the field.
7: */
8: PROCEDURE ap_update_po_distributions( X_po_distribution_id IN NUMBER,
9: X_quantity_billed IN NUMBER,
10: X_uom_lookup_code IN VARCHAR2,
11: X_amount_billed IN NUMBER,
12: X_matching_basis IN VARCHAR2) IS

Line 32: po_distributions pd,

28: INTO
29: X_po_uom,
30: X_item_id
31: FROM
32: po_distributions pd,
33: po_lines pl
34: WHERE
35: pd.po_distribution_id = X_po_distribution_id AND
36: pl.po_line_id = pd.po_line_id;

Line 55: /* Update PO_DISTRIBUTIONS */

51: X_po_amount_billed := nvl(X_amount_billed,0);
52:
53: X_progress := '003';
54:
55: /* Update PO_DISTRIBUTIONS */
56: --Bug#2602981.Changed the X_po_quantity_billed to round(X_po_quantity_billed,15)
57:
58: /* Bug 4305628: For Planned Purchase orders, the quantity/amount billed on the
59: ** Scheduled Release (SR) as well as the backing order (PPO)

Line 63: UPDATE po_distributions_all pod

59: ** Scheduled Release (SR) as well as the backing order (PPO)
60: ** should be updated.
61: */
62: --Bug 12886371. Added the updation of who columns
63: UPDATE po_distributions_all pod
64: SET pod.quantity_billed = nvl(pod.quantity_billed,0) + X_po_quantity_billed,
65: pod.amount_billed = nvl(pod.amount_billed,0) + X_po_amount_billed,
66: pod.last_updated_by = fnd_global.user_id,
67: pod.last_update_date=sysdate,

Line 72: FROM po_distributions pod2

68: pod.last_update_login=fnd_global.login_id
69: WHERE po_distribution_id = X_po_distribution_id
70: OR ( pod.distribution_type = 'PLANNED'
71: AND pod.po_distribution_id = ( SELECT pod2.source_distribution_id
72: FROM po_distributions pod2
73: WHERE pod2.distribution_type = 'SCHEDULED'
74: AND pod2.po_distribution_id = X_po_distribution_id)
75: );
76:

Line 82: po_message_s.sql_error('ap_update_po_distributions', X_progress, sqlcode);

78:
79: EXCEPTION
80:
81: when others then
82: po_message_s.sql_error('ap_update_po_distributions', X_progress, sqlcode);
83: raise;
84:
85: END ap_update_po_distributions;
86:

Line 85: END ap_update_po_distributions;

81: when others then
82: po_message_s.sql_error('ap_update_po_distributions', X_progress, sqlcode);
83: raise;
84:
85: END ap_update_po_distributions;
86:
87:
88:
89: PROCEDURE ap_update_po_line_locations( X_po_line_location_id IN NUMBER,