APPS.FLM_KANBANCARD_PUB dependencies on FLM_KANBAN_CONFIG_PARAMS

Line 14: l_status_tbl flm_kanban_config_params.flm_unmovecard_enb_status_t;

10: p_organization_id IN NUMBER)
11: RETURN NUMBER
12: IS
13: l_valid_status Number := 1;
14: l_status_tbl flm_kanban_config_params.flm_unmovecard_enb_status_t;
15: l_counter Number;
16: BEGIN
17: select 1
18: into l_valid_status

Line 24: l_status_tbl := flm_kanban_config_params.get_unmovedcard_enb_status(p_organization_id);

20: where lookup_type = 'MTL_KANBAN_SUPPLY_STATUS'
21: and language = userenv('LANG')
22: and lookup_code = p_supply_status_to;
23:
24: l_status_tbl := flm_kanban_config_params.get_unmovedcard_enb_status(p_organization_id);
25: l_counter := l_status_tbl.first;
26: while l_counter is not null loop
27: if p_supply_status_to = to_number(l_status_tbl(l_counter).status) then
28: l_valid_status := 0;

Line 1011: l_rcv_tolerance := flm_kanban_config_params.get_kanban_tol_fs_inter(l_kanban_card_rec.organization_id);

1007:
1008: -- get the receiving tolerance value and set transaction source type based on kanban source type
1009: if l_source_type = INV_Kanban_PVT.G_Source_Type_InterOrg then
1010: mydebug('Kanban card source type= Inter Org');
1011: l_rcv_tolerance := flm_kanban_config_params.get_kanban_tol_fs_inter(l_kanban_card_rec.organization_id);
1012: l_transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_INTREQ; --7
1013: elsif l_source_type = INV_Kanban_PVT.G_Source_Type_Supplier then
1014: mydebug('Kanban card source type= Supplier');
1015: l_rcv_tolerance := flm_kanban_config_params.get_kanban_tol_fs_supplier(l_kanban_card_rec.organization_id);

Line 1015: l_rcv_tolerance := flm_kanban_config_params.get_kanban_tol_fs_supplier(l_kanban_card_rec.organization_id);

1011: l_rcv_tolerance := flm_kanban_config_params.get_kanban_tol_fs_inter(l_kanban_card_rec.organization_id);
1012: l_transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_INTREQ; --7
1013: elsif l_source_type = INV_Kanban_PVT.G_Source_Type_Supplier then
1014: mydebug('Kanban card source type= Supplier');
1015: l_rcv_tolerance := flm_kanban_config_params.get_kanban_tol_fs_supplier(l_kanban_card_rec.organization_id);
1016: l_transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_PURCHASEORDER; --1
1017: elsif l_source_type = INV_Kanban_PVT.G_Source_Type_IntraOrg then
1018: mydebug('Kanban card source type= Intra Org');
1019: l_rcv_tolerance := flm_kanban_config_params.get_kanban_tol_fs_intra(l_kanban_card_rec.organization_id);

Line 1019: l_rcv_tolerance := flm_kanban_config_params.get_kanban_tol_fs_intra(l_kanban_card_rec.organization_id);

1015: l_rcv_tolerance := flm_kanban_config_params.get_kanban_tol_fs_supplier(l_kanban_card_rec.organization_id);
1016: l_transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_PURCHASEORDER; --1
1017: elsif l_source_type = INV_Kanban_PVT.G_Source_Type_IntraOrg then
1018: mydebug('Kanban card source type= Intra Org');
1019: l_rcv_tolerance := flm_kanban_config_params.get_kanban_tol_fs_intra(l_kanban_card_rec.organization_id);
1020: l_transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_MOVEORDER; --4
1021: elsif l_source_type = INV_Kanban_PVT.G_Source_Type_Production then
1022: mydebug('Kanban card source type= Production');
1023: l_rcv_tolerance := flm_kanban_config_params.get_kanban_tol_fs_prod(l_kanban_card_rec.organization_id);

Line 1023: l_rcv_tolerance := flm_kanban_config_params.get_kanban_tol_fs_prod(l_kanban_card_rec.organization_id);

1019: l_rcv_tolerance := flm_kanban_config_params.get_kanban_tol_fs_intra(l_kanban_card_rec.organization_id);
1020: l_transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_MOVEORDER; --4
1021: elsif l_source_type = INV_Kanban_PVT.G_Source_Type_Production then
1022: mydebug('Kanban card source type= Production');
1023: l_rcv_tolerance := flm_kanban_config_params.get_kanban_tol_fs_prod(l_kanban_card_rec.organization_id);
1024: l_transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_WIP; --5
1025: end if;
1026:
1027: mydebug('receiving_tolerance='||l_rcv_tolerance);