eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.QPR_PN_REQUEST_HDRS_PKG

Source


1 package QPR_PN_REQUEST_HDRS_PKG as
2 /* $Header: QPRUPRHS.pls 120.0 2007/12/24 20:04:56 vinnaray noship $ */
3 procedure INSERT_ROW (
4   X_ROWID in out nocopy VARCHAR2,
5   X_REQUEST_HEADER_ID in NUMBER,
6   X_SOURCE_REF_HDR_LONG_DESC in VARCHAR2,
7 --  X_ORG_SHORT_DESC in VARCHAR2,
8 --  X_ORG_LONG_DESC in VARCHAR2,
9   X_CUSTOMER_SHORT_DESC in VARCHAR2,
10   X_CUSTOMER_LONG_DESC in VARCHAR2,
11 --  X_CONTRACT_SHORT_DESC in VARCHAR2,
12 --  X_CONTRACT_LONG_DESC in VARCHAR2,
13   X_SALES_REP_SHORT_DESC in VARCHAR2,
14   X_SALES_REP_LONG_DESC in VARCHAR2,
15   X_SALES_CHANNEL_SHORT_DESC in VARCHAR2,
16   X_SALES_CHANNEL_LONG_DESC in VARCHAR2,
17   X_FREIGHT_TERMS_SHORT_DESC in VARCHAR2,
18   X_FREIGHT_TERMS_LONG_DESC in VARCHAR2,
19   X_PAYMENT_TERMS_SHORT_DESC in VARCHAR2,
20   X_PAYMENT_TERMS_LONG_DESC in VARCHAR2,
21   X_COMMENTS in VARCHAR2,
22   X_MEASURE1_NUMBER in NUMBER,
23   X_MEASURE2_NUMBER in NUMBER,
24   X_MEASURE3_NUMBER in NUMBER,
25   X_MEASURE4_NUMBER in NUMBER,
26   X_MEASURE5_NUMBER in NUMBER,
27   X_MEASURE6_NUMBER in NUMBER,
28   X_MEASURE7_NUMBER in NUMBER,
29   X_MEASURE8_NUMBER in NUMBER,
30   X_MEASURE9_NUMBER in NUMBER,
31   X_MEASURE10_NUMBER in NUMBER,
32   X_MEASURE1_CHAR in VARCHAR2,
33   X_MEASURE2_CHAR in VARCHAR2,
34   X_MEASURE3_CHAR in VARCHAR2,
35   X_MEASURE4_CHAR in VARCHAR2,
36   X_MEASURE5_CHAR in VARCHAR2,
37   X_MEASURE6_CHAR in VARCHAR2,
38   X_MEASURE7_CHAR in VARCHAR2,
39   X_MEASURE8_CHAR in VARCHAR2,
40   X_MEASURE9_CHAR in VARCHAR2,
41   X_MEASURE10_CHAR in VARCHAR2,
42 --  X_PROGRAM_LOGIN_ID in NUMBER,
43 --  X_REQUEST_ID in NUMBER,
44   X_INSTANCE_ID in NUMBER,
45   X_SIMULATION_FLAG in VARCHAR2,
46   X_CUSTOMER_SK in VARCHAR2,
47   X_SALES_CHANNEL_SK in VARCHAR2,
48   X_SALES_REP_SK in VARCHAR2,
49   X_PN_INT_HEADER_ID in NUMBER,
50   X_SOURCE_ID in NUMBER,
51   X_SOURCE_REF_HDR_ID in NUMBER,
52   X_CUSTOMER_ID in NUMBER,
53 --  X_CONTRACT_ID in NUMBER,
54   X_SALES_REP_ID in NUMBER,
55   X_PAYMENT_TERMS_ID in NUMBER,
56   X_INVOICE_TO_PARTY_SITE_ID in NUMBER,
57   X_SALES_REP_EMAIL in VARCHAR2,
58   X_SALES_CHANNEL_CODE in VARCHAR2,
59   X_DEAL_EXPIRY_DATE in DATE,
60   X_DEAL_CREATION_DATE in DATE,
61   X_INVOICE_TO_PARTY_SITE_ADDRES in VARCHAR2,
62 --  X_PRIORITY in VARCHAR2,
63   X_CURRENCY_SHORT_DESC in VARCHAR2,
64   X_CURRENCY_LONG_DESC in VARCHAR2,
65   X_SOURCE_SHORT_DESC in VARCHAR2,
66   X_SOURCE_LONG_DESC in VARCHAR2,
67   X_SOURCE_REF_HDR_SHORT_DESC in VARCHAR2,
68   X_REFERENCE_NAME in VARCHAR2,
69   X_CREATION_DATE in DATE,
70   X_CREATED_BY in NUMBER,
71   X_LAST_UPDATE_DATE in DATE,
72   X_LAST_UPDATED_BY in NUMBER,
73   X_LAST_UPDATE_LOGIN in NUMBER);
74 procedure LOCK_ROW (
75   X_REQUEST_HEADER_ID in NUMBER,
76   X_SOURCE_REF_HDR_LONG_DESC in VARCHAR2,
77 --  X_ORG_SHORT_DESC in VARCHAR2,
78 --  X_ORG_LONG_DESC in VARCHAR2,
79   X_CUSTOMER_SHORT_DESC in VARCHAR2,
80   X_CUSTOMER_LONG_DESC in VARCHAR2,
81  -- X_CONTRACT_SHORT_DESC in VARCHAR2,
82   --X_CONTRACT_LONG_DESC in VARCHAR2,
83   X_SALES_REP_SHORT_DESC in VARCHAR2,
84   X_SALES_REP_LONG_DESC in VARCHAR2,
85   X_SALES_CHANNEL_SHORT_DESC in VARCHAR2,
86   X_SALES_CHANNEL_LONG_DESC in VARCHAR2,
87   X_FREIGHT_TERMS_SHORT_DESC in VARCHAR2,
88   X_FREIGHT_TERMS_LONG_DESC in VARCHAR2,
89   X_PAYMENT_TERMS_SHORT_DESC in VARCHAR2,
90   X_PAYMENT_TERMS_LONG_DESC in VARCHAR2,
91   X_COMMENTS in VARCHAR2,
92   X_MEASURE1_NUMBER in NUMBER,
93   X_MEASURE2_NUMBER in NUMBER,
94   X_MEASURE3_NUMBER in NUMBER,
95   X_MEASURE4_NUMBER in NUMBER,
96   X_MEASURE5_NUMBER in NUMBER,
97   X_MEASURE6_NUMBER in NUMBER,
98   X_MEASURE7_NUMBER in NUMBER,
99   X_MEASURE8_NUMBER in NUMBER,
100   X_MEASURE9_NUMBER in NUMBER,
101   X_MEASURE10_NUMBER in NUMBER,
102   X_MEASURE1_CHAR in VARCHAR2,
103   X_MEASURE2_CHAR in VARCHAR2,
104   X_MEASURE3_CHAR in VARCHAR2,
105   X_MEASURE4_CHAR in VARCHAR2,
106   X_MEASURE5_CHAR in VARCHAR2,
107   X_MEASURE6_CHAR in VARCHAR2,
108   X_MEASURE7_CHAR in VARCHAR2,
109   X_MEASURE8_CHAR in VARCHAR2,
110   X_MEASURE9_CHAR in VARCHAR2,
111   X_MEASURE10_CHAR in VARCHAR2,
112 --  X_PROGRAM_LOGIN_ID in NUMBER,
113 --  X_REQUEST_ID in NUMBER,
114   X_INSTANCE_ID in NUMBER,
115   X_SIMULATION_FLAG in VARCHAR2,
116   X_CUSTOMER_SK in VARCHAR2,
117   X_SALES_CHANNEL_SK in VARCHAR2,
118   X_SALES_REP_SK in VARCHAR2,
119   X_PN_INT_HEADER_ID in NUMBER,
120   X_SOURCE_ID in NUMBER,
121   X_SOURCE_REF_HDR_ID in NUMBER,
122   X_CUSTOMER_ID in NUMBER,
123 --  X_CONTRACT_ID in NUMBER,
124   X_SALES_REP_ID in NUMBER,
125   X_PAYMENT_TERMS_ID in NUMBER,
126   X_INVOICE_TO_PARTY_SITE_ID in NUMBER,
127   X_SALES_REP_EMAIL in VARCHAR2,
128   X_SALES_CHANNEL_CODE in VARCHAR2,
129   X_DEAL_EXPIRY_DATE in DATE,
130   X_DEAL_CREATION_DATE in DATE,
131   X_INVOICE_TO_PARTY_SITE_ADDRES in VARCHAR2,
132 --  X_PRIORITY in VARCHAR2,
133   X_CURRENCY_SHORT_DESC in VARCHAR2,
134   X_CURRENCY_LONG_DESC in VARCHAR2,
135   X_SOURCE_SHORT_DESC in VARCHAR2,
136   X_SOURCE_LONG_DESC in VARCHAR2,
137   X_SOURCE_REF_HDR_SHORT_DESC in VARCHAR2,
138   X_REFERENCE_NAME in VARCHAR2
139 );
140 procedure UPDATE_ROW (
141   X_REQUEST_HEADER_ID in NUMBER,
142   X_SOURCE_REF_HDR_LONG_DESC in VARCHAR2,
143 --  X_ORG_SHORT_DESC in VARCHAR2,
144 --  X_ORG_LONG_DESC in VARCHAR2,
145   X_CUSTOMER_SHORT_DESC in VARCHAR2,
146   X_CUSTOMER_LONG_DESC in VARCHAR2,
147 --  X_CONTRACT_SHORT_DESC in VARCHAR2,
148 --  X_CONTRACT_LONG_DESC in VARCHAR2,
149   X_SALES_REP_SHORT_DESC in VARCHAR2,
150   X_SALES_REP_LONG_DESC in VARCHAR2,
151   X_SALES_CHANNEL_SHORT_DESC in VARCHAR2,
152   X_SALES_CHANNEL_LONG_DESC in VARCHAR2,
153   X_FREIGHT_TERMS_SHORT_DESC in VARCHAR2,
154   X_FREIGHT_TERMS_LONG_DESC in VARCHAR2,
155   X_PAYMENT_TERMS_SHORT_DESC in VARCHAR2,
156   X_PAYMENT_TERMS_LONG_DESC in VARCHAR2,
157   X_COMMENTS in VARCHAR2,
158   X_MEASURE1_NUMBER in NUMBER,
159   X_MEASURE2_NUMBER in NUMBER,
160   X_MEASURE3_NUMBER in NUMBER,
161   X_MEASURE4_NUMBER in NUMBER,
162   X_MEASURE5_NUMBER in NUMBER,
163   X_MEASURE6_NUMBER in NUMBER,
164   X_MEASURE7_NUMBER in NUMBER,
165   X_MEASURE8_NUMBER in NUMBER,
166   X_MEASURE9_NUMBER in NUMBER,
167   X_MEASURE10_NUMBER in NUMBER,
168   X_MEASURE1_CHAR in VARCHAR2,
169   X_MEASURE2_CHAR in VARCHAR2,
170   X_MEASURE3_CHAR in VARCHAR2,
171   X_MEASURE4_CHAR in VARCHAR2,
172   X_MEASURE5_CHAR in VARCHAR2,
173   X_MEASURE6_CHAR in VARCHAR2,
174   X_MEASURE7_CHAR in VARCHAR2,
175   X_MEASURE8_CHAR in VARCHAR2,
176   X_MEASURE9_CHAR in VARCHAR2,
177   X_MEASURE10_CHAR in VARCHAR2,
178 --  X_PROGRAM_LOGIN_ID in NUMBER,
179 --  X_REQUEST_ID in NUMBER,
180   X_INSTANCE_ID in NUMBER,
181   X_SIMULATION_FLAG in VARCHAR2,
182   X_CUSTOMER_SK in VARCHAR2,
183   X_SALES_CHANNEL_SK in VARCHAR2,
184   X_SALES_REP_SK in VARCHAR2,
185   X_PN_INT_HEADER_ID in NUMBER,
186   X_SOURCE_ID in NUMBER,
187   X_SOURCE_REF_HDR_ID in NUMBER,
188   X_CUSTOMER_ID in NUMBER,
189 --  X_CONTRACT_ID in NUMBER,
190   X_SALES_REP_ID in NUMBER,
191   X_PAYMENT_TERMS_ID in NUMBER,
192   X_INVOICE_TO_PARTY_SITE_ID in NUMBER,
193   X_SALES_REP_EMAIL in VARCHAR2,
194   X_SALES_CHANNEL_CODE in VARCHAR2,
195   X_DEAL_EXPIRY_DATE in DATE,
196   X_DEAL_CREATION_DATE in DATE,
197   X_INVOICE_TO_PARTY_SITE_ADDRES in VARCHAR2,
198 --  X_PRIORITY in VARCHAR2,
199   X_CURRENCY_SHORT_DESC in VARCHAR2,
200   X_CURRENCY_LONG_DESC in VARCHAR2,
201   X_SOURCE_SHORT_DESC in VARCHAR2,
202   X_SOURCE_LONG_DESC in VARCHAR2,
203   X_SOURCE_REF_HDR_SHORT_DESC in VARCHAR2,
204   X_REFERENCE_NAME in VARCHAR2,
205   X_LAST_UPDATE_DATE in DATE,
206   X_LAST_UPDATED_BY in NUMBER,
207   X_LAST_UPDATE_LOGIN in NUMBER
208 );
209 procedure DELETE_ROW (
210   X_REQUEST_HEADER_ID in NUMBER
211 );
212 procedure ADD_LANGUAGE;
213 end QPR_PN_REQUEST_HDRS_PKG;