APPS.FLM_KANBAN_PLANNING_UTIL dependencies on FLM_EKB_DEMAND_INTERFACE

Line 798: from FLM_EKB_DEMAND_INTERFACE

794: v_flm_kanban_demand_intf t_flm_kanban_demand_intf;
795:
796: cursor running_intf_records(org_id Number) is
797: select *
798: from FLM_EKB_DEMAND_INTERFACE
799: where process_status = running
800: and organization_id = org_id;
801:
802: e_null_org_id exception;

Line 826: update FLM_EKB_DEMAND_INTERFACE FEDI

822: g_logLevel := FND_LOG.g_current_runtime_level;
823:
824: l_stmt_num := 20;
825:
826: update FLM_EKB_DEMAND_INTERFACE FEDI
827: set process_status = running,
828: organization_id = nvl(organization_id,p_organization_id),
829: request_id = fnd_global.conc_request_id,
830: program_id = fnd_global.conc_program_id,

Line 927: type t_interface_id is table of FLM_EKB_DEMAND_INTERFACE.interface_id%type index by binary_integer;

923:
924: type t_mrp_kanban_demand is table of mrp_kanban_demand%rowtype index by binary_integer;
925: v_flm_kanban_demand t_mrp_kanban_demand;
926:
927: type t_interface_id is table of FLM_EKB_DEMAND_INTERFACE.interface_id%type index by binary_integer;
928: type t_process_status is table of FLM_EKB_DEMAND_INTERFACE.process_status%type index by binary_integer;
929: type t_error is table of FLM_EKB_DEMAND_INTERFACE.error%type index by binary_integer;
930:
931: v_interface_id t_interface_id;

Line 928: type t_process_status is table of FLM_EKB_DEMAND_INTERFACE.process_status%type index by binary_integer;

924: type t_mrp_kanban_demand is table of mrp_kanban_demand%rowtype index by binary_integer;
925: v_flm_kanban_demand t_mrp_kanban_demand;
926:
927: type t_interface_id is table of FLM_EKB_DEMAND_INTERFACE.interface_id%type index by binary_integer;
928: type t_process_status is table of FLM_EKB_DEMAND_INTERFACE.process_status%type index by binary_integer;
929: type t_error is table of FLM_EKB_DEMAND_INTERFACE.error%type index by binary_integer;
930:
931: v_interface_id t_interface_id;
932: v_process_status t_process_status;

Line 929: type t_error is table of FLM_EKB_DEMAND_INTERFACE.error%type index by binary_integer;

925: v_flm_kanban_demand t_mrp_kanban_demand;
926:
927: type t_interface_id is table of FLM_EKB_DEMAND_INTERFACE.interface_id%type index by binary_integer;
928: type t_process_status is table of FLM_EKB_DEMAND_INTERFACE.process_status%type index by binary_integer;
929: type t_error is table of FLM_EKB_DEMAND_INTERFACE.error%type index by binary_integer;
930:
931: v_interface_id t_interface_id;
932: v_process_status t_process_status;
933: v_error t_error;

Line 1175: update FLM_EKB_DEMAND_INTERFACE set

1171: forall ins_index in v_flm_kanban_demand.first..v_flm_kanban_demand.last
1172: INSERT into MRP_KANBAN_DEMAND values v_flm_kanban_demand(ins_index);
1173:
1174: forall upd_index in v_interface_id.first..v_interface_id.last
1175: update FLM_EKB_DEMAND_INTERFACE set
1176: process_status = decode(v_process_status(upd_index),running,completed,v_process_status(upd_index)),
1177: error = v_error(upd_index),
1178: last_update_date = sysdate
1179: where interface_id = v_interface_id(upd_index);