DBA Data[Home] [Help]

APPS.FLM_KANBAN_MASSLOAD dependencies on FLM_EKB_CARDS_INTERFACE

Line 80: FROM flm_ekb_cards_interface

76: IS
77:
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:

Line 88: UPDATE flm_ekb_cards_interface

84:
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,

Line 172: UPDATE flm_ekb_cards_interface

168: WHERE interface_id = g_pull_seq_tbl(i).interface_id;
169:
170: -- update cards interface status
171: FORALL i IN g_kanban_card_tbl.FIRST..g_kanban_card_tbl.LAST
172: UPDATE flm_ekb_cards_interface
173: SET kanban_card_id = g_kanban_card_tbl(i).kanban_card_id,
174: process_status = g_kanban_card_tbl(i).process_status,
175: error_text = g_kanban_card_tbl(i).error_text
176: WHERE interface_id = g_kanban_card_tbl(i).interface_id;