APPS.FLM_KANBAN_MASSLOAD dependencies on FLM_KANBAN_MASSLOAD

Line 1: PACKAGE BODY FLM_KANBAN_MASSLOAD AS

1: PACKAGE BODY FLM_KANBAN_MASSLOAD AS
2: /* $Header: FLMKBNMB.pls 120.2 2011/04/27 00:51:30 atjen noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(20) := 'FLM_KANBAN_MASSLOAD';
5:

Line 4: G_PKG_NAME CONSTANT VARCHAR2(20) := 'FLM_KANBAN_MASSLOAD';

1: PACKAGE BODY FLM_KANBAN_MASSLOAD AS
2: /* $Header: FLMKBNMB.pls 120.2 2011/04/27 00:51:30 atjen noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(20) := 'FLM_KANBAN_MASSLOAD';
5:
6: g_pull_seq_tbl pull_seq_tbl_type;
7: g_supplier_tbl kanban_supp_tbl_type;
8: g_kanban_card_tbl card_int_tbl_type;

Line 25: AND process_status = flm_kanban_massload.running

21: CURSOR c_ps_rows IS
22: SELECT *
23: FROM flm_ekb_pull_seq_interface
24: WHERE group_id = p_group_id
25: AND process_status = flm_kanban_massload.running
26: ORDER BY interface_id;
27:
28: CURSOR c_supplier_rows IS
29: SELECT ksi.*

Line 33: AND psi.process_status = flm_kanban_massload.running

29: SELECT ksi.*
30: FROM flm_ekb_pull_seq_interface psi,
31: flm_ekb_supplier_interface ksi
32: WHERE psi.interface_id = ksi.parent_interface_id
33: AND psi.process_status = flm_kanban_massload.running
34: AND psi.group_id = p_group_id
35: ORDER BY ksi.parent_interface_id;
36:
37: BEGIN

Line 41: SET process_status = flm_kanban_massload.running,

37: BEGIN
38:
39: --set process_status to running..
40: UPDATE flm_ekb_pull_seq_interface
41: SET process_status = flm_kanban_massload.running,
42: request_id = FND_GLOBAL.CONC_REQUEST_ID,
43: program_application_id = FND_GLOBAL.PROG_APPL_ID,
44: program_id = FND_GLOBAL.CONC_PROGRAM_ID,
45: program_update_date = SYSDATE

Line 47: AND process_status = flm_kanban_massload.pending;

43: program_application_id = FND_GLOBAL.PROG_APPL_ID,
44: program_id = FND_GLOBAL.CONC_PROGRAM_ID,
45: program_update_date = SYSDATE
46: WHERE group_id = p_group_id
47: AND process_status = flm_kanban_massload.pending;
48:
49: --load the pull seq interface records to plsql table
50: OPEN c_ps_rows;
51: FETCH c_ps_rows BULK COLLECT INTO g_pull_seq_tbl;

Line 82: AND process_status = flm_kanban_massload.running

78: CURSOR c_card_rows IS
79: SELECT *
80: FROM flm_ekb_cards_interface
81: WHERE group_id = p_group_id
82: AND process_status = flm_kanban_massload.running
83: ORDER BY interface_id;
84:
85: BEGIN
86:

Line 89: SET process_status = flm_kanban_massload.running,

85: BEGIN
86:
87: --set process_status to running..
88: UPDATE flm_ekb_cards_interface
89: SET process_status = flm_kanban_massload.running,
90: request_id = FND_GLOBAL.CONC_REQUEST_ID,
91: program_application_id = FND_GLOBAL.PROG_APPL_ID,
92: program_id = FND_GLOBAL.CONC_PROGRAM_ID,
93: program_update_date = SYSDATE

Line 95: AND process_status = flm_kanban_massload.pending;

91: program_application_id = FND_GLOBAL.PROG_APPL_ID,
92: program_id = FND_GLOBAL.CONC_PROGRAM_ID,
93: program_update_date = SYSDATE
94: WHERE group_id = p_group_id
95: AND process_status = flm_kanban_massload.pending;
96:
97: --load the Kanban Cards interface records to plsql table
98: OPEN c_card_rows;
99: FETCH c_card_rows BULK COLLECT INTO g_kanban_card_tbl;

Line 203: END FLM_KANBAN_MASSLOAD;

199: l_conc_status := fnd_concurrent.set_completion_status('ERROR', errbuf);
200:
201: END load_kanban;
202:
203: END FLM_KANBAN_MASSLOAD;