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 276: p_exp_date, fnd_global.user_id, sysdate,

272: POS_BUS_CLASS_REQUEST_S.NEXTVAL, l_mapping_id ,
273: 'ADD', 'PENDING',
274: p_classification_id, BUSINESS_CLASSIFICATION, p_lookup_code,
275: p_ext_attr_1, p_cert_num , p_cert_agency,
276: p_exp_date, fnd_global.user_id, sysdate,
277: fnd_global.user_id, sysdate, fnd_global.login_id
278: );
279: else
280: update pos_bus_class_reqs

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

273: 'ADD', 'PENDING',
274: p_classification_id, BUSINESS_CLASSIFICATION, p_lookup_code,
275: p_ext_attr_1, p_cert_num , p_cert_agency,
276: p_exp_date, fnd_global.user_id, sysdate,
277: fnd_global.user_id, sysdate, fnd_global.login_id
278: );
279: else
280: update pos_bus_class_reqs
281: set

Line 288: last_updated_by = fnd_global.user_id,

284: certification_no= p_cert_num,
285: certification_agency = p_cert_agency,
286: expiration_date = p_exp_date,
287: ext_attr_1= p_ext_attr_1,
288: last_updated_by = fnd_global.user_id,
289: last_update_date = sysdate,
290: last_update_login= fnd_global.login_id
291: where bus_class_request_id = p_request_id;
292: end if;

Line 290: last_update_login= fnd_global.login_id

286: expiration_date = p_exp_date,
287: ext_attr_1= p_ext_attr_1,
288: last_updated_by = fnd_global.user_id,
289: last_update_date = sysdate,
290: last_update_login= fnd_global.login_id
291: where bus_class_request_id = p_request_id;
292: end if;
293: end if;
294: --END IF;

Line 751: last_updated_by = fnd_global.user_id,

747: IS
748: BEGIN
749: update pos_bus_class_attr
750: set status='I', last_update_date = sysdate,
751: last_updated_by = fnd_global.user_id,
752: end_date_active = sysdate
753: where classification_id = pClassificationId;
754: END;
755:

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

789: )
790: values
791: ( POS_BUS_CLASS_ATTR_S.NEXTVAL , p_cert_num,
792: p_cert_agency, p_exp_date,
793: 'APPROVED', 'A', fnd_global.user_id, sysdate,
794: p_ext_attr_1, null, null, null,
795: null, null, fnd_global.user_id,
796: sysdate, fnd_global.login_id,
797: p_party_id, BUSINESS_CLASSIFICATION, p_lookup_code,sysdate,

Line 795: null, null, fnd_global.user_id,

791: ( POS_BUS_CLASS_ATTR_S.NEXTVAL , p_cert_num,
792: p_cert_agency, p_exp_date,
793: 'APPROVED', 'A', fnd_global.user_id, sysdate,
794: p_ext_attr_1, null, null, null,
795: null, null, fnd_global.user_id,
796: sysdate, fnd_global.login_id,
797: p_party_id, BUSINESS_CLASSIFICATION, p_lookup_code,sysdate,
798: p_vendor_id, p_party_site_id
799: );

Line 796: sysdate, fnd_global.login_id,

792: p_cert_agency, p_exp_date,
793: 'APPROVED', 'A', fnd_global.user_id, sysdate,
794: p_ext_attr_1, null, null, null,
795: null, null, fnd_global.user_id,
796: sysdate, fnd_global.login_id,
797: p_party_id, BUSINESS_CLASSIFICATION, p_lookup_code,sysdate,
798: p_vendor_id, p_party_site_id
799: );
800:

Line 834: last_updated_by = fnd_global.user_id,

830:
831: if (p_classification_id is not null and p_classification_id > 0 ) then
832: update pos_bus_class_attr
833: set status='I', last_update_date = sysdate,
834: last_updated_by = fnd_global.user_id,
835: end_date_active = sysdate
836: where classification_id = p_classification_id;
837:
838: end if;

Line 854: last_updated_by = fnd_global.user_id,

850: expiration_date = p_exp_date,
851: class_status = 'APPROVED',
852: status = 'A',
853: ext_attr_1= p_ext_attr_1,
854: last_updated_by = fnd_global.user_id,
855: last_update_date = sysdate,
856: last_update_login= fnd_global.login_id
857: where classification_id = p_classification_id;
858:

Line 856: last_update_login= fnd_global.login_id

852: status = 'A',
853: ext_attr_1= p_ext_attr_1,
854: last_updated_by = fnd_global.user_id,
855: last_update_date = sysdate,
856: last_update_login= fnd_global.login_id
857: where classification_id = p_classification_id;
858:
859: else
860:

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

876: )
877: values
878: ( l_class_id, p_cert_num,
879: p_cert_agency, p_exp_date,
880: 'APPROVED', 'A', fnd_global.user_id, sysdate,
881: p_ext_attr_1, null, null, null,
882: null, null, fnd_global.user_id,
883: sysdate, -1,
884: p_party_id, BUSINESS_CLASSIFICATION, p_lookup_code,sysdate

Line 882: null, null, fnd_global.user_id,

878: ( l_class_id, p_cert_num,
879: p_cert_agency, p_exp_date,
880: 'APPROVED', 'A', fnd_global.user_id, sysdate,
881: p_ext_attr_1, null, null, null,
882: null, null, fnd_global.user_id,
883: sysdate, -1,
884: p_party_id, BUSINESS_CLASSIFICATION, p_lookup_code,sysdate
885: , p_vendor_id, p_party_site_id
886: );

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

941: values
942: (
943: POS_BUS_CLASS_ATTR_S.NEXTVAL , p_cert_num,
944: p_cert_agency, p_exp_date,
945: 'APPROVED', 'A', fnd_global.user_id, sysdate,
946: p_ext_attr_1, null, null, null,
947: null, null, fnd_global.user_id,
948: sysdate, fnd_global.login_id,
949: p_party_id, BUSINESS_CLASSIFICATION, p_lookup_code,sysdate,

Line 947: null, null, fnd_global.user_id,

943: POS_BUS_CLASS_ATTR_S.NEXTVAL , p_cert_num,
944: p_cert_agency, p_exp_date,
945: 'APPROVED', 'A', fnd_global.user_id, sysdate,
946: p_ext_attr_1, null, null, null,
947: null, null, fnd_global.user_id,
948: sysdate, fnd_global.login_id,
949: p_party_id, BUSINESS_CLASSIFICATION, p_lookup_code,sysdate,
950: p_vendor_id, p_party_site_id, p_vendor_site_id
951: );

Line 948: sysdate, fnd_global.login_id,

944: p_cert_agency, p_exp_date,
945: 'APPROVED', 'A', fnd_global.user_id, sysdate,
946: p_ext_attr_1, null, null, null,
947: null, null, fnd_global.user_id,
948: sysdate, fnd_global.login_id,
949: p_party_id, BUSINESS_CLASSIFICATION, p_lookup_code,sysdate,
950: p_vendor_id, p_party_site_id, p_vendor_site_id
951: );
952:

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

990: )
991: values
992: ( POS_BUS_CLASS_ATTR_S.NEXTVAL , p_cert_num,
993: p_cert_agency, p_exp_date,
994: 'APPROVED', 'A', fnd_global.user_id, sysdate,
995: p_ext_attr_1, null, null, null,
996: null, null, fnd_global.user_id,
997: sysdate, fnd_global.login_id,
998: p_party_id, BUSINESS_CLASSIFICATION, p_lookup_code,sysdate,

Line 996: null, null, fnd_global.user_id,

992: ( POS_BUS_CLASS_ATTR_S.NEXTVAL , p_cert_num,
993: p_cert_agency, p_exp_date,
994: 'APPROVED', 'A', fnd_global.user_id, sysdate,
995: p_ext_attr_1, null, null, null,
996: null, null, fnd_global.user_id,
997: sysdate, fnd_global.login_id,
998: p_party_id, BUSINESS_CLASSIFICATION, p_lookup_code,sysdate,
999: p_vendor_id, p_party_site_id, p_vendor_site_id
1000: );

Line 997: sysdate, fnd_global.login_id,

993: p_cert_agency, p_exp_date,
994: 'APPROVED', 'A', fnd_global.user_id, sysdate,
995: p_ext_attr_1, null, null, null,
996: null, null, fnd_global.user_id,
997: sysdate, fnd_global.login_id,
998: p_party_id, BUSINESS_CLASSIFICATION, p_lookup_code,sysdate,
999: p_vendor_id, p_party_site_id, p_vendor_site_id
1000: );
1001:

Line 1036: last_updated_by = fnd_global.user_id,

1032:
1033: if (p_classification_id is not null and p_classification_id > 0 ) then
1034: update pos_bus_class_attr
1035: set status='I', last_update_date = sysdate,
1036: last_updated_by = fnd_global.user_id,
1037: end_date_active = sysdate
1038: where classification_id = p_classification_id;
1039:
1040: end if;

Line 1056: last_updated_by = fnd_global.user_id,

1052: expiration_date = p_exp_date,
1053: class_status = 'APPROVED',
1054: status = 'A',
1055: ext_attr_1= p_ext_attr_1,
1056: last_updated_by = fnd_global.user_id,
1057: last_update_date = sysdate,
1058: last_update_login= fnd_global.login_id
1059: where classification_id = p_classification_id;
1060:

Line 1058: last_update_login= fnd_global.login_id

1054: status = 'A',
1055: ext_attr_1= p_ext_attr_1,
1056: last_updated_by = fnd_global.user_id,
1057: last_update_date = sysdate,
1058: last_update_login= fnd_global.login_id
1059: where classification_id = p_classification_id;
1060:
1061: else
1062:

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

1078: )
1079: values
1080: ( l_class_id, p_cert_num,
1081: p_cert_agency, p_exp_date,
1082: 'APPROVED', 'A', fnd_global.user_id, sysdate,
1083: p_ext_attr_1, null, null, null,
1084: null, null, fnd_global.user_id,
1085: sysdate, -1,
1086: p_party_id, BUSINESS_CLASSIFICATION, p_lookup_code,sysdate

Line 1084: null, null, fnd_global.user_id,

1080: ( l_class_id, p_cert_num,
1081: p_cert_agency, p_exp_date,
1082: 'APPROVED', 'A', fnd_global.user_id, sysdate,
1083: p_ext_attr_1, null, null, null,
1084: null, null, fnd_global.user_id,
1085: sysdate, -1,
1086: p_party_id, BUSINESS_CLASSIFICATION, p_lookup_code,sysdate
1087: , p_vendor_id, p_party_site_id, p_vendor_site_id
1088: );