DBA Data[Home] [Help]

APPS.RLM_BLANKET_SV dependencies on RLM_INTERFACE_HEADERS

Line 74: PARAMETERS: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE

70: (d) CreateRSOHeader
71: (e) InsertRSO
72: (f) UpdateLinesWithRSO
73:
74: PARAMETERS: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE
75: x_Group_rec IN t_group_rec
76: x_header_id IN RLM_INTERFACE_HEADERS.HEADER_ID%TYPE
77:
78: DESIGN REFERENCES: rlabldld.rtf

Line 76: x_header_id IN RLM_INTERFACE_HEADERS.HEADER_ID%TYPE

72: (f) UpdateLinesWithRSO
73:
74: PARAMETERS: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE
75: x_Group_rec IN t_group_rec
76: x_header_id IN RLM_INTERFACE_HEADERS.HEADER_ID%TYPE
77:
78: DESIGN REFERENCES: rlabldld.rtf
79:
80: CHANGE HISTORY: created rlanka 10/10/02

Line 82: PROCEDURE DeriveRSO(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

78: DESIGN REFERENCES: rlabldld.rtf
79:
80: CHANGE HISTORY: created rlanka 10/10/02
81: ===========================================================================*/
82: PROCEDURE DeriveRSO(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
83: x_Group_rec IN RLM_DP_SV.t_Group_rec,
84: x_return_status OUT NOCOPY NUMBER);
85: --
86:

Line 133: x_header_id IN RLM_INTERFACE_HEADERS.HEADER_ID%TYPE

129: end date in the RLM_BLANKET_RSO.
130:
131: PARAMETERS: x_cust_po_num IN RLM_INTERFACE_LINES.cust_po_number%TYPE
132: x_Group_rec IN t_group_rec
133: x_header_id IN RLM_INTERFACE_HEADERS.HEADER_ID%TYPE
134:
135: DESIGN REFERENCES: rlabldld.rtf
136:
137: CHANGE HISTORY: created rlanka 10/10/02

Line 176: PARAMETERS: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE

172: DESCRIPTION: This procedure is used to insert a new row in the
173: RLM_BLANKET_RSO table. Every entry in this table is
174: unique.
175:
176: PARAMETERS: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE
177: x_Group_rec IN t_group_rec
178: p_rso_hdr_id IN NUMBER
179: p_start_date IN DATE
180: p_end_date IN DATE

Line 186: PROCEDURE InsertRSO(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

182: DESIGN REFERENCES: rlabldld.rtf
183:
184: CHANGE HISTORY: created rlanka 10/10/02
185: ===========================================================================*/
186: PROCEDURE InsertRSO(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
187: x_Group_rec IN RLM_DP_SV.t_Group_rec,
188: p_rso_hdr_id IN NUMBER,
189: p_start_date IN DATE,
190: p_end_date IN DATE);

Line 202: PARAMETERS: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE

198: a release sales order and book it. Mandatory
199: parameters are blanket_number and customer_id, every
200: other value is obtained from defaulting rules
201:
202: PARAMETERS: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE
203: x_Group_rec IN t_group_rec
204: x_rso_hdr_id OUT NOCOPY NUMBER
205:
206: DESIGN REFERENCES: rlabldld.rtf

Line 210: PROCEDURE CreateRSOHeader(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

206: DESIGN REFERENCES: rlabldld.rtf
207:
208: CHANGE HISTORY: created rlanka 10/10/02
209: ===========================================================================*/
210: PROCEDURE CreateRSOHeader(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
211: x_Group_rec IN RLM_DP_SV.t_Group_rec,
212: x_rso_hdr_id OUT NOCOPY NUMBER);
213: --
214:

Line 237: PARAMETERS: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE

233: DESCRIPTION: This procedure records all the errors/warnings
234: from Process Order API, when attempting to create/book
235: a release sales order.
236:
237: PARAMETERS: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE
238: x_Group_rec IN t_group_rec
239: x_msg_count IN NUMBER
240: x_msg_level IN VARCHAR2
241: x_token IN VARCHAR2

Line 246: PROCEDURE InsertOMMessages(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

242: x_msg_name IN VARCHAR2
243:
244: CHANGE HISTORY: created rlanka 10/10/02
245: ================================================================================*/
246: PROCEDURE InsertOMMessages(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
247: x_Group_rec IN RLM_DP_SV.t_Group_rec,
248: x_msg_count IN NUMBER,
249: x_msg_level IN VARCHAR2,
250: x_token IN VARCHAR2,

Line 262: PARAMETERS: x_sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE

258: DESCRIPTION: This procedure returns the tp group context.
259: and null x_ship_to_ece_locn_code,
260: and null x_inter_ship_to_ece_locn_code
261:
262: PARAMETERS: x_sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE
263: x_group_rec IN t_Group_rec
264: x_customer_number OUT VARCHAR2
265: x_ship_to_ece_locn_code OUT VARCHAR2
266: x_bill_to_ece_locn_code OUT VARCHAR2

Line 273: PROCEDURE GetTPContext( x_sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

269:
270: CHANGE HISTORY: created rlanka 02/12/2003
271:
272: ===========================================================================*/
273: PROCEDURE GetTPContext( x_sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
274: x_group_rec IN rlm_dp_sv.t_Group_rec,
275: x_customer_number OUT NOCOPY VARCHAR2,
276: x_ship_to_ece_locn_code OUT NOCOPY VARCHAR2,
277: x_bill_to_ece_locn_code OUT NOCOPY VARCHAR2,

Line 288: PARAMETERS: x_sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE

284: PROCEDURE NAME: CalFenceDays
285:
286: DESCRIPTION: This procedure returns number of fence days
287:
288: PARAMETERS: x_sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE
289: x_group_rec IN t_Group_rec
290: x_fence_days OUT NUMBER
291:
292: CHANGE HISTORY: created anviswan 30/06/2005

Line 295: Procedure CalFenceDays(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

291:
292: CHANGE HISTORY: created anviswan 30/06/2005
293:
294: ===========================================================================*/
295: Procedure CalFenceDays(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
296: x_Group_rec IN rlm_dp_sv.t_Group_rec,
297: x_fence_days OUT NOCOPY NUMBER);
298:
299: END RLM_BLANKET_SV;