PACKAGE: APPS.WSH_RLM_INTERFACE

Source

1 PACKAGE WSH_RLM_INTERFACE AS
2 /* $Header: WSHRLMIS.pls 120.2.12000000.2 2007/04/09 10:16:39 sunilku ship $*/
3 
4 k_VNULL	  CONSTANT VARCHAR2(25) := 'THIS_IS_A_NULL_VALUE';
5 k_DNULL   CONSTANT DATE         := to_date('01/01/1930','dd/mm/yyyy');
6 k_NNULL   CONSTANT NUMBER       := -19999999999;
7 
8 TYPE t_shipper_rec is RECORD(
9     shipper_ID1	VARCHAR2(30),
10     shipper_ID2 VARCHAR2(30),
11     shipper_ID3 VARCHAR2(30),
12     shipper_ID4 VARCHAR2(30),
13     shipper_ID5 VARCHAR2(30));
14 
15 TYPE t_optional_match_rec is RECORD(
16     cust_production_line            VARCHAR2(50),
17     customer_dock_code              VARCHAR2(50),
18     request_date                    DATE,
19     schedule_date                   DATE,
20     cust_po_number                  VARCHAR2(50),
21     customer_item_revision          VARCHAR2(35),
22     customer_job                    VARCHAR2(50),
23     cust_model_serial_number        VARCHAR2(35),
24     cust_production_seq_num         VARCHAR2(35),
25     industry_attribute1             VARCHAR2(150),
26     industry_attribute2             VARCHAR2(150),
27     industry_attribute3             VARCHAR2(150),
28     industry_attribute4             VARCHAR2(150),
29     industry_attribute5             VARCHAR2(150),
30     industry_attribute6             VARCHAR2(150),
31     industry_attribute7             VARCHAR2(150),
32     industry_attribute8             VARCHAR2(150),
33     industry_attribute9             VARCHAR2(150),
34     industry_attribute10            VARCHAR2(150),
35     industry_attribute11            VARCHAR2(150),
36     industry_attribute12            VARCHAR2(150),
37     industry_attribute13            VARCHAR2(150),
38     industry_attribute14            VARCHAR2(150),
39     industry_attribute15            VARCHAR2(150),
40     attribute1                      VARCHAR2(150),
41     attribute2                      VARCHAR2(150),
42     attribute3                      VARCHAR2(150),
43     attribute4                      VARCHAR2(150),
44     attribute5                      VARCHAR2(150),
45     attribute6                      VARCHAR2(150),
46     attribute7                      VARCHAR2(150),
47     attribute8                      VARCHAR2(150),
48     attribute9                      VARCHAR2(150),
49     attribute10                     VARCHAR2(150),
50     attribute11                     VARCHAR2(150),
51     attribute12                     VARCHAR2(150),
52     attribute13                     VARCHAR2(150),
53     attribute14                     VARCHAR2(150),
54     attribute15                     VARCHAR2(150));
55 
56 
57 PROCEDURE Get_In_Transit_Qty(
58    p_source_code              IN   VARCHAR2 DEFAULT 'OE',
59    p_customer_id              IN   NUMBER,
60    p_ship_to_org_id           IN   NUMBER,
61    p_intmed_ship_to_org_id    IN   NUMBER,--Bugfix 5911991
62    p_ship_from_org_id         IN   NUMBER,
63    p_inventory_item_id        IN   NUMBER,
64    p_customer_item_id	      IN   NUMBER,
65    p_order_header_id          IN   NUMBER,
66    p_blanket_number           IN   NUMBER,
67    p_org_id                   IN   NUMBER DEFAULT NULL,
68    p_schedule_type	      IN   VARCHAR2,
69    p_shipper_recs             IN   T_SHIPPER_REC,
70    p_shipment_date            IN   DATE  DEFAULT NULL,
71    p_match_within_rule	      IN   RLM_CORE_SV.T_MATCH_REC,
72    p_match_across_rule	      IN   RLM_CORE_SV.T_MATCH_REC,
73    p_optional_match_rec       IN   T_OPTIONAL_MATCH_REC,
74    x_in_transit_qty           OUT NOCOPY   NUMBER,
75    x_return_status            OUT NOCOPY   VARCHAR2);
76 
77 END WSH_RLM_INTERFACE;