[Home] [Help]
PACKAGE: APPS.WSH_PR_PICKING_OBJECTS
Source
1 PACKAGE WSH_PR_PICKING_OBJECTS AUTHID CURRENT_USER AS
2 /* $Header: WSHPRPOS.pls 115.3 99/07/16 08:20:03 porting ship $ */
3
4 --
5 -- Package
6 -- WSH_PR_PICKING_OBJECTS
7 --
8 -- Purpose
9 -- This package does the following:
10 -- - Determines whether a new picking header or pick slip number
11 -- is to be created.
12 -- - Inserts a new picking header if necessary
13 -- - Inserts picking lines
14 -- - Inserts picking line details
15 --
16 -- History
17 -- 16-SEP-96 RSHIVRAM Created
18 --
19
20 --
21 -- PACKAGE TYPES
22 --
23 TYPE keyRecTyp IS RECORD (
24 key VARCHAR2(200),
25 value NUMBER
26 );
27
28 TYPE keyTabTyp IS TABLE OF keyRecTyp INDEX BY BINARY_INTEGER;
29
30 --
31 -- PUBLIC VARIABLES
32 --
33
34 g_login_id NUMBER;
35 g_user_id NUMBER;
36 g_program_id NUMBER;
37 g_request_id NUMBER;
38 g_application_id NUMBER;
39 g_batch_id NUMBER;
40 g_pick_slip_rule_id NUMBER;
41 g_warehouse_id NUMBER;
42 g_use_autocreate_del_orders VARCHAR2(1) := 'Y';
43 g_autocreate_deliveries VARCHAR2(1);
44 g_reservations VARCHAR2(1) := 'Y';
45 g_use_order_ps VARCHAR2(1) := 'N';
46 g_use_sub_ps VARCHAR2(1) := 'N';
47 g_use_customer_ps VARCHAR2(1) := 'N';
48 g_use_ship_to_ps VARCHAR2(1) := 'N';
49 g_use_carrier_ps VARCHAR2(1) := 'N';
50 g_use_ship_priority_ps VARCHAR2(1) := 'N';
51 g_use_departure_ps VARCHAR2(1) := 'N';
52 g_use_delivery_ps VARCHAR2(1) := 'N';
53 g_ps_table keyTabTyp;
54 g_ph_table keyTabTyp;
55
56 --
57 -- PUBLIC FUNCTIONS/PROCEDURES
58 --
59
60 --
61 -- Name
62 -- FUNCTION Init
63 --
64 -- Purpose
65 -- This function initializes the who variables, reservations variable,
66 -- and the use_ variables to be used in determining the how to group
67 -- pick slips.
68 --
69 -- Return Values
70 -- -1 => Failure
71 -- 0 => Success
72 --
73 -- Notes
74 --
75
76 FUNCTION Init RETURN BINARY_INTEGER;
77
78 --
79 -- Name
80 -- FUNCTION Insert_Lines
81 --
82 -- Purpose
83 -- This function inserts picking headers, picking lines,
84 -- picking line details and order lines if applicable.
85 --
86 -- Return Values
87 -- -1 => Failure
88 -- 0 => Success
89 --
90 -- Notes
91 --
92
93 FUNCTION Insert_lines(
94 p_backorder_line IN BINARY_INTEGER,
95 p_order_header_id IN BINARY_INTEGER,
96 p_org_id IN BINARY_INTEGER,
97 p_customer_id IN BINARY_INTEGER,
98 p_ship_to_site_use_id IN BINARY_INTEGER,
99 p_component_code IN VARCHAR2,
100 p_component_ratio IN BINARY_INTEGER,
101 p_component_sequence_id IN BINARY_INTEGER,
102 p_date_requested IN DATE,
103 p_included_item_flag IN VARCHAR2,
104 p_inventory_item_id IN BINARY_INTEGER,
105 p_original_line_detail_id IN BINARY_INTEGER,
106 p_order_line_id IN BINARY_INTEGER,
107 p_original_requested_quantity IN BINARY_INTEGER,
108 p_requested_quantity IN BINARY_INTEGER,
109 p_schedule_date IN DATE,
110 p_sequence_number IN BINARY_INTEGER,
111 p_shipment_priority_code IN VARCHAR2,
112 p_ship_method_code IN VARCHAR2,
113 p_ship_to_contact_id IN BINARY_INTEGER,
114 p_unit_code IN VARCHAR2,
115 p_warehouse_id IN BINARY_INTEGER,
116 p_delivery IN BINARY_INTEGER,
117 p_demand_class IN VARCHAR2,
118 p_reservable_flag IN VARCHAR2,
119 p_schedule_level IN BINARY_INTEGER,
120 p_schedule_status_code IN VARCHAR2,
121 p_subinventory IN VARCHAR2,
122 p_autodetailed_quantity IN BINARY_INTEGER,
123 p_transactable_flag IN VARCHAR2,
124 p_config_item_flag IN VARCHAR2,
125 p_customer_requested_lot_flag IN VARCHAR2,
126 p_departure_id IN BINARY_INTEGER,
127 p_delivery_id IN OUT BINARY_INTEGER,
128 p_dep_plan_required_flag IN VARCHAR2,
129 p_customer_item_id IN BINARY_INTEGER,
130 p_master_container_item_id IN BINARY_INTEGER,
131 p_detail_container_item_id IN BINARY_INTEGER,
132 p_load_seq_number IN BINARY_INTEGER,
133 p_ccid IN BINARY_INTEGER,
134 p_autodetail_group_id IN BINARY_INTEGER,
135 p_autobackorder IN VARCHAR2,
136 p_picking_line_id IN OUT BINARY_INTEGER,
137 p_abo_picking_line_id IN OUT BINARY_INTEGER,
138 p_picking_header_id IN OUT BINARY_INTEGER,
139 p_new_line_detail_id IN OUT BINARY_INTEGER,
140 p_new_delivery IN OUT BINARY_INTEGER,
141 p_abo_recs IN OUT BINARY_INTEGER,
142 p_pld_recs IN OUT BINARY_INTEGER,
143 p_old_recs IN OUT BINARY_INTEGER
144 )
145 RETURN BINARY_INTEGER;
146
147 END WSH_PR_PICKING_OBJECTS;