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 494: last_updated_by = fnd_global.user_id,

490: UPDATE pos_contact_requests
491: SET contact_party_id = l_person_party_id,
492: request_status = 'APPROVED',
493: last_update_date = Sysdate,
494: last_updated_by = fnd_global.user_id,
495: last_update_login = fnd_global.login_id
496: WHERE contact_request_id = p_request_rec.contact_request_id;
497:
498: UPDATE pos_cont_addr_requests

Line 495: last_update_login = fnd_global.login_id

491: SET contact_party_id = l_person_party_id,
492: request_status = 'APPROVED',
493: last_update_date = Sysdate,
494: last_updated_by = fnd_global.user_id,
495: last_update_login = fnd_global.login_id
496: WHERE contact_request_id = p_request_rec.contact_request_id;
497:
498: UPDATE pos_cont_addr_requests
499: SET contact_party_id = l_person_party_id,

Line 501: last_updated_by = fnd_global.user_id,

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

Line 502: last_update_login = fnd_global.login_id

498: UPDATE pos_cont_addr_requests
499: SET contact_party_id = l_person_party_id,
500: last_update_date = Sysdate,
501: last_updated_by = fnd_global.user_id,
502: last_update_login = fnd_global.login_id
503: WHERE contact_req_id = p_request_rec.contact_request_id
504: AND contact_party_id IS NULL
505: AND request_status = 'PENDING';
506:

Line 627: last_updated_by = fnd_global.user_id,

623:
624: UPDATE pos_contact_requests
625: SET request_status = 'APPROVED',
626: last_update_date = Sysdate,
627: last_updated_by = fnd_global.user_id,
628: last_update_login = fnd_global.login_id
629: WHERE contact_request_id = p_request_rec.contact_request_id;
630:
631: -- handle address contact association

Line 628: last_update_login = fnd_global.login_id

624: UPDATE pos_contact_requests
625: SET request_status = 'APPROVED',
626: last_update_date = Sysdate,
627: last_updated_by = fnd_global.user_id,
628: last_update_login = fnd_global.login_id
629: WHERE contact_request_id = p_request_rec.contact_request_id;
630:
631: -- handle address contact association
632: approve_cont_addr_requests

Line 719: , fnd_global.user_id

715: , p_request_rec.expiration_date
716: , p_request_rec.certification_no
717: , p_request_rec.certification_agency
718: , 'APPROVED'
719: , fnd_global.user_id
720: , Sysdate
721: , fnd_global.user_id
722: , Sysdate
723: , fnd_global.login_id

Line 721: , fnd_global.user_id

717: , p_request_rec.certification_agency
718: , 'APPROVED'
719: , fnd_global.user_id
720: , Sysdate
721: , fnd_global.user_id
722: , Sysdate
723: , fnd_global.login_id
724: , p_vendor_id
725: );

Line 723: , fnd_global.login_id

719: , fnd_global.user_id
720: , Sysdate
721: , fnd_global.user_id
722: , Sysdate
723: , fnd_global.login_id
724: , p_vendor_id
725: );
726:
727: UPDATE pos_bus_class_reqs

Line 730: last_updated_by = fnd_global.user_id,

726:
727: UPDATE pos_bus_class_reqs
728: SET request_status = 'APPROVED',
729: last_update_date = Sysdate,
730: last_updated_by = fnd_global.user_id,
731: last_update_login = fnd_global.login_id
732: WHERE bus_class_request_id = p_request_rec.bus_class_request_id;
733:
734: x_return_status := fnd_api.g_ret_sts_success;

Line 731: last_update_login = fnd_global.login_id

727: UPDATE pos_bus_class_reqs
728: SET request_status = 'APPROVED',
729: last_update_date = Sysdate,
730: last_updated_by = fnd_global.user_id,
731: last_update_login = fnd_global.login_id
732: WHERE bus_class_request_id = p_request_rec.bus_class_request_id;
733:
734: x_return_status := fnd_api.g_ret_sts_success;
735:

Line 786: , last_updated_by = fnd_global.user_id

782: SET ext_attr_1 = p_request_rec.ext_attr_1
783: , expiration_date = p_request_rec.expiration_date
784: , certificate_number = p_request_rec.certification_no
785: , certifying_agency = p_request_rec.certification_agency
786: , last_updated_by = fnd_global.user_id
787: , last_update_date = Sysdate
788: , last_update_login = fnd_global.login_id
789: WHERE classification_id = p_request_rec.classification_id;
790:

Line 788: , last_update_login = fnd_global.login_id

784: , certificate_number = p_request_rec.certification_no
785: , certifying_agency = p_request_rec.certification_agency
786: , last_updated_by = fnd_global.user_id
787: , last_update_date = Sysdate
788: , last_update_login = fnd_global.login_id
789: WHERE classification_id = p_request_rec.classification_id;
790:
791: UPDATE pos_bus_class_reqs
792: SET request_status = 'APPROVED',

Line 794: last_updated_by = fnd_global.user_id,

790:
791: UPDATE pos_bus_class_reqs
792: SET request_status = 'APPROVED',
793: last_update_date = Sysdate,
794: last_updated_by = fnd_global.user_id,
795: last_update_login = fnd_global.login_id
796: WHERE bus_class_request_id = p_request_rec.bus_class_request_id;
797:
798: x_return_status := fnd_api.g_ret_sts_success;

Line 795: last_update_login = fnd_global.login_id

791: UPDATE pos_bus_class_reqs
792: SET request_status = 'APPROVED',
793: last_update_date = Sysdate,
794: last_updated_by = fnd_global.user_id,
795: last_update_login = fnd_global.login_id
796: WHERE bus_class_request_id = p_request_rec.bus_class_request_id;
797:
798: x_return_status := fnd_api.g_ret_sts_success;
799: EXCEPTION

Line 896: last_updated_by = fnd_global.user_id,

892:
893: UPDATE pos_address_requests
894: SET request_status = 'APPROVED',
895: last_update_date = Sysdate,
896: last_updated_by = fnd_global.user_id,
897: last_update_login = fnd_global.login_id
898: WHERE address_request_id = p_request_id;
899:
900: ELSE

Line 897: last_update_login = fnd_global.login_id

893: UPDATE pos_address_requests
894: SET request_status = 'APPROVED',
895: last_update_date = Sysdate,
896: last_updated_by = fnd_global.user_id,
897: last_update_login = fnd_global.login_id
898: WHERE address_request_id = p_request_id;
899:
900: ELSE
901: x_return_status := fnd_api.g_ret_sts_error;

Line 1096: last_updated_by = fnd_global.user_id,

1092:
1093: UPDATE pos_contact_requests
1094: SET request_status = 'APPROVED',
1095: last_update_date = Sysdate,
1096: last_updated_by = fnd_global.user_id,
1097: last_update_login = fnd_global.login_id
1098: WHERE contact_request_id = l_rec.contact_request_id;
1099:
1100: /*End Supplier Hub -- Supplier Management */

Line 1097: last_update_login = fnd_global.login_id

1093: UPDATE pos_contact_requests
1094: SET request_status = 'APPROVED',
1095: last_update_date = Sysdate,
1096: last_updated_by = fnd_global.user_id,
1097: last_update_login = fnd_global.login_id
1098: WHERE contact_request_id = l_rec.contact_request_id;
1099:
1100: /*End Supplier Hub -- Supplier Management */
1101:

Line 1359: , fnd_global.user_id

1355: , l_rec.segment19
1356: , l_rec.segment20
1357: , 'A'
1358: , l_rec.segment_definition
1359: , fnd_global.user_id
1360: , Sysdate
1361: , fnd_global.user_id
1362: , Sysdate
1363: , fnd_global.login_id

Line 1361: , fnd_global.user_id

1357: , 'A'
1358: , l_rec.segment_definition
1359: , fnd_global.user_id
1360: , Sysdate
1361: , fnd_global.user_id
1362: , Sysdate
1363: , fnd_global.login_id
1364: );
1365:

Line 1363: , fnd_global.login_id

1359: , fnd_global.user_id
1360: , Sysdate
1361: , fnd_global.user_id
1362: , Sysdate
1363: , fnd_global.login_id
1364: );
1365:
1366: UPDATE pos_product_service_requests
1367: SET request_status = 'APPROVED',

Line 1369: last_updated_by = fnd_global.user_id,

1365:
1366: UPDATE pos_product_service_requests
1367: SET request_status = 'APPROVED',
1368: last_update_date = Sysdate,
1369: last_updated_by = fnd_global.user_id,
1370: last_update_login = fnd_global.login_id
1371: WHERE ps_request_id = p_request_id;
1372:
1373: x_return_status := fnd_api.g_ret_sts_success;

Line 1370: last_update_login = fnd_global.login_id

1366: UPDATE pos_product_service_requests
1367: SET request_status = 'APPROVED',
1368: last_update_date = Sysdate,
1369: last_updated_by = fnd_global.user_id,
1370: last_update_login = fnd_global.login_id
1371: WHERE ps_request_id = p_request_id;
1372:
1373: x_return_status := fnd_api.g_ret_sts_success;
1374:

Line 1424: last_updated_by = fnd_global.user_id,

1420:
1421: UPDATE pos_address_requests
1422: SET request_status = 'REJECTED',
1423: last_update_date = Sysdate,
1424: last_updated_by = fnd_global.user_id,
1425: last_update_login = fnd_global.login_id
1426: WHERE address_request_id = p_request_id;
1427:
1428: UPDATE pos_cont_addr_requests

Line 1425: last_update_login = fnd_global.login_id

1421: UPDATE pos_address_requests
1422: SET request_status = 'REJECTED',
1423: last_update_date = Sysdate,
1424: last_updated_by = fnd_global.user_id,
1425: last_update_login = fnd_global.login_id
1426: WHERE address_request_id = p_request_id;
1427:
1428: UPDATE pos_cont_addr_requests
1429: SET request_status = 'REJECTED',

Line 1431: last_updated_by = fnd_global.user_id,

1427:
1428: UPDATE pos_cont_addr_requests
1429: SET request_status = 'REJECTED',
1430: last_update_date = Sysdate,
1431: last_updated_by = fnd_global.user_id,
1432: last_update_login = fnd_global.login_id
1433: WHERE address_req_id = p_request_id;
1434:
1435: x_return_status := fnd_api.g_ret_sts_success;

Line 1432: last_update_login = fnd_global.login_id

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

Line 1480: last_updated_by = fnd_global.user_id,

1476: -- Bug # 5192274, the address requests should also be rejected
1477: update pos_cont_addr_requests
1478: set request_status = 'REJECTED',
1479: last_update_date = sysdate,
1480: last_updated_by = fnd_global.user_id,
1481: last_update_login = fnd_global.login_id
1482: where contact_req_id = p_request_id;
1483:
1484: UPDATE pos_contact_requests

Line 1481: last_update_login = fnd_global.login_id

1477: update pos_cont_addr_requests
1478: set request_status = 'REJECTED',
1479: last_update_date = sysdate,
1480: last_updated_by = fnd_global.user_id,
1481: last_update_login = fnd_global.login_id
1482: where contact_req_id = p_request_id;
1483:
1484: UPDATE pos_contact_requests
1485: SET request_status = 'REJECTED',

Line 1487: last_updated_by = fnd_global.user_id,

1483:
1484: UPDATE pos_contact_requests
1485: SET request_status = 'REJECTED',
1486: last_update_date = Sysdate,
1487: last_updated_by = fnd_global.user_id,
1488: last_update_login = fnd_global.login_id
1489: WHERE contact_request_id = p_request_id;
1490:
1491: x_return_status := fnd_api.g_ret_sts_success;

Line 1488: last_update_login = fnd_global.login_id

1484: UPDATE pos_contact_requests
1485: SET request_status = 'REJECTED',
1486: last_update_date = Sysdate,
1487: last_updated_by = fnd_global.user_id,
1488: last_update_login = fnd_global.login_id
1489: WHERE contact_request_id = p_request_id;
1490:
1491: x_return_status := fnd_api.g_ret_sts_success;
1492: EXCEPTION

Line 1535: last_updated_by = fnd_global.user_id,

1531:
1532: UPDATE pos_bus_class_reqs
1533: SET request_status = 'REJECTED',
1534: last_update_date = Sysdate,
1535: last_updated_by = fnd_global.user_id,
1536: last_update_login = fnd_global.login_id
1537: WHERE bus_class_request_id = p_request_id;
1538:
1539: x_return_status := fnd_api.g_ret_sts_success;

Line 1536: last_update_login = fnd_global.login_id

1532: UPDATE pos_bus_class_reqs
1533: SET request_status = 'REJECTED',
1534: last_update_date = Sysdate,
1535: last_updated_by = fnd_global.user_id,
1536: last_update_login = fnd_global.login_id
1537: WHERE bus_class_request_id = p_request_id;
1538:
1539: x_return_status := fnd_api.g_ret_sts_success;
1540: EXCEPTION

Line 1581: last_updated_by = fnd_global.user_id,

1577:
1578: UPDATE pos_product_service_requests
1579: SET request_status = 'REJECTED',
1580: last_update_date = Sysdate,
1581: last_updated_by = fnd_global.user_id,
1582: last_update_login = fnd_global.login_id
1583: WHERE ps_request_id = p_request_id;
1584:
1585: x_return_status := fnd_api.g_ret_sts_success;

Line 1582: last_update_login = fnd_global.login_id

1578: UPDATE pos_product_service_requests
1579: SET request_status = 'REJECTED',
1580: last_update_date = Sysdate,
1581: last_updated_by = fnd_global.user_id,
1582: last_update_login = fnd_global.login_id
1583: WHERE ps_request_id = p_request_id;
1584:
1585: x_return_status := fnd_api.g_ret_sts_success;
1586:

Line 2321: last_updated_by = fnd_global.user_id,

2317: RFQ_FLAG = p_rfq_flag,
2318: PAY_FLAG = p_pay_flag,
2319: PUR_FLAG = p_pur_flag,
2320: last_update_date = Sysdate,
2321: last_updated_by = fnd_global.user_id,
2322: last_update_login = fnd_global.login_id
2323: WHERE ADDRESS_REQUEST_ID = p_request_id;
2324:
2325: l_step := 2;

Line 2322: last_update_login = fnd_global.login_id

2318: PAY_FLAG = p_pay_flag,
2319: PUR_FLAG = p_pur_flag,
2320: last_update_date = Sysdate,
2321: last_updated_by = fnd_global.user_id,
2322: last_update_login = fnd_global.login_id
2323: WHERE ADDRESS_REQUEST_ID = p_request_id;
2324:
2325: l_step := 2;
2326:

Line 2487: last_updated_by = fnd_global.user_id,

2483: ALT_AREA_CODE = p_alt_area_code,
2484: ALT_PHONE_NUMBER = p_alt_phone_number,
2485: URL = p_url,
2486: last_update_date = Sysdate,
2487: last_updated_by = fnd_global.user_id,
2488: last_update_login = fnd_global.login_id
2489: WHERE CONTACT_REQUEST_ID = p_request_id;
2490:
2491: approve_contact_req

Line 2488: last_update_login = fnd_global.login_id

2484: ALT_PHONE_NUMBER = p_alt_phone_number,
2485: URL = p_url,
2486: last_update_date = Sysdate,
2487: last_updated_by = fnd_global.user_id,
2488: last_update_login = fnd_global.login_id
2489: WHERE CONTACT_REQUEST_ID = p_request_id;
2490:
2491: approve_contact_req
2492: (p_request_id => p_request_id,

Line 2779: last_updated_by = fnd_global.user_id,

2775: UPDATE pos_address_requests
2776: SET request_status = p_req_status,
2777: PARTY_SITE_ID = p_party_site_id,
2778: last_update_date = Sysdate,
2779: last_updated_by = fnd_global.user_id,
2780: last_update_login = fnd_global.login_id
2781: WHERE address_request_id = p_request_id;
2782:
2783: UPDATE pos_cont_addr_requests

Line 2780: last_update_login = fnd_global.login_id

2776: SET request_status = p_req_status,
2777: PARTY_SITE_ID = p_party_site_id,
2778: last_update_date = Sysdate,
2779: last_updated_by = fnd_global.user_id,
2780: last_update_login = fnd_global.login_id
2781: WHERE address_request_id = p_request_id;
2782:
2783: UPDATE pos_cont_addr_requests
2784: SET party_site_id = p_party_site_id,

Line 2786: last_updated_by = fnd_global.user_id,

2782:
2783: UPDATE pos_cont_addr_requests
2784: SET party_site_id = p_party_site_id,
2785: last_update_date = Sysdate,
2786: last_updated_by = fnd_global.user_id,
2787: last_update_login = fnd_global.login_id
2788: WHERE address_req_id = p_request_id
2789: AND request_status = 'PENDING'
2790: AND party_site_id IS NULL;

Line 2787: last_update_login = fnd_global.login_id

2783: UPDATE pos_cont_addr_requests
2784: SET party_site_id = p_party_site_id,
2785: last_update_date = Sysdate,
2786: last_updated_by = fnd_global.user_id,
2787: last_update_login = fnd_global.login_id
2788: WHERE address_req_id = p_request_id
2789: AND request_status = 'PENDING'
2790: AND party_site_id IS NULL;
2791: