APPS.FLM_KANBAN_PURGE dependencies on FLM_KANBAN_PURGE

Line 1: PACKAGE BODY FLM_KANBAN_PURGE AS

1: PACKAGE BODY FLM_KANBAN_PURGE AS
2: /* $Header: FLMCPPKB.pls 115.6 2002/11/27 11:00:48 nrajpal noship $ */
3:
4: /* The Package contains the following procedures
5: Purge_Kanban_Cards - This is the procedure used to delete the

Line 58: INSERT INTO flm_kanban_purge_temp

54:
55: l_stmt_num := 220;
56:
57: if (l_record_count <> 0) then
58: INSERT INTO flm_kanban_purge_temp
59: (organization_id,
60: item_id,
61: subinventory_code,
62: locator_id,

Line 91: INSERT INTO flm_kanban_purge_temp(

87:
88: l_stmt_num := 240;
89:
90: if (l_record_count <> 0) then
91: INSERT INTO flm_kanban_purge_temp(
92: organization_id,
93: item_id,
94: subinventory_code,
95: locator_id,

Line 221: INSERT INTO flm_kanban_purge_temp

217: AND pull_sequence_id = arg_pull_seq_id );
218:
219: if (l_records_found <> 0) then
220:
221: INSERT INTO flm_kanban_purge_temp
222: (organization_id,
223: item_id,
224: subinventory_code,
225: locator_id,

Line 252: INSERT INTO flm_kanban_purge_temp

248: AND nvl(locator_id,-1) = nvl(arg_loc_id,-1) ;
249:
250: l_stmt_num := 360;
251:
252: INSERT INTO flm_kanban_purge_temp
253: (organization_id,
254: item_id,
255: subinventory_code,
256: locator_id,

Line 476: END FLM_KANBAN_PURGE;

472: dbms_sql.close_cursor(l_sql_p);
473: ROLLBACK;
474: MRP_UTIL.MRP_LOG('Error at '||l_stmt_num|| ' in Purge_Kanban_Card');
475: End Purge_Kanban;
476: END FLM_KANBAN_PURGE;