APPS.FND_LOADER_OPEN_INTERFACE_PKG dependencies on FND_LOADER_OPEN_INTERFACE

Line 1: package body FND_LOADER_OPEN_INTERFACE_PKG as

1: package body FND_LOADER_OPEN_INTERFACE_PKG as
2: /* $Header: FNDOFACB.pls 120.1 2005/08/31 13:13:36 rsekaran noship $ */
3:
4: --
5: -- Procedure

Line 41: -- Insert a batch of record into fnd_loader_open_interface table.

37: -- Function
38: -- INSERT_BATCH
39: --
40: -- Purpose
41: -- Insert a batch of record into fnd_loader_open_interface table.
42: -- If all parameters are null, this function simply return a new batch_id.
43: --
44: -- Arguments:
45: -- IN:

Line 56: FND_LOADER_OPEN_INTERFACE_S.nextval

52: FUNCTION INSERT_BATCH RETURN INTEGER is
53: l_next_seq INTEGER;
54: BEGIN
55: SELECT
56: FND_LOADER_OPEN_INTERFACE_S.nextval
57: INTO
58: l_next_seq
59: FROM
60: dual;

Line 79: FND_LOADER_OPEN_INTERFACE_S.nextval

75: l_seq_in_batch l_seq_in_batch_TAB;
76: indx integer;
77: BEGIN
78: SELECT
79: FND_LOADER_OPEN_INTERFACE_S.nextval
80: INTO
81: l_next_seq
82: FROM
83: dual;

Line 92: INSERT INTO FND_LOADER_OPEN_INTERFACE

88:
89: BEGIN
90: FOR i IN 1..X_lct.count LOOP
91: indx := i; -- Store the index of the data being inserted, in case we need to print the exception message.
92: INSERT INTO FND_LOADER_OPEN_INTERFACE
93: (
94: batch_id,
95: seq_in_batch,
96: lct,

Line 115: raise_application_error(-20101,'INSERT_BATCH : Failed to insert element ' || to_char(indx) || ' of the batch into the table FND_LOADER_OPEN_INTERFACE.',true);

111: END LOOP;
112: COMMIT;
113: EXCEPTION
114: WHEN OTHERS THEN
115: raise_application_error(-20101,'INSERT_BATCH : Failed to insert element ' || to_char(indx) || ' of the batch into the table FND_LOADER_OPEN_INTERFACE.',true);
116: end;
117: return l_next_seq;
118: END;
119:

Line 125: -- Add a list of records to fnd_loader_open_interface table with given batch_id

121: -- Procedure
122: -- ADD_ROW_TO_BATCH
123: --
124: -- Purpose
125: -- Add a list of records to fnd_loader_open_interface table with given batch_id
126: --
127: -- Arguments:
128: -- IN:
129: -- X_BATCH_ID -- Batch_id

Line 156: FND_LOADER_OPEN_INTERFACE

152: nvl(MAX(SEQ_IN_BATCH),0)
153: INTO
154: l_max_seq_in_batch
155: FROM
156: FND_LOADER_OPEN_INTERFACE
157: WHERE
158: BATCH_ID=X_BATCH_ID;
159:
160: FOR i in 1..X_lct.count loop

Line 168: INSERT INTO FND_LOADER_OPEN_INTERFACE

164:
165: BEGIN
166: FOR i IN 1..X_lct.count LOOP
167: indx := i; -- Store the index of the data being inserted, in case we need to print the exception message.
168: INSERT INTO FND_LOADER_OPEN_INTERFACE
169: (
170: batch_id,
171: seq_in_batch,
172: lct,

Line 200: -- Add a record to fnd_loader_open_interface table with given batch_id

196: -- Procedure
197: -- ADD_ROW_TO_BATCH
198: --
199: -- Purpose
200: -- Add a record to fnd_loader_open_interface table with given batch_id
201: --
202: -- Arguments:
203: -- IN:
204: -- X_BATCH_ID -- Batch_id

Line 228: FND_LOADER_OPEN_INTERFACE

224: nvl(MAX(SEQ_IN_BATCH),0)
225: INTO
226: l_max_seq_in_batch
227: FROM
228: FND_LOADER_OPEN_INTERFACE
229: WHERE
230: BATCH_ID=X_BATCH_ID;
231:
232: begin

Line 233: INSERT INTO FND_LOADER_OPEN_INTERFACE

229: WHERE
230: BATCH_ID=X_BATCH_ID;
231:
232: begin
233: INSERT INTO FND_LOADER_OPEN_INTERFACE
234: (
235: batch_id,
236: seq_in_batch,
237: lct,

Line 265: -- Purge record with specific batch_id from fnd_loader_open_interface table;

261: -- Procedure
262: -- DELETE_BATCH
263: --
264: -- Purpose
265: -- Purge record with specific batch_id from fnd_loader_open_interface table;
266: --
267: -- Arguments
268: -- IN:
269: -- X_BATCH_ID -- Batch_id

Line 277: fnd_loader_open_interface

273: ) IS
274: BEGIN
275: BEGIN
276: DELETE FROM
277: fnd_loader_open_interface
278: WHERE
279: batch_id=X_BATCH_ID;
280: commit;
281: EXCEPTION

Line 287: END FND_LOADER_OPEN_INTERFACE_PKG;

283: raise_application_error(-20401,'DELETE_BATCH : Failed to delete the batch : ' || to_char(X_BATCH_ID),true);
284: END;
285: END DELETE_BATCH;
286:
287: END FND_LOADER_OPEN_INTERFACE_PKG;