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
46: WHERE group_id = p_group_id
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
46: WHERE group_id = p_group_id
47: AND process_status = flm_kanban_massload.pending;
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
46: WHERE group_id = p_group_id
47: AND process_status = flm_kanban_massload.pending;
48:
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
94: WHERE group_id = p_group_id
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
94: WHERE group_id = p_group_id
95: AND process_status = flm_kanban_massload.pending;
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
94: WHERE group_id = p_group_id
95: AND process_status = flm_kanban_massload.pending;
96: