DBA Data[Home] [Help]

APPS.INV_KANBAN_PKG dependencies on INV_KANBAN_PKG

Line 1: PACKAGE BODY inv_kanban_pkg AS

1: PACKAGE BODY inv_kanban_pkg AS
2: /* $Header: INVKBAPB.pls 120.6 2011/02/14 19:54:45 atjen ship $ */
3:
4: --This package is created to finish the kanban mobile transactions
5: -- including replenishment and inquiry

Line 393: x_supplier_site := inv_kanban_pkg.getsuppliersitename(supplier_site_id);

389: x_source_project := inv_project.get_project_number;
390: x_source_task := inv_project.get_task_number;
391: x_source_org_id := source_org_id;
392: /*End of PJM-WMS Integration */
393: x_supplier_site := inv_kanban_pkg.getsuppliersitename(supplier_site_id);
394: x_message := 'Item: ' || x_item;
395: x_status := 'C';
396:
397: IF inv_kanban_pvt.eligible_for_lbj

Line 515: , inv_kanban_pkg.getlocatorname(p_org_id, mkc.locator_id) loc_name

511: , msiv.concatenated_segments item
512: , msiv.description
513: , mkc.kanban_size
514: , mkc.subinventory_name
515: , inv_kanban_pkg.getlocatorname(p_org_id, mkc.locator_id) loc_name
516: , inv_project.get_project_number project_num
517: , inv_project.get_task_number task_num
518: , mfg2.meaning card_status_name
519: , mfg3.meaning supply_status_name

Line 521: , inv_kanban_pkg.getorgcode(mkc.source_organization_id)

517: , inv_project.get_task_number task_num
518: , mfg2.meaning card_status_name
519: , mfg3.meaning supply_status_name
520: , mfg4.meaning source_type
521: , inv_kanban_pkg.getorgcode(mkc.source_organization_id)
522: , mkc.source_subinventory
523: , inv_kanban_pkg.getlocatorname(mkc.source_organization_id, mkc.source_locator_id) source_loc_name
524: , inv_project.get_project_number src_project_num
525: , inv_project.get_task_number src_task_num

Line 523: , inv_kanban_pkg.getlocatorname(mkc.source_organization_id, mkc.source_locator_id) source_loc_name

519: , mfg3.meaning supply_status_name
520: , mfg4.meaning source_type
521: , inv_kanban_pkg.getorgcode(mkc.source_organization_id)
522: , mkc.source_subinventory
523: , inv_kanban_pkg.getlocatorname(mkc.source_organization_id, mkc.source_locator_id) source_loc_name
524: , inv_project.get_project_number src_project_num
525: , inv_project.get_task_number src_task_num
526: , mka.last_update_date
527: , mfg5.meaning act_supp_status_name

Line 529: , inv_kanban_pkg.getdocmentnumber(mka.document_header_id, mka.document_type, mka.document_detail_id) doc_num

525: , inv_project.get_task_number src_task_num
526: , mka.last_update_date
527: , mfg5.meaning act_supp_status_name
528: , mfg6.meaning doc_type
529: , inv_kanban_pkg.getdocmentnumber(mka.document_header_id, mka.document_type, mka.document_detail_id) doc_num
530: , inv_kanban_pkg.getorgcode(mka.source_organization_id)
531: , mka.source_subinventory act_sub
532: , inv_kanban_pkg.getlocatorname(mka.source_organization_id, mka.source_locator_id) act_loc_name
533: , inv_project.get_project_number act_project_num

Line 530: , inv_kanban_pkg.getorgcode(mka.source_organization_id)

526: , mka.last_update_date
527: , mfg5.meaning act_supp_status_name
528: , mfg6.meaning doc_type
529: , inv_kanban_pkg.getdocmentnumber(mka.document_header_id, mka.document_type, mka.document_detail_id) doc_num
530: , inv_kanban_pkg.getorgcode(mka.source_organization_id)
531: , mka.source_subinventory act_sub
532: , inv_kanban_pkg.getlocatorname(mka.source_organization_id, mka.source_locator_id) act_loc_name
533: , inv_project.get_project_number act_project_num
534: , inv_project.get_task_number act_task_num

Line 532: , inv_kanban_pkg.getlocatorname(mka.source_organization_id, mka.source_locator_id) act_loc_name

528: , mfg6.meaning doc_type
529: , inv_kanban_pkg.getdocmentnumber(mka.document_header_id, mka.document_type, mka.document_detail_id) doc_num
530: , inv_kanban_pkg.getorgcode(mka.source_organization_id)
531: , mka.source_subinventory act_sub
532: , inv_kanban_pkg.getlocatorname(mka.source_organization_id, mka.source_locator_id) act_loc_name
533: , inv_project.get_project_number act_project_num
534: , inv_project.get_task_number act_task_num
535: , pv.vendor_name vendor
536: , pvsa.vendor_site_code vendor_site

Line 801: END inv_kanban_pkg;

797: END IF;
798: CLOSE c_kb_mo_details;
799:
800: END get_kanban_mo_details;
801: END inv_kanban_pkg;