DBA Data[Home] [Help]

APPS.ARP_RAXINV_MLS_PACKAGE dependencies on FND_REQUEST_INFO

Line 70: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Transaction Class',parm_number);

66: arp_standard.debug('P_USERENV_LANG = ' || p_userenv_lang);
67:
68: /* Read in Parameter Values supplied by user */
69:
70: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Transaction Class',parm_number);
71: if retval = -1 then
72: P_CUST_TRX_CLASS := NULL;
73: else
74: P_CUST_TRX_CLASS := FND_REQUEST_INFO.GET_PARAMETER(parm_number);

Line 74: P_CUST_TRX_CLASS := FND_REQUEST_INFO.GET_PARAMETER(parm_number);

70: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Transaction Class',parm_number);
71: if retval = -1 then
72: P_CUST_TRX_CLASS := NULL;
73: else
74: P_CUST_TRX_CLASS := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
75: end if;
76: arp_standard.debug('P_CUST_TRX_CLASS ='|| P_CUST_TRX_CLASS);
77:
78: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Transaction Type',parm_number);

Line 78: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Transaction Type',parm_number);

74: P_CUST_TRX_CLASS := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
75: end if;
76: arp_standard.debug('P_CUST_TRX_CLASS ='|| P_CUST_TRX_CLASS);
77:
78: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Transaction Type',parm_number);
79: if retval = -1 then
80: P_CUST_TRX_TYPE_ID := NULL;
81: else
82: P_CUST_TRX_TYPE_ID := FND_REQUEST_INFO.GET_PARAMETER(parm_number);

Line 82: P_CUST_TRX_TYPE_ID := FND_REQUEST_INFO.GET_PARAMETER(parm_number);

78: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Transaction Type',parm_number);
79: if retval = -1 then
80: P_CUST_TRX_TYPE_ID := NULL;
81: else
82: P_CUST_TRX_TYPE_ID := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
83: end if;
84: arp_standard.debug('P_CUST_TRX_TYPE_ID ='|| to_char(P_CUST_TRX_TYPE_ID));
85:
86: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Transaction Number Low',parm_number);

Line 86: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Transaction Number Low',parm_number);

82: P_CUST_TRX_TYPE_ID := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
83: end if;
84: arp_standard.debug('P_CUST_TRX_TYPE_ID ='|| to_char(P_CUST_TRX_TYPE_ID));
85:
86: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Transaction Number Low',parm_number);
87: if retval = -1 then
88: P_TRX_NUMBER_LOW := NULL;
89: else
90: P_TRX_NUMBER_LOW := FND_REQUEST_INFO.GET_PARAMETER(parm_number);

Line 90: P_TRX_NUMBER_LOW := FND_REQUEST_INFO.GET_PARAMETER(parm_number);

86: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Transaction Number Low',parm_number);
87: if retval = -1 then
88: P_TRX_NUMBER_LOW := NULL;
89: else
90: P_TRX_NUMBER_LOW := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
91: end if;
92: arp_standard.debug('P_TRX_NUMBER_LOW ='|| P_TRX_NUMBER_LOW);
93:
94: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Transaction Number High',parm_number);

Line 94: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Transaction Number High',parm_number);

90: P_TRX_NUMBER_LOW := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
91: end if;
92: arp_standard.debug('P_TRX_NUMBER_LOW ='|| P_TRX_NUMBER_LOW);
93:
94: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Transaction Number High',parm_number);
95: if retval = -1 then
96: P_TRX_NUMBER_HIGH := NULL;
97: else
98: P_TRX_NUMBER_HIGH := FND_REQUEST_INFO.GET_PARAMETER(parm_number);

Line 98: P_TRX_NUMBER_HIGH := FND_REQUEST_INFO.GET_PARAMETER(parm_number);

94: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Transaction Number High',parm_number);
95: if retval = -1 then
96: P_TRX_NUMBER_HIGH := NULL;
97: else
98: P_TRX_NUMBER_HIGH := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
99: end if;
100: arp_standard.debug('P_TRX_NUMBER_HIGH ='|| P_TRX_NUMBER_HIGH);
101:
102: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Print Date Low',parm_number);

Line 102: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Print Date Low',parm_number);

98: P_TRX_NUMBER_HIGH := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
99: end if;
100: arp_standard.debug('P_TRX_NUMBER_HIGH ='|| P_TRX_NUMBER_HIGH);
101:
102: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Print Date Low',parm_number);
103: if retval = -1 then
104: P_DATES_LOW := NULL;
105: else
106: P_DATES_LOW := fnd_date.canonical_to_date(FND_REQUEST_INFO.GET_PARAMETER(parm_number));

Line 106: P_DATES_LOW := fnd_date.canonical_to_date(FND_REQUEST_INFO.GET_PARAMETER(parm_number));

102: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Print Date Low',parm_number);
103: if retval = -1 then
104: P_DATES_LOW := NULL;
105: else
106: P_DATES_LOW := fnd_date.canonical_to_date(FND_REQUEST_INFO.GET_PARAMETER(parm_number));
107: end if;
108: arp_standard.debug('P_DATES_LOW ='|| to_char(P_DATES_LOW));
109:
110: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Print Date High',parm_number);

Line 110: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Print Date High',parm_number);

106: P_DATES_LOW := fnd_date.canonical_to_date(FND_REQUEST_INFO.GET_PARAMETER(parm_number));
107: end if;
108: arp_standard.debug('P_DATES_LOW ='|| to_char(P_DATES_LOW));
109:
110: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Print Date High',parm_number);
111: if retval = -1 then
112: P_DATES_HIGH := NULL;
113: else
114: P_DATES_HIGH := fnd_date.canonical_to_date(FND_REQUEST_INFO.GET_PARAMETER(parm_number));

Line 114: P_DATES_HIGH := fnd_date.canonical_to_date(FND_REQUEST_INFO.GET_PARAMETER(parm_number));

110: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Print Date High',parm_number);
111: if retval = -1 then
112: P_DATES_HIGH := NULL;
113: else
114: P_DATES_HIGH := fnd_date.canonical_to_date(FND_REQUEST_INFO.GET_PARAMETER(parm_number));
115: end if;
116: arp_standard.debug('P_DATES_HIGH ='|| to_char(P_DATES_HIGH));
117:
118: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Customer Class',parm_number);

Line 118: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Customer Class',parm_number);

114: P_DATES_HIGH := fnd_date.canonical_to_date(FND_REQUEST_INFO.GET_PARAMETER(parm_number));
115: end if;
116: arp_standard.debug('P_DATES_HIGH ='|| to_char(P_DATES_HIGH));
117:
118: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Customer Class',parm_number);
119: if retval = -1 then
120: P_CUSTOMER_CLASS_CODE := NULL;
121: else
122: P_CUSTOMER_CLASS_CODE := FND_REQUEST_INFO.GET_PARAMETER(parm_number);

Line 122: P_CUSTOMER_CLASS_CODE := FND_REQUEST_INFO.GET_PARAMETER(parm_number);

118: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Customer Class',parm_number);
119: if retval = -1 then
120: P_CUSTOMER_CLASS_CODE := NULL;
121: else
122: P_CUSTOMER_CLASS_CODE := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
123: end if;
124: arp_standard.debug('P_CUSTOMER_CLASS_CODE ='|| P_CUSTOMER_CLASS_CODE);
125:
126: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Customer',parm_number);

Line 126: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Customer',parm_number);

122: P_CUSTOMER_CLASS_CODE := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
123: end if;
124: arp_standard.debug('P_CUSTOMER_CLASS_CODE ='|| P_CUSTOMER_CLASS_CODE);
125:
126: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Customer',parm_number);
127: if retval = -1 then
128: P_CUSTOMER_ID := NULL;
129: else
130: P_CUSTOMER_ID := FND_REQUEST_INFO.GET_PARAMETER(parm_number);

Line 130: P_CUSTOMER_ID := FND_REQUEST_INFO.GET_PARAMETER(parm_number);

126: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Customer',parm_number);
127: if retval = -1 then
128: P_CUSTOMER_ID := NULL;
129: else
130: P_CUSTOMER_ID := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
131: end if;
132: arp_standard.debug('P_CUSTOMER_ID ='|| to_char(P_CUSTOMER_ID));
133:
134: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Installment Number',parm_number);

Line 134: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Installment Number',parm_number);

130: P_CUSTOMER_ID := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
131: end if;
132: arp_standard.debug('P_CUSTOMER_ID ='|| to_char(P_CUSTOMER_ID));
133:
134: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Installment Number',parm_number);
135: if retval = -1 then
136: P_INSTALLMENT_NUMBER := NULL;
137: else
138: P_INSTALLMENT_NUMBER := FND_REQUEST_INFO.GET_PARAMETER(parm_number);

Line 138: P_INSTALLMENT_NUMBER := FND_REQUEST_INFO.GET_PARAMETER(parm_number);

134: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Installment Number',parm_number);
135: if retval = -1 then
136: P_INSTALLMENT_NUMBER := NULL;
137: else
138: P_INSTALLMENT_NUMBER := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
139: end if;
140: arp_standard.debug('P_INSTALLMENT_NUMBER ='|| to_char(P_INSTALLMENT_NUMBER));
141:
142: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Open Invoices Only',parm_number);

Line 142: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Open Invoices Only',parm_number);

138: P_INSTALLMENT_NUMBER := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
139: end if;
140: arp_standard.debug('P_INSTALLMENT_NUMBER ='|| to_char(P_INSTALLMENT_NUMBER));
141:
142: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Open Invoices Only',parm_number);
143: if retval = -1 then
144: P_OPEN_INVOICE := NULL;
145: else
146: P_OPEN_INVOICE := FND_REQUEST_INFO.GET_PARAMETER(parm_number);

Line 146: P_OPEN_INVOICE := FND_REQUEST_INFO.GET_PARAMETER(parm_number);

142: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Open Invoices Only',parm_number);
143: if retval = -1 then
144: P_OPEN_INVOICE := NULL;
145: else
146: P_OPEN_INVOICE := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
147: end if;
148: arp_standard.debug('P_OPEN_INVOICE ='|| P_OPEN_INVOICE);
149:
150: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Print Choice',parm_number);

Line 150: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Print Choice',parm_number);

146: P_OPEN_INVOICE := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
147: end if;
148: arp_standard.debug('P_OPEN_INVOICE ='|| P_OPEN_INVOICE);
149:
150: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Print Choice',parm_number);
151: if retval = -1 then
152: P_CHOICE := NULL;
153: else
154: P_CHOICE := FND_REQUEST_INFO.GET_PARAMETER(parm_number);

Line 154: P_CHOICE := FND_REQUEST_INFO.GET_PARAMETER(parm_number);

150: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Print Choice',parm_number);
151: if retval = -1 then
152: P_CHOICE := NULL;
153: else
154: P_CHOICE := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
155: end if;
156: arp_standard.debug('P_CHOICE ='|| P_CHOICE);
157:
158: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Adjustment Number Low',parm_number);

Line 158: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Adjustment Number Low',parm_number);

154: P_CHOICE := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
155: end if;
156: arp_standard.debug('P_CHOICE ='|| P_CHOICE);
157:
158: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Adjustment Number Low',parm_number);
159: if retval = -1 then
160: P_ADJ_NUMBER_LOW := NULL;
161: else
162: P_ADJ_NUMBER_LOW := FND_REQUEST_INFO.GET_PARAMETER(parm_number);

Line 162: P_ADJ_NUMBER_LOW := FND_REQUEST_INFO.GET_PARAMETER(parm_number);

158: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Adjustment Number Low',parm_number);
159: if retval = -1 then
160: P_ADJ_NUMBER_LOW := NULL;
161: else
162: P_ADJ_NUMBER_LOW := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
163: end if;
164: arp_standard.debug('P_ADJ_NUMBER_LOW ='|| P_ADJ_NUMBER_LOW);
165:
166: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Adjustment Number High',parm_number);

Line 166: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Adjustment Number High',parm_number);

162: P_ADJ_NUMBER_LOW := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
163: end if;
164: arp_standard.debug('P_ADJ_NUMBER_LOW ='|| P_ADJ_NUMBER_LOW);
165:
166: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Adjustment Number High',parm_number);
167: if retval = -1 then
168: P_ADJ_NUMBER_HIGH := NULL;
169: else
170: P_ADJ_NUMBER_HIGH := FND_REQUEST_INFO.GET_PARAMETER(parm_number);

Line 170: P_ADJ_NUMBER_HIGH := FND_REQUEST_INFO.GET_PARAMETER(parm_number);

166: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Adjustment Number High',parm_number);
167: if retval = -1 then
168: P_ADJ_NUMBER_HIGH := NULL;
169: else
170: P_ADJ_NUMBER_HIGH := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
171: end if;
172: arp_standard.debug('P_ADJ_NUMBER_HIGH ='|| P_ADJ_NUMBER_HIGH);
173:
174: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Adjustment Date Low',parm_number);

Line 174: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Adjustment Date Low',parm_number);

170: P_ADJ_NUMBER_HIGH := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
171: end if;
172: arp_standard.debug('P_ADJ_NUMBER_HIGH ='|| P_ADJ_NUMBER_HIGH);
173:
174: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Adjustment Date Low',parm_number);
175: if retval = -1 then
176: P_ADJ_DATES_LOW := NULL;
177: else
178: P_ADJ_DATES_LOW := fnd_date.canonical_to_date(FND_REQUEST_INFO.GET_PARAMETER(parm_number));

Line 178: P_ADJ_DATES_LOW := fnd_date.canonical_to_date(FND_REQUEST_INFO.GET_PARAMETER(parm_number));

174: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Adjustment Date Low',parm_number);
175: if retval = -1 then
176: P_ADJ_DATES_LOW := NULL;
177: else
178: P_ADJ_DATES_LOW := fnd_date.canonical_to_date(FND_REQUEST_INFO.GET_PARAMETER(parm_number));
179: end if;
180: arp_standard.debug('P_ADJ_DATES_LOW ='|| to_char(P_ADJ_DATES_LOW));
181:
182: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Adjustment Date High',parm_number);

Line 182: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Adjustment Date High',parm_number);

178: P_ADJ_DATES_LOW := fnd_date.canonical_to_date(FND_REQUEST_INFO.GET_PARAMETER(parm_number));
179: end if;
180: arp_standard.debug('P_ADJ_DATES_LOW ='|| to_char(P_ADJ_DATES_LOW));
181:
182: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Adjustment Date High',parm_number);
183: if retval = -1 then
184: P_ADJ_DATES_HIGH := NULL;
185: else
186: P_ADJ_DATES_HIGH := fnd_date.canonical_to_date(FND_REQUEST_INFO.GET_PARAMETER(parm_number));

Line 186: P_ADJ_DATES_HIGH := fnd_date.canonical_to_date(FND_REQUEST_INFO.GET_PARAMETER(parm_number));

182: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Adjustment Date High',parm_number);
183: if retval = -1 then
184: P_ADJ_DATES_HIGH := NULL;
185: else
186: P_ADJ_DATES_HIGH := fnd_date.canonical_to_date(FND_REQUEST_INFO.GET_PARAMETER(parm_number));
187: end if;
188: arp_standard.debug('P_ADJ_DATES_HIGH ='|| to_char(P_ADJ_DATES_HIGH));
189:
190: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Batch',parm_number);

Line 190: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Batch',parm_number);

186: P_ADJ_DATES_HIGH := fnd_date.canonical_to_date(FND_REQUEST_INFO.GET_PARAMETER(parm_number));
187: end if;
188: arp_standard.debug('P_ADJ_DATES_HIGH ='|| to_char(P_ADJ_DATES_HIGH));
189:
190: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Batch',parm_number);
191: if retval = -1 then
192: P_BATCH_ID := NULL;
193: else
194: P_BATCH_ID := FND_REQUEST_INFO.GET_PARAMETER(parm_number);

Line 194: P_BATCH_ID := FND_REQUEST_INFO.GET_PARAMETER(parm_number);

190: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Batch',parm_number);
191: if retval = -1 then
192: P_BATCH_ID := NULL;
193: else
194: P_BATCH_ID := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
195: end if;
196: arp_standard.debug('P_BATCH_ID ='|| to_char(P_BATCH_ID));
197:
198: arp_standard.debug('P_CUSTOMER_TRX_ID = ' || to_char(P_CUSTOMER_TRX_ID));