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.

APPS.POS_SUPP_CLASSIFICATION_PKG dependencies on FND_GLOBAL

Line 43: 'APPROVED', 'A', fnd_global.user_id, sysdate,

39: )
40: values
41: ( POS_BUS_CLASS_ATTR_S.NEXTVAL , p_cert_num,
42: p_cert_agency, p_exp_date,
43: 'APPROVED', 'A', fnd_global.user_id, sysdate,
44: p_ext_attr_1, null, null, null,
45: null, null, fnd_global.user_id,
46: sysdate, fnd_global.login_id,
47: p_party_id, BUSINESS_CLASSIFICATION, p_lookup_code,sysdate,

Line 45: null, null, fnd_global.user_id,

41: ( POS_BUS_CLASS_ATTR_S.NEXTVAL , p_cert_num,
42: p_cert_agency, p_exp_date,
43: 'APPROVED', 'A', fnd_global.user_id, sysdate,
44: p_ext_attr_1, null, null, null,
45: null, null, fnd_global.user_id,
46: sysdate, fnd_global.login_id,
47: p_party_id, BUSINESS_CLASSIFICATION, p_lookup_code,sysdate,
48: p_vendor_id
49: );

Line 46: sysdate, fnd_global.login_id,

42: p_cert_agency, p_exp_date,
43: 'APPROVED', 'A', fnd_global.user_id, sysdate,
44: p_ext_attr_1, null, null, null,
45: null, null, fnd_global.user_id,
46: sysdate, fnd_global.login_id,
47: p_party_id, BUSINESS_CLASSIFICATION, p_lookup_code,sysdate,
48: p_vendor_id
49: );
50: ELSE

Line 66: fnd_global.user_id, sysdate,

62: )
63: values
64: (
65: pos_supplier_mapping_s.nextval, p_party_id, p_vendor_id,
66: fnd_global.user_id, sysdate,
67: fnd_global.user_id, sysdate, fnd_global.login_id
68: );
69: end if;
70:

Line 67: fnd_global.user_id, sysdate, fnd_global.login_id

63: values
64: (
65: pos_supplier_mapping_s.nextval, p_party_id, p_vendor_id,
66: fnd_global.user_id, sysdate,
67: fnd_global.user_id, sysdate, fnd_global.login_id
68: );
69: end if;
70:
71: select mapping_id

Line 91: p_exp_date, fnd_global.user_id, sysdate,

87: POS_BUS_CLASS_REQUEST_S.NEXTVAL, l_mapping_id ,
88: 'ADD', 'PENDING',
89: null, BUSINESS_CLASSIFICATION, p_lookup_code,
90: p_ext_attr_1, p_cert_num , p_cert_agency,
91: p_exp_date, fnd_global.user_id, sysdate,
92: fnd_global.user_id, sysdate, fnd_global.login_id
93: );
94:
95: END IF;

Line 92: fnd_global.user_id, sysdate, fnd_global.login_id

88: 'ADD', 'PENDING',
89: null, BUSINESS_CLASSIFICATION, p_lookup_code,
90: p_ext_attr_1, p_cert_num , p_cert_agency,
91: p_exp_date, fnd_global.user_id, sysdate,
92: fnd_global.user_id, sysdate, fnd_global.login_id
93: );
94:
95: END IF;
96:

Line 129: last_updated_by = fnd_global.user_id,

125: IF ( p_selected = 'N' ) then
126: if (p_classification_id is not null and p_classification_id > 0 ) then
127: update pos_bus_class_attr
128: set status='I', last_update_date = sysdate,
129: last_updated_by = fnd_global.user_id,
130: end_date_active = sysdate
131: where classification_id = p_classification_id;
132: /*
133: * Adding the condition to reject the pending request, if the 'Applicable Flag'

Line 139: last_updated_by = fnd_global.user_id,

135: **/
136: update pos_bus_class_reqs
137: set request_status = 'REJECTED',
138: last_update_date = sysdate,
139: last_updated_by = fnd_global.user_id,
140: last_update_login = fnd_global.login_id
141: where bus_class_request_id = p_request_id;
142:
143: else

Line 140: last_update_login = fnd_global.login_id

136: update pos_bus_class_reqs
137: set request_status = 'REJECTED',
138: last_update_date = sysdate,
139: last_updated_by = fnd_global.user_id,
140: last_update_login = fnd_global.login_id
141: where bus_class_request_id = p_request_id;
142:
143: else
144: update pos_bus_class_reqs

Line 147: last_updated_by = fnd_global.user_id,

143: else
144: update pos_bus_class_reqs
145: set request_status = 'REJECTED',
146: last_update_date = sysdate,
147: last_updated_by = fnd_global.user_id,
148: last_update_login = fnd_global.login_id
149: where bus_class_request_id = p_request_id;
150: end if;
151: return;

Line 148: last_update_login = fnd_global.login_id

144: update pos_bus_class_reqs
145: set request_status = 'REJECTED',
146: last_update_date = sysdate,
147: last_updated_by = fnd_global.user_id,
148: last_update_login = fnd_global.login_id
149: where bus_class_request_id = p_request_id;
150: end if;
151: return;
152: END IF;

Line 166: last_updated_by = fnd_global.user_id,

162: expiration_date = p_exp_date,
163: class_status = 'APPROVED',
164: status = 'A',
165: ext_attr_1= p_ext_attr_1,
166: last_updated_by = fnd_global.user_id,
167: last_update_date = sysdate,
168: last_update_login= fnd_global.login_id
169: where classification_id = p_classification_id;
170:

Line 168: last_update_login= fnd_global.login_id

164: status = 'A',
165: ext_attr_1= p_ext_attr_1,
166: last_updated_by = fnd_global.user_id,
167: last_update_date = sysdate,
168: last_update_login= fnd_global.login_id
169: where classification_id = p_classification_id;
170:
171: -- If a request exists, make it approved.
172: if (p_request_id is not null and p_request_id > 0) then

Line 176: last_updated_by = fnd_global.user_id,

172: if (p_request_id is not null and p_request_id > 0) then
173: update pos_bus_class_reqs
174: set request_status = 'APPROVED',
175: classification_id = l_class_id,
176: last_updated_by = fnd_global.user_id,
177: last_update_login = fnd_global.login_id,
178: last_update_date = sysdate
179: where bus_class_request_id = p_request_id;
180: end if;

Line 177: last_update_login = fnd_global.login_id,

173: update pos_bus_class_reqs
174: set request_status = 'APPROVED',
175: classification_id = l_class_id,
176: last_updated_by = fnd_global.user_id,
177: last_update_login = fnd_global.login_id,
178: last_update_date = sysdate
179: where bus_class_request_id = p_request_id;
180: end if;
181: else

Line 201: 'APPROVED', 'A', fnd_global.user_id, sysdate,

197: )
198: values
199: ( l_class_id, p_cert_num,
200: p_cert_agency, p_exp_date,
201: 'APPROVED', 'A', fnd_global.user_id, sysdate,
202: p_ext_attr_1, null, null, null,
203: null, null, fnd_global.user_id,
204: sysdate, -1,
205: p_party_id, BUSINESS_CLASSIFICATION, p_lookup_code,sysdate

Line 203: null, null, fnd_global.user_id,

199: ( l_class_id, p_cert_num,
200: p_cert_agency, p_exp_date,
201: 'APPROVED', 'A', fnd_global.user_id, sysdate,
202: p_ext_attr_1, null, null, null,
203: null, null, fnd_global.user_id,
204: sysdate, -1,
205: p_party_id, BUSINESS_CLASSIFICATION, p_lookup_code,sysdate
206: , p_vendor_id
207: );

Line 212: last_updated_by = fnd_global.user_id,

208:
209: update pos_bus_class_reqs
210: set request_status = 'APPROVED',
211: classification_id = l_class_id,
212: last_updated_by = fnd_global.user_id,
213: last_update_login = fnd_global.login_id,
214: last_update_date = sysdate
215: where bus_class_request_id = p_request_id;
216: end if;

Line 213: last_update_login = fnd_global.login_id,

209: update pos_bus_class_reqs
210: set request_status = 'APPROVED',
211: classification_id = l_class_id,
212: last_updated_by = fnd_global.user_id,
213: last_update_login = fnd_global.login_id,
214: last_update_date = sysdate
215: where bus_class_request_id = p_request_id;
216: end if;
217: else

Line 225: last_updated_by = fnd_global.user_id,

221: /* Not needed.
222:
223: update pos_bus_class_attr
224: set status='I', last_update_date = sysdate,
225: last_updated_by = fnd_global.user_id,
226: last_update_login = fnd_global.login_id
227: where classification_id = p_classification_id;*/
228:
229: select count(mapping_id)

Line 226: last_update_login = fnd_global.login_id

222:
223: update pos_bus_class_attr
224: set status='I', last_update_date = sysdate,
225: last_updated_by = fnd_global.user_id,
226: last_update_login = fnd_global.login_id
227: where classification_id = p_classification_id;*/
228:
229: select count(mapping_id)
230: into l_count

Line 244: fnd_global.user_id, sysdate,

240: )
241: values
242: (
243: pos_supplier_mapping_s.nextval, p_party_id, p_vendor_id,
244: fnd_global.user_id, sysdate,
245: fnd_global.user_id, sysdate, fnd_global.login_id
246: );
247: end if;
248:

Line 245: fnd_global.user_id, sysdate, fnd_global.login_id

241: values
242: (
243: pos_supplier_mapping_s.nextval, p_party_id, p_vendor_id,
244: fnd_global.user_id, sysdate,
245: fnd_global.user_id, sysdate, fnd_global.login_id
246: );
247: end if;
248:
249: select mapping_id

Line 270: p_exp_date, fnd_global.user_id, sysdate,

266: POS_BUS_CLASS_REQUEST_S.NEXTVAL, l_mapping_id ,
267: 'ADD', 'PENDING',
268: p_classification_id, BUSINESS_CLASSIFICATION, p_lookup_code,
269: p_ext_attr_1, p_cert_num , p_cert_agency,
270: p_exp_date, fnd_global.user_id, sysdate,
271: fnd_global.user_id, sysdate, fnd_global.login_id
272: );
273: else
274: update pos_bus_class_reqs

Line 271: fnd_global.user_id, sysdate, fnd_global.login_id

267: 'ADD', 'PENDING',
268: p_classification_id, BUSINESS_CLASSIFICATION, p_lookup_code,
269: p_ext_attr_1, p_cert_num , p_cert_agency,
270: p_exp_date, fnd_global.user_id, sysdate,
271: fnd_global.user_id, sysdate, fnd_global.login_id
272: );
273: else
274: update pos_bus_class_reqs
275: set

Line 282: last_updated_by = fnd_global.user_id,

278: certification_no= p_cert_num,
279: certification_agency = p_cert_agency,
280: expiration_date = p_exp_date,
281: ext_attr_1= p_ext_attr_1,
282: last_updated_by = fnd_global.user_id,
283: last_update_date = sysdate,
284: last_update_login= fnd_global.login_id
285: where bus_class_request_id = p_request_id;
286: end if;

Line 284: last_update_login= fnd_global.login_id

280: expiration_date = p_exp_date,
281: ext_attr_1= p_ext_attr_1,
282: last_updated_by = fnd_global.user_id,
283: last_update_date = sysdate,
284: last_update_login= fnd_global.login_id
285: where bus_class_request_id = p_request_id;
286: end if;
287: end if;
288: --END IF;

Line 732: last_updated_by = fnd_global.user_id,

728: IS
729: BEGIN
730: update pos_bus_class_attr
731: set status='I', last_update_date = sysdate,
732: last_updated_by = fnd_global.user_id,
733: end_date_active = sysdate
734: where classification_id = pClassificationId;
735: END;
736: