1 package body create_history as
2 /* $Header: GMPDPHSTB.pls 115.2 2003/01/30 17:29:04 rpatangy noship $ */
3
4 procedure shipment_history (
5 errbuf OUT NOCOPY VARCHAR2,
6 retcode OUT NOCOPY VARCHAR2,
7 p_sr_item_pk IN VARCHAR2,
8 pfrom_date IN DATE,
9 pto_date IN DATE ,
10 pqty IN NUMBER )
11 IS
12 local_date DATE ;
13 l_INSTANCE VARCHAR2(40) ;
14 l_INV_ORG VARCHAR2(320) ;
15 l_ITEM VARCHAR2(320) ;
16 l_CUSTOMER VARCHAR2(320) ;
17 l_SALES_CHANNEL VARCHAR2(320) ;
18 l_SALES_REP VARCHAR2(1000) ;
19 l_SHIP_TO_LOC VARCHAR2(320) ;
20 l_USER_DEFINED1 VARCHAR2(320) ;
21 l_USER_DEFINED2 VARCHAR2(320) ;
22 l_BOOKED_DATE DATE ;
23 l_REQUESTED_DATE DATE ;
24 l_PROMISED_DATE DATE ;
25 l_SHIPPED_DATE DATE ;
26 l_AMOUNT NUMBER ;
27 l_QTY_SHIPPED NUMBER ;
28 l_CREATION_DATE DATE ;
29 l_CREATED_BY NUMBER ;
30 l_LAST_UPDATE_DATE DATE ;
31 l_LAST_UPDATED_BY NUMBER ;
32 l_LAST_UPDATE_LOGIN NUMBER ;
33 l_REQUEST_ID NUMBER ;
34 l_PROGRAM_APPLICATION_ID NUMBER ;
35 l_PROGRAM_ID NUMBER ;
36 l_PROGRAM_UPDATE_DATE DATE ;
37 l_SR_INV_ORG_PK VARCHAR2(240) ;
38 l_SR_ITEM_PK VARCHAR2(240) ;
39 l_SR_CUSTOMER_PK VARCHAR2(240) ;
40 l_SR_SALES_CHANNEL_PK VARCHAR2(240) ;
41 l_SR_SALES_REP_PK VARCHAR2(240) ;
42 l_SR_SHIP_TO_LOC_PK VARCHAR2(240) ;
43 l_SR_USER_DEFINED1_PK VARCHAR2(240) ;
44 l_SR_USER_DEFINED2_PK VARCHAR2(240) ;
45
46 BEGIN
47
48 -- This code is being used for developement purpose and not suppose to
49 -- be included in any patchsets. As it is already included in the patchsets
50 -- , we are removing the complete code with NULL statement.
51
52 NULL ;
53 END shipment_history ;
54
55 -- ==========================================================================
56 procedure booking_history (
57 errbuf OUT NOCOPY VARCHAR2,
58 retcode OUT NOCOPY VARCHAR2,
59 p_sr_item_pk IN VARCHAR2,
60 pfrom_date IN DATE,
61 pto_date IN DATE ,
62 pqty IN NUMBER )
63 IS
64 local_date DATE ;
65 l_INSTANCE VARCHAR2(40) ;
66 l_INV_ORG VARCHAR2(320) ;
67 l_ITEM VARCHAR2(320) ;
68 l_CUSTOMER VARCHAR2(320) ;
69 l_SALES_CHANNEL VARCHAR2(320) ;
70 l_SALES_REP VARCHAR2(1000) ;
71 l_SHIP_TO_LOC VARCHAR2(320) ;
72 l_USER_DEFINED1 VARCHAR2(320) ;
73 l_USER_DEFINED2 VARCHAR2(320) ;
74 l_BOOKED_DATE DATE ;
75 l_REQUESTED_DATE DATE ;
76 l_PROMISED_DATE DATE ;
77 l_SCHEDULED_DATE DATE ;
78 l_AMOUNT NUMBER ;
79 l_QTY_ORDERED NUMBER ;
80 l_CREATION_DATE DATE ;
81 l_CREATED_BY NUMBER ;
82 l_LAST_UPDATE_DATE DATE ;
83 l_LAST_UPDATED_BY NUMBER ;
84 l_LAST_UPDATE_LOGIN NUMBER ;
85 l_REQUEST_ID NUMBER ;
86 l_PROGRAM_APPLICATION_ID NUMBER ;
87 l_PROGRAM_ID NUMBER ;
88 l_PROGRAM_UPDATE_DATE DATE ;
89 l_SR_INV_ORG_PK VARCHAR2(240) ;
90 l_SR_ITEM_PK VARCHAR2(240) ;
91 l_SR_CUSTOMER_PK VARCHAR2(240) ;
92 l_SR_SALES_CHANNEL_PK VARCHAR2(240) ;
93 l_SR_SALES_REP_PK VARCHAR2(240) ;
94 l_SR_SHIP_TO_LOC_PK VARCHAR2(240) ;
95 l_SR_USER_DEFINED1_PK VARCHAR2(240) ;
96 l_SR_USER_DEFINED2_PK VARCHAR2(240) ;
97
98 BEGIN
99
100 -- This code is being used for developement purpose and not suppose to
101 -- be included in any patchsets. As it is already included in the patchsets
102 -- , we are removing the complete code with NULL statement.
103
104 NULL ;
105 END booking_history ;
106
107 END create_history ;