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_PROFILE_CHANGE_REQUEST_PKG dependencies on FND_GLOBAL

Line 99: last_updated_by = fnd_global.user_id,

95: UPDATE pos_address_requests
96: SET party_site_id = l_party_site_id,
97: request_status = 'APPROVED',
98: last_update_date = Sysdate,
99: last_updated_by = fnd_global.user_id,
100: last_update_login = fnd_global.login_id
101: WHERE address_request_id = p_request_rec.address_request_id;
102:
103: UPDATE pos_cont_addr_requests

Line 100: last_update_login = fnd_global.login_id

96: SET party_site_id = l_party_site_id,
97: request_status = 'APPROVED',
98: last_update_date = Sysdate,
99: last_updated_by = fnd_global.user_id,
100: last_update_login = fnd_global.login_id
101: WHERE address_request_id = p_request_rec.address_request_id;
102:
103: UPDATE pos_cont_addr_requests
104: SET party_site_id = l_party_site_id,

Line 106: last_updated_by = fnd_global.user_id,

102:
103: UPDATE pos_cont_addr_requests
104: SET party_site_id = l_party_site_id,
105: last_update_date = Sysdate,
106: last_updated_by = fnd_global.user_id,
107: last_update_login = fnd_global.login_id
108: WHERE address_req_id = p_request_rec.address_request_id
109: AND request_status = 'PENDING'
110: AND party_site_id IS NULL;

Line 107: last_update_login = fnd_global.login_id

103: UPDATE pos_cont_addr_requests
104: SET party_site_id = l_party_site_id,
105: last_update_date = Sysdate,
106: last_updated_by = fnd_global.user_id,
107: last_update_login = fnd_global.login_id
108: WHERE address_req_id = p_request_rec.address_request_id
109: AND request_status = 'PENDING'
110: AND party_site_id IS NULL;
111:

Line 245: last_updated_by = fnd_global.user_id,

241:
242: UPDATE pos_address_requests
243: SET request_status = 'APPROVED',
244: last_update_date = Sysdate,
245: last_updated_by = fnd_global.user_id,
246: last_update_login = fnd_global.login_id
247: WHERE address_request_id = p_request_rec.address_request_id;
248:
249: EXCEPTION

Line 246: last_update_login = fnd_global.login_id

242: UPDATE pos_address_requests
243: SET request_status = 'APPROVED',
244: last_update_date = Sysdate,
245: last_updated_by = fnd_global.user_id,
246: last_update_login = fnd_global.login_id
247: WHERE address_request_id = p_request_rec.address_request_id;
248:
249: EXCEPTION
250: WHEN OTHERS THEN

Line 332: last_updated_by = fnd_global.user_id,

328:
329: UPDATE pos_cont_addr_requests
330: SET request_status = 'APPROVED',
331: last_update_date = Sysdate,
332: last_updated_by = fnd_global.user_id,
333: last_update_login = fnd_global.login_id
334: WHERE cont_addr_request_id IN
335: (SELECT pcar.cont_addr_request_id
336: FROM pos_cont_addr_requests pcar,

Line 333: last_update_login = fnd_global.login_id

329: UPDATE pos_cont_addr_requests
330: SET request_status = 'APPROVED',
331: last_update_date = Sysdate,
332: last_updated_by = fnd_global.user_id,
333: last_update_login = fnd_global.login_id
334: WHERE cont_addr_request_id IN
335: (SELECT pcar.cont_addr_request_id
336: FROM pos_cont_addr_requests pcar,
337: pos_contact_requests pcr,

Line 489: last_updated_by = fnd_global.user_id,

485: UPDATE pos_contact_requests
486: SET contact_party_id = l_person_party_id,
487: request_status = 'APPROVED',
488: last_update_date = Sysdate,
489: last_updated_by = fnd_global.user_id,
490: last_update_login = fnd_global.login_id
491: WHERE contact_request_id = p_request_rec.contact_request_id;
492:
493: UPDATE pos_cont_addr_requests

Line 490: last_update_login = fnd_global.login_id

486: SET contact_party_id = l_person_party_id,
487: request_status = 'APPROVED',
488: last_update_date = Sysdate,
489: last_updated_by = fnd_global.user_id,
490: last_update_login = fnd_global.login_id
491: WHERE contact_request_id = p_request_rec.contact_request_id;
492:
493: UPDATE pos_cont_addr_requests
494: SET contact_party_id = l_person_party_id,

Line 496: last_updated_by = fnd_global.user_id,

492:
493: UPDATE pos_cont_addr_requests
494: SET contact_party_id = l_person_party_id,
495: last_update_date = Sysdate,
496: last_updated_by = fnd_global.user_id,
497: last_update_login = fnd_global.login_id
498: WHERE contact_req_id = p_request_rec.contact_request_id
499: AND contact_party_id IS NULL
500: AND request_status = 'PENDING';

Line 497: last_update_login = fnd_global.login_id

493: UPDATE pos_cont_addr_requests
494: SET contact_party_id = l_person_party_id,
495: last_update_date = Sysdate,
496: last_updated_by = fnd_global.user_id,
497: last_update_login = fnd_global.login_id
498: WHERE contact_req_id = p_request_rec.contact_request_id
499: AND contact_party_id IS NULL
500: AND request_status = 'PENDING';
501:

Line 617: last_updated_by = fnd_global.user_id,

613:
614: UPDATE pos_contact_requests
615: SET request_status = 'APPROVED',
616: last_update_date = Sysdate,
617: last_updated_by = fnd_global.user_id,
618: last_update_login = fnd_global.login_id
619: WHERE contact_request_id = p_request_rec.contact_request_id;
620:
621: -- handle address contact association

Line 618: last_update_login = fnd_global.login_id

614: UPDATE pos_contact_requests
615: SET request_status = 'APPROVED',
616: last_update_date = Sysdate,
617: last_updated_by = fnd_global.user_id,
618: last_update_login = fnd_global.login_id
619: WHERE contact_request_id = p_request_rec.contact_request_id;
620:
621: -- handle address contact association
622: approve_cont_addr_requests

Line 709: , fnd_global.user_id

705: , p_request_rec.expiration_date
706: , p_request_rec.certification_no
707: , p_request_rec.certification_agency
708: , 'APPROVED'
709: , fnd_global.user_id
710: , Sysdate
711: , fnd_global.user_id
712: , Sysdate
713: , fnd_global.login_id

Line 711: , fnd_global.user_id

707: , p_request_rec.certification_agency
708: , 'APPROVED'
709: , fnd_global.user_id
710: , Sysdate
711: , fnd_global.user_id
712: , Sysdate
713: , fnd_global.login_id
714: , p_vendor_id
715: );

Line 713: , fnd_global.login_id

709: , fnd_global.user_id
710: , Sysdate
711: , fnd_global.user_id
712: , Sysdate
713: , fnd_global.login_id
714: , p_vendor_id
715: );
716:
717: UPDATE pos_bus_class_reqs

Line 720: last_updated_by = fnd_global.user_id,

716:
717: UPDATE pos_bus_class_reqs
718: SET request_status = 'APPROVED',
719: last_update_date = Sysdate,
720: last_updated_by = fnd_global.user_id,
721: last_update_login = fnd_global.login_id
722: WHERE bus_class_request_id = p_request_rec.bus_class_request_id;
723:
724: x_return_status := fnd_api.g_ret_sts_success;

Line 721: last_update_login = fnd_global.login_id

717: UPDATE pos_bus_class_reqs
718: SET request_status = 'APPROVED',
719: last_update_date = Sysdate,
720: last_updated_by = fnd_global.user_id,
721: last_update_login = fnd_global.login_id
722: WHERE bus_class_request_id = p_request_rec.bus_class_request_id;
723:
724: x_return_status := fnd_api.g_ret_sts_success;
725:

Line 776: , last_updated_by = fnd_global.user_id

772: SET ext_attr_1 = p_request_rec.ext_attr_1
773: , expiration_date = p_request_rec.expiration_date
774: , certificate_number = p_request_rec.certification_no
775: , certifying_agency = p_request_rec.certification_agency
776: , last_updated_by = fnd_global.user_id
777: , last_update_date = Sysdate
778: , last_update_login = fnd_global.login_id
779: WHERE classification_id = p_request_rec.classification_id;
780:

Line 778: , last_update_login = fnd_global.login_id

774: , certificate_number = p_request_rec.certification_no
775: , certifying_agency = p_request_rec.certification_agency
776: , last_updated_by = fnd_global.user_id
777: , last_update_date = Sysdate
778: , last_update_login = fnd_global.login_id
779: WHERE classification_id = p_request_rec.classification_id;
780:
781: UPDATE pos_bus_class_reqs
782: SET request_status = 'APPROVED',

Line 784: last_updated_by = fnd_global.user_id,

780:
781: UPDATE pos_bus_class_reqs
782: SET request_status = 'APPROVED',
783: last_update_date = Sysdate,
784: last_updated_by = fnd_global.user_id,
785: last_update_login = fnd_global.login_id
786: WHERE bus_class_request_id = p_request_rec.bus_class_request_id;
787:
788: x_return_status := fnd_api.g_ret_sts_success;

Line 785: last_update_login = fnd_global.login_id

781: UPDATE pos_bus_class_reqs
782: SET request_status = 'APPROVED',
783: last_update_date = Sysdate,
784: last_updated_by = fnd_global.user_id,
785: last_update_login = fnd_global.login_id
786: WHERE bus_class_request_id = p_request_rec.bus_class_request_id;
787:
788: x_return_status := fnd_api.g_ret_sts_success;
789: EXCEPTION

Line 886: last_updated_by = fnd_global.user_id,

882:
883: UPDATE pos_address_requests
884: SET request_status = 'APPROVED',
885: last_update_date = Sysdate,
886: last_updated_by = fnd_global.user_id,
887: last_update_login = fnd_global.login_id
888: WHERE address_request_id = p_request_id;
889:
890: ELSE

Line 887: last_update_login = fnd_global.login_id

883: UPDATE pos_address_requests
884: SET request_status = 'APPROVED',
885: last_update_date = Sysdate,
886: last_updated_by = fnd_global.user_id,
887: last_update_login = fnd_global.login_id
888: WHERE address_request_id = p_request_id;
889:
890: ELSE
891: x_return_status := fnd_api.g_ret_sts_error;

Line 1305: , fnd_global.user_id

1301: , l_rec.segment19
1302: , l_rec.segment20
1303: , 'A'
1304: , l_rec.segment_definition
1305: , fnd_global.user_id
1306: , Sysdate
1307: , fnd_global.user_id
1308: , Sysdate
1309: , fnd_global.login_id

Line 1307: , fnd_global.user_id

1303: , 'A'
1304: , l_rec.segment_definition
1305: , fnd_global.user_id
1306: , Sysdate
1307: , fnd_global.user_id
1308: , Sysdate
1309: , fnd_global.login_id
1310: );
1311:

Line 1309: , fnd_global.login_id

1305: , fnd_global.user_id
1306: , Sysdate
1307: , fnd_global.user_id
1308: , Sysdate
1309: , fnd_global.login_id
1310: );
1311:
1312: UPDATE pos_product_service_requests
1313: SET request_status = 'APPROVED',

Line 1315: last_updated_by = fnd_global.user_id,

1311:
1312: UPDATE pos_product_service_requests
1313: SET request_status = 'APPROVED',
1314: last_update_date = Sysdate,
1315: last_updated_by = fnd_global.user_id,
1316: last_update_login = fnd_global.login_id
1317: WHERE ps_request_id = p_request_id;
1318:
1319: x_return_status := fnd_api.g_ret_sts_success;

Line 1316: last_update_login = fnd_global.login_id

1312: UPDATE pos_product_service_requests
1313: SET request_status = 'APPROVED',
1314: last_update_date = Sysdate,
1315: last_updated_by = fnd_global.user_id,
1316: last_update_login = fnd_global.login_id
1317: WHERE ps_request_id = p_request_id;
1318:
1319: x_return_status := fnd_api.g_ret_sts_success;
1320:

Line 1370: last_updated_by = fnd_global.user_id,

1366:
1367: UPDATE pos_address_requests
1368: SET request_status = 'REJECTED',
1369: last_update_date = Sysdate,
1370: last_updated_by = fnd_global.user_id,
1371: last_update_login = fnd_global.login_id
1372: WHERE address_request_id = p_request_id;
1373:
1374: UPDATE pos_cont_addr_requests

Line 1371: last_update_login = fnd_global.login_id

1367: UPDATE pos_address_requests
1368: SET request_status = 'REJECTED',
1369: last_update_date = Sysdate,
1370: last_updated_by = fnd_global.user_id,
1371: last_update_login = fnd_global.login_id
1372: WHERE address_request_id = p_request_id;
1373:
1374: UPDATE pos_cont_addr_requests
1375: SET request_status = 'REJECTED',

Line 1377: last_updated_by = fnd_global.user_id,

1373:
1374: UPDATE pos_cont_addr_requests
1375: SET request_status = 'REJECTED',
1376: last_update_date = Sysdate,
1377: last_updated_by = fnd_global.user_id,
1378: last_update_login = fnd_global.login_id
1379: WHERE address_req_id = p_request_id;
1380:
1381: x_return_status := fnd_api.g_ret_sts_success;

Line 1378: last_update_login = fnd_global.login_id

1374: UPDATE pos_cont_addr_requests
1375: SET request_status = 'REJECTED',
1376: last_update_date = Sysdate,
1377: last_updated_by = fnd_global.user_id,
1378: last_update_login = fnd_global.login_id
1379: WHERE address_req_id = p_request_id;
1380:
1381: x_return_status := fnd_api.g_ret_sts_success;
1382:

Line 1426: last_updated_by = fnd_global.user_id,

1422: -- Bug # 5192274, the address requests should also be rejected
1423: update pos_cont_addr_requests
1424: set request_status = 'REJECTED',
1425: last_update_date = sysdate,
1426: last_updated_by = fnd_global.user_id,
1427: last_update_login = fnd_global.login_id
1428: where contact_req_id = p_request_id;
1429:
1430: UPDATE pos_contact_requests

Line 1427: last_update_login = fnd_global.login_id

1423: update pos_cont_addr_requests
1424: set request_status = 'REJECTED',
1425: last_update_date = sysdate,
1426: last_updated_by = fnd_global.user_id,
1427: last_update_login = fnd_global.login_id
1428: where contact_req_id = p_request_id;
1429:
1430: UPDATE pos_contact_requests
1431: SET request_status = 'REJECTED',

Line 1433: last_updated_by = fnd_global.user_id,

1429:
1430: UPDATE pos_contact_requests
1431: SET request_status = 'REJECTED',
1432: last_update_date = Sysdate,
1433: last_updated_by = fnd_global.user_id,
1434: last_update_login = fnd_global.login_id
1435: WHERE contact_request_id = p_request_id;
1436:
1437: x_return_status := fnd_api.g_ret_sts_success;

Line 1434: last_update_login = fnd_global.login_id

1430: UPDATE pos_contact_requests
1431: SET request_status = 'REJECTED',
1432: last_update_date = Sysdate,
1433: last_updated_by = fnd_global.user_id,
1434: last_update_login = fnd_global.login_id
1435: WHERE contact_request_id = p_request_id;
1436:
1437: x_return_status := fnd_api.g_ret_sts_success;
1438: EXCEPTION

Line 1481: last_updated_by = fnd_global.user_id,

1477:
1478: UPDATE pos_bus_class_reqs
1479: SET request_status = 'REJECTED',
1480: last_update_date = Sysdate,
1481: last_updated_by = fnd_global.user_id,
1482: last_update_login = fnd_global.login_id
1483: WHERE bus_class_request_id = p_request_id;
1484:
1485: x_return_status := fnd_api.g_ret_sts_success;

Line 1482: last_update_login = fnd_global.login_id

1478: UPDATE pos_bus_class_reqs
1479: SET request_status = 'REJECTED',
1480: last_update_date = Sysdate,
1481: last_updated_by = fnd_global.user_id,
1482: last_update_login = fnd_global.login_id
1483: WHERE bus_class_request_id = p_request_id;
1484:
1485: x_return_status := fnd_api.g_ret_sts_success;
1486: EXCEPTION

Line 1527: last_updated_by = fnd_global.user_id,

1523:
1524: UPDATE pos_product_service_requests
1525: SET request_status = 'REJECTED',
1526: last_update_date = Sysdate,
1527: last_updated_by = fnd_global.user_id,
1528: last_update_login = fnd_global.login_id
1529: WHERE ps_request_id = p_request_id;
1530:
1531: x_return_status := fnd_api.g_ret_sts_success;

Line 1528: last_update_login = fnd_global.login_id

1524: UPDATE pos_product_service_requests
1525: SET request_status = 'REJECTED',
1526: last_update_date = Sysdate,
1527: last_updated_by = fnd_global.user_id,
1528: last_update_login = fnd_global.login_id
1529: WHERE ps_request_id = p_request_id;
1530:
1531: x_return_status := fnd_api.g_ret_sts_success;
1532:

Line 2267: last_updated_by = fnd_global.user_id,

2263: RFQ_FLAG = p_rfq_flag,
2264: PAY_FLAG = p_pay_flag,
2265: PUR_FLAG = p_pur_flag,
2266: last_update_date = Sysdate,
2267: last_updated_by = fnd_global.user_id,
2268: last_update_login = fnd_global.login_id
2269: WHERE ADDRESS_REQUEST_ID = p_request_id;
2270:
2271: l_step := 2;

Line 2268: last_update_login = fnd_global.login_id

2264: PAY_FLAG = p_pay_flag,
2265: PUR_FLAG = p_pur_flag,
2266: last_update_date = Sysdate,
2267: last_updated_by = fnd_global.user_id,
2268: last_update_login = fnd_global.login_id
2269: WHERE ADDRESS_REQUEST_ID = p_request_id;
2270:
2271: l_step := 2;
2272:

Line 2423: last_updated_by = fnd_global.user_id,

2419: PHONE_EXTENSION = p_phone_extension,
2420: FAX_AREA_CODE = p_fax_area_code,
2421: FAX_NUMBER = p_fax_number,
2422: last_update_date = Sysdate,
2423: last_updated_by = fnd_global.user_id,
2424: last_update_login = fnd_global.login_id
2425: WHERE CONTACT_REQUEST_ID = p_request_id;
2426:
2427: approve_contact_req

Line 2424: last_update_login = fnd_global.login_id

2420: FAX_AREA_CODE = p_fax_area_code,
2421: FAX_NUMBER = p_fax_number,
2422: last_update_date = Sysdate,
2423: last_updated_by = fnd_global.user_id,
2424: last_update_login = fnd_global.login_id
2425: WHERE CONTACT_REQUEST_ID = p_request_id;
2426:
2427: approve_contact_req
2428: (p_request_id => p_request_id,

Line 2705: last_updated_by = fnd_global.user_id,

2701: UPDATE pos_address_requests
2702: SET request_status = p_req_status,
2703: PARTY_SITE_ID = p_party_site_id,
2704: last_update_date = Sysdate,
2705: last_updated_by = fnd_global.user_id,
2706: last_update_login = fnd_global.login_id
2707: WHERE address_request_id = p_request_id;
2708:
2709: UPDATE pos_cont_addr_requests

Line 2706: last_update_login = fnd_global.login_id

2702: SET request_status = p_req_status,
2703: PARTY_SITE_ID = p_party_site_id,
2704: last_update_date = Sysdate,
2705: last_updated_by = fnd_global.user_id,
2706: last_update_login = fnd_global.login_id
2707: WHERE address_request_id = p_request_id;
2708:
2709: UPDATE pos_cont_addr_requests
2710: SET party_site_id = p_party_site_id,

Line 2712: last_updated_by = fnd_global.user_id,

2708:
2709: UPDATE pos_cont_addr_requests
2710: SET party_site_id = p_party_site_id,
2711: last_update_date = Sysdate,
2712: last_updated_by = fnd_global.user_id,
2713: last_update_login = fnd_global.login_id
2714: WHERE address_req_id = p_request_id
2715: AND request_status = 'PENDING'
2716: AND party_site_id IS NULL;

Line 2713: last_update_login = fnd_global.login_id

2709: UPDATE pos_cont_addr_requests
2710: SET party_site_id = p_party_site_id,
2711: last_update_date = Sysdate,
2712: last_updated_by = fnd_global.user_id,
2713: last_update_login = fnd_global.login_id
2714: WHERE address_req_id = p_request_id
2715: AND request_status = 'PENDING'
2716: AND party_site_id IS NULL;
2717: