PACKAGE: APPS.INV_PICK_SLIP_REPORT

Source

1 PACKAGE inv_pick_slip_report AS
2   /* $Header: INVPKSLS.pls 120.0 2005/05/25 04:37:51 appldev noship $ */
3 
4   /*
5   ** -------------------------------------------------------------------------
6   ** Function:    chk_wms_install
7   ** Description: Checks to see if WMS is installed
8   **               This API should be used only for Move Order Pick Slip Report's
9   **               Move order type value set.
10   ** Input:       None
11   ** Output:      none
12   ** Returns:
13   **      'TRUE' if WMS installed, else 'FALSE'
14   **
15   ** --------------------------------------------------------------------------
16   */
17   FUNCTION chk_wms_install(p_organization_id NUMBER)
18     RETURN VARCHAR2;
19 
20   PROCEDURE run_detail_engine(
21     x_return_status           OUT NOCOPY    VARCHAR2
22   , p_org_id                                NUMBER
23   , p_move_order_type                       NUMBER
24   , p_move_order_from                       VARCHAR2
25   , p_move_order_to                         VARCHAR2
26   , p_source_subinv                         VARCHAR2
27   , p_source_locator_id                     NUMBER
28   , p_dest_subinv                           VARCHAR2
29   , p_dest_locator_id                       NUMBER
30   , p_sales_order_from                      VARCHAR2
31   , p_sales_order_to                        VARCHAR2
32   , p_freight_code                          VARCHAR2
33   , p_customer_id                           NUMBER
34   , p_requested_by                          NUMBER
35   , p_date_reqd_from                        DATE
36   , p_date_reqd_to                          DATE
37   , p_plan_tasks                            BOOLEAN
38   , p_pick_slip_group_rule_id               NUMBER
39   , p_request_id                            NUMBER DEFAULT 1); /* Added p_request_id to fix Bug# 3869858 */
40 
41   FUNCTION print_pick_slip(
42     p_organization_id         VARCHAR2
43   , p_move_order_from         VARCHAR2 DEFAULT ''
44   , p_move_order_to           VARCHAR2 DEFAULT ''
45   , p_pick_slip_number_from   VARCHAR2 DEFAULT ''
46   , p_pick_slip_number_to     VARCHAR2 DEFAULT ''
47   , p_source_subinv           VARCHAR2 DEFAULT ''
48   , p_source_locator          VARCHAR2 DEFAULT ''
49   , p_dest_subinv             VARCHAR2 DEFAULT ''
50   , p_dest_locator            VARCHAR2 DEFAULT ''
51   , p_requested_by            VARCHAR2 DEFAULT ''
52   , p_date_reqd_from          VARCHAR2 DEFAULT ''
53   , p_date_reqd_to            VARCHAR2 DEFAULT ''
54   , p_print_option            VARCHAR2 DEFAULT '99'
55   , p_print_mo_type           VARCHAR2 DEFAULT '99'
56   , p_sales_order_from        VARCHAR2 DEFAULT ''
57   , p_sales_order_to          VARCHAR2 DEFAULT ''
58   , p_ship_method_code        VARCHAR2 DEFAULT ''
59   , p_customer_id             VARCHAR2 DEFAULT ''
60   , p_auto_allocate           VARCHAR2 DEFAULT 'N'
61   , p_plan_tasks              VARCHAR2 DEFAULT 'N'
62   , p_pick_slip_group_rule_id VARCHAR2 DEFAULT ''
63   ) RETURN NUMBER;
64 
65 END inv_pick_slip_report;