DBA Data[Home] [Help]

APPS.PO_DOCUMENT_UPDATE_PVT dependencies on PO_CHANGES_REC_TYPE

Line 18: p_changes IN OUT NOCOPY PO_CHANGES_REC_TYPE,

14: PROCEDURE update_document (
15: p_api_version IN NUMBER,
16: p_init_msg_list IN VARCHAR2,
17: x_return_status OUT NOCOPY VARCHAR2,
18: p_changes IN OUT NOCOPY PO_CHANGES_REC_TYPE,
19: p_run_submission_checks IN VARCHAR2,
20: p_launch_approvals_flag IN VARCHAR2,
21: p_buyer_id IN NUMBER,
22: p_update_source IN VARCHAR2,

Line 66: G_ENTITY_TYPE_CHANGES CONSTANT VARCHAR2(30) := 'PO_CHANGES_REC_TYPE';

62: G_UPDATE_SOURCE_OM CONSTANT VARCHAR2(10) := 'OM'; -- OM (Drop Ship Integration)
63:
64: -- Entity type constants:
65:
66: G_ENTITY_TYPE_CHANGES CONSTANT VARCHAR2(30) := 'PO_CHANGES_REC_TYPE';
67: G_ENTITY_TYPE_LINES CONSTANT VARCHAR2(30) := 'PO_LINES_REC_TYPE';
68: G_ENTITY_TYPE_SHIPMENTS CONSTANT VARCHAR2(30) := 'PO_SHIPMENTS_REC_TYPE';
69: G_ENTITY_TYPE_DISTRIBUTIONS CONSTANT VARCHAR2(30)
70: := 'PO_DISTRIBUTIONS_REC_TYPE';

Line 97: p_chg IN PO_CHANGES_REC_TYPE,

93: -- for the same PO_LINE_ID.
94: --End of Comments
95: -------------------------------------------------------------------------------
96: PROCEDURE add_line_change_to_index (
97: p_chg IN PO_CHANGES_REC_TYPE,
98: i IN NUMBER
99: );
100:
101: -------------------------------------------------------------------------------

Line 111: p_chg IN PO_CHANGES_REC_TYPE,

107: -- for the same LINE_LOCATION_ID.
108: --End of Comments
109: -------------------------------------------------------------------------------
110: PROCEDURE add_ship_change_to_index (
111: p_chg IN PO_CHANGES_REC_TYPE,
112: i IN NUMBER
113: );
114:
115: -------------------------------------------------------------------------------

Line 125: p_chg IN PO_CHANGES_REC_TYPE,

121: -- change for the same PO_DISTRIBUTION_ID.
122: --End of Comments
123: -------------------------------------------------------------------------------
124: PROCEDURE add_dist_change_to_index (
125: p_chg IN PO_CHANGES_REC_TYPE,
126: i IN NUMBER
127: );
128:
129: -------------------------------------------------------------------------------

Line 150: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE,

146: -- If none exists, adds a line change for p_po_line_id and returns its index.
147: --End of Comments
148: -------------------------------------------------------------------------------
149: FUNCTION find_line_change (
150: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE,
151: p_po_line_id IN PO_LINES.po_line_id%TYPE
152: ) RETURN NUMBER;
153:
154: -------------------------------------------------------------------------------

Line 176: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE,

172: -- returns its index.
173: --End of Comments
174: -------------------------------------------------------------------------------
175: FUNCTION find_ship_change (
176: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE,
177: p_line_location_id IN PO_LINE_LOCATIONS.line_location_id%TYPE
178: ) RETURN NUMBER;
179:
180: -------------------------------------------------------------------------------

Line 202: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE,

198: -- returns its index.
199: --End of Comments
200: -------------------------------------------------------------------------------
201: FUNCTION find_dist_change (
202: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE,
203: p_po_distribution_id IN PO_DISTRIBUTIONS.po_distribution_id%TYPE
204: ) RETURN NUMBER;
205:
206: -------------------------------------------------------------------------------

Line 215: p_chg IN PO_CHANGES_REC_TYPE,

211: -- and p_split_shipment_num. If none exists, returns NULL.
212: --End of Comments
213: -------------------------------------------------------------------------------
214: FUNCTION get_split_ship_change (
215: p_chg IN PO_CHANGES_REC_TYPE,
216: p_po_line_id IN PO_LINES.po_line_id%TYPE,
217: p_parent_line_loc_id IN PO_LINE_LOCATIONS.line_location_id%TYPE,
218: p_split_shipment_num IN PO_LINE_LOCATIONS.shipment_num%TYPE
219: ) RETURN NUMBER;

Line 231: p_chg IN PO_CHANGES_REC_TYPE,

227: -- If none exists, returns NULL.
228: --End of Comments
229: -------------------------------------------------------------------------------
230: FUNCTION get_split_dist_change (
231: p_chg IN PO_CHANGES_REC_TYPE,
232: p_parent_distribution_id IN PO_DISTRIBUTIONS.po_distribution_id%TYPE,
233: p_parent_line_loc_id IN PO_LINE_LOCATIONS.line_location_id%TYPE,
234: p_split_shipment_num IN PO_LINE_LOCATIONS.shipment_num%TYPE
235: ) RETURN NUMBER;

Line 248: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE,

244: -- and returns its index.
245: --End of Comments
246: -------------------------------------------------------------------------------
247: FUNCTION find_split_dist_change (
248: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE,
249: p_parent_distribution_id IN PO_DISTRIBUTIONS.po_distribution_id%TYPE,
250: p_parent_line_loc_id IN PO_LINE_LOCATIONS.line_location_id%TYPE,
251: p_split_shipment_num IN PO_LINE_LOCATIONS.shipment_num%TYPE
252: ) RETURN NUMBER;