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.4 2006/12/12 11:15:08 pannapra noship $ */
3:
4: --This package is created to finish the kanban mobile transactions
5: -- including replenishment and inquiry

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

378: x_source_project := inv_project.get_project_number;
379: x_source_task := inv_project.get_task_number;
380: x_source_org_id := source_org_id;
381: /*End of PJM-WMS Integration */
382: x_supplier_site := inv_kanban_pkg.getsuppliersitename(supplier_site_id);
383: x_message := 'Item: ' || x_item;
384: x_status := 'C';
385:
386: IF inv_kanban_pvt.eligible_for_lbj

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

500: , msiv.concatenated_segments item
501: , msiv.description
502: , mkc.kanban_size
503: , mkc.subinventory_name
504: , inv_kanban_pkg.getlocatorname(p_org_id, mkc.locator_id) loc_name
505: , inv_project.get_project_number project_num
506: , inv_project.get_task_number task_num
507: , mfg2.meaning card_status_name
508: , mfg3.meaning supply_status_name

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

506: , inv_project.get_task_number task_num
507: , mfg2.meaning card_status_name
508: , mfg3.meaning supply_status_name
509: , mfg4.meaning source_type
510: , inv_kanban_pkg.getorgcode(mkc.source_organization_id)
511: , mkc.source_subinventory
512: , inv_kanban_pkg.getlocatorname(mkc.source_organization_id, mkc.source_locator_id) source_loc_name
513: , inv_project.get_project_number src_project_num
514: , inv_project.get_task_number src_task_num

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

508: , mfg3.meaning supply_status_name
509: , mfg4.meaning source_type
510: , inv_kanban_pkg.getorgcode(mkc.source_organization_id)
511: , mkc.source_subinventory
512: , inv_kanban_pkg.getlocatorname(mkc.source_organization_id, mkc.source_locator_id) source_loc_name
513: , inv_project.get_project_number src_project_num
514: , inv_project.get_task_number src_task_num
515: , mka.last_update_date
516: , mfg5.meaning act_supp_status_name

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

514: , inv_project.get_task_number src_task_num
515: , mka.last_update_date
516: , mfg5.meaning act_supp_status_name
517: , mfg6.meaning doc_type
518: , inv_kanban_pkg.getdocmentnumber(mka.document_header_id, mka.document_type, mka.document_detail_id) doc_num
519: , inv_kanban_pkg.getorgcode(mka.source_organization_id)
520: , mka.source_subinventory act_sub
521: , inv_kanban_pkg.getlocatorname(mka.source_organization_id, mka.source_locator_id) act_loc_name
522: , inv_project.get_project_number act_project_num

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

515: , mka.last_update_date
516: , mfg5.meaning act_supp_status_name
517: , mfg6.meaning doc_type
518: , inv_kanban_pkg.getdocmentnumber(mka.document_header_id, mka.document_type, mka.document_detail_id) doc_num
519: , inv_kanban_pkg.getorgcode(mka.source_organization_id)
520: , mka.source_subinventory act_sub
521: , inv_kanban_pkg.getlocatorname(mka.source_organization_id, mka.source_locator_id) act_loc_name
522: , inv_project.get_project_number act_project_num
523: , inv_project.get_task_number act_task_num

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

517: , mfg6.meaning doc_type
518: , inv_kanban_pkg.getdocmentnumber(mka.document_header_id, mka.document_type, mka.document_detail_id) doc_num
519: , inv_kanban_pkg.getorgcode(mka.source_organization_id)
520: , mka.source_subinventory act_sub
521: , inv_kanban_pkg.getlocatorname(mka.source_organization_id, mka.source_locator_id) act_loc_name
522: , inv_project.get_project_number act_project_num
523: , inv_project.get_task_number act_task_num
524: , pv.vendor_name vendor
525: , pvsa.vendor_site_code vendor_site

Line 790: END inv_kanban_pkg;

786: END IF;
787: CLOSE c_kb_mo_details;
788:
789: END get_kanban_mo_details;
790: END inv_kanban_pkg;