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

Line 426: last_updated_by = fnd_global.user_id,

422:
423: UPDATE pos_supplier_mappings
424: SET vendor_id = x_vendor_id,
425: party_id = x_party_id,
426: last_updated_by = fnd_global.user_id,
427: last_update_date = Sysdate,
428: last_update_login = fnd_global.login_id
429: WHERE supplier_reg_id = p_supplier_reg_rec.supplier_reg_id;
430:

Line 428: last_update_login = fnd_global.login_id

424: SET vendor_id = x_vendor_id,
425: party_id = x_party_id,
426: last_updated_by = fnd_global.user_id,
427: last_update_date = Sysdate,
428: last_update_login = fnd_global.login_id
429: WHERE supplier_reg_id = p_supplier_reg_rec.supplier_reg_id;
430:
431:
432: /* Begin Supplier Hub: Supplier Management

Line 449: last_updated_by = fnd_global.user_id,

445:
446: UPDATE fnd_attached_documents
447: SET entity_name = 'PO_VENDORS',
448: pk1_value = x_vendor_id,
449: last_updated_by = fnd_global.user_id,
450: last_update_date = Sysdate,
451: last_update_login = fnd_global.login_id
452: WHERE entity_name = 'POS_SUPP_REG' and
453: pk1_value = p_supplier_reg_rec.supplier_reg_id;

Line 451: last_update_login = fnd_global.login_id

447: SET entity_name = 'PO_VENDORS',
448: pk1_value = x_vendor_id,
449: last_updated_by = fnd_global.user_id,
450: last_update_date = Sysdate,
451: last_update_login = fnd_global.login_id
452: WHERE entity_name = 'POS_SUPP_REG' and
453: pk1_value = p_supplier_reg_rec.supplier_reg_id;
454:
455:

Line 468: last_updated_by = fnd_global.user_id,

464:
465: UPDATE hz_party_usg_assignments
466: SET effective_end_date=sysdate,
467: status_flag = 'I',
468: last_updated_by = fnd_global.user_id,
469: last_update_date = Sysdate,
470: last_update_login = fnd_global.login_id
471: WHERE party_id= x_party_id
472: and party_usage_code='SUPPLIER_PROSPECT';

Line 470: last_update_login = fnd_global.login_id

466: SET effective_end_date=sysdate,
467: status_flag = 'I',
468: last_updated_by = fnd_global.user_id,
469: last_update_date = Sysdate,
470: last_update_login = fnd_global.login_id
471: WHERE party_id= x_party_id
472: and party_usage_code='SUPPLIER_PROSPECT';
473:
474:

Line 490: last_updated_by = fnd_global.user_id,

486: UPDATE pos_supplier_registrations
487: SET registration_status = 'APPROVED',
488: po_vendor_id = x_vendor_id,
489: vendor_party_id = x_party_id,
490: last_updated_by = fnd_global.user_id,
491: last_update_date = Sysdate,
492: last_update_login = fnd_global.login_id
493: WHERE supplier_reg_id = p_supplier_reg_rec.supplier_reg_id;
494:

Line 492: last_update_login = fnd_global.login_id

488: po_vendor_id = x_vendor_id,
489: vendor_party_id = x_party_id,
490: last_updated_by = fnd_global.user_id,
491: last_update_date = Sysdate,
492: last_update_login = fnd_global.login_id
493: WHERE supplier_reg_id = p_supplier_reg_rec.supplier_reg_id;
494:
495: x_return_status := fnd_api.g_ret_sts_success;
496:

Line 1434: last_updated_by = fnd_global.user_id,

1430:
1431: UPDATE pos_supplier_registrations
1432: SET registration_status = 'REJECTED',
1433: last_update_date = Sysdate,
1434: last_updated_by = fnd_global.user_id,
1435: last_update_login = fnd_global.login_id
1436: WHERE supplier_reg_id = p_supplier_reg_id;
1437:
1438: UPDATE pos_address_requests

Line 1435: last_update_login = fnd_global.login_id

1431: UPDATE pos_supplier_registrations
1432: SET registration_status = 'REJECTED',
1433: last_update_date = Sysdate,
1434: last_updated_by = fnd_global.user_id,
1435: last_update_login = fnd_global.login_id
1436: WHERE supplier_reg_id = p_supplier_reg_id;
1437:
1438: UPDATE pos_address_requests
1439: SET request_status = 'REJECTED',

Line 1441: last_updated_by = fnd_global.user_id,

1437:
1438: UPDATE pos_address_requests
1439: SET request_status = 'REJECTED',
1440: last_update_date = Sysdate,
1441: last_updated_by = fnd_global.user_id,
1442: last_update_login = fnd_global.login_id
1443: WHERE mapping_id =
1444: (SELECT mapping_id FROM pos_supplier_mappings
1445: WHERE supplier_reg_id = p_supplier_reg_id)

Line 1442: last_update_login = fnd_global.login_id

1438: UPDATE pos_address_requests
1439: SET request_status = 'REJECTED',
1440: last_update_date = Sysdate,
1441: last_updated_by = fnd_global.user_id,
1442: last_update_login = fnd_global.login_id
1443: WHERE mapping_id =
1444: (SELECT mapping_id FROM pos_supplier_mappings
1445: WHERE supplier_reg_id = p_supplier_reg_id)
1446: AND request_status = 'PENDING';

Line 1451: last_updated_by = fnd_global.user_id,

1447:
1448: UPDATE pos_contact_requests
1449: SET request_status = 'REJECTED',
1450: last_update_date = Sysdate,
1451: last_updated_by = fnd_global.user_id,
1452: last_update_login = fnd_global.login_id
1453: WHERE mapping_id =
1454: (SELECT mapping_id FROM pos_supplier_mappings
1455: WHERE supplier_reg_id = p_supplier_reg_id)

Line 1452: last_update_login = fnd_global.login_id

1448: UPDATE pos_contact_requests
1449: SET request_status = 'REJECTED',
1450: last_update_date = Sysdate,
1451: last_updated_by = fnd_global.user_id,
1452: last_update_login = fnd_global.login_id
1453: WHERE mapping_id =
1454: (SELECT mapping_id FROM pos_supplier_mappings
1455: WHERE supplier_reg_id = p_supplier_reg_id)
1456: AND request_status = 'PENDING';

Line 1461: last_updated_by = fnd_global.user_id,

1457:
1458: UPDATE pos_cont_addr_requests
1459: SET request_status = 'REJECTED',
1460: last_update_date = Sysdate,
1461: last_updated_by = fnd_global.user_id,
1462: last_update_login = fnd_global.login_id
1463: WHERE mapping_id =
1464: (SELECT mapping_id FROM pos_supplier_mappings
1465: WHERE supplier_reg_id = p_supplier_reg_id)

Line 1462: last_update_login = fnd_global.login_id

1458: UPDATE pos_cont_addr_requests
1459: SET request_status = 'REJECTED',
1460: last_update_date = Sysdate,
1461: last_updated_by = fnd_global.user_id,
1462: last_update_login = fnd_global.login_id
1463: WHERE mapping_id =
1464: (SELECT mapping_id FROM pos_supplier_mappings
1465: WHERE supplier_reg_id = p_supplier_reg_id)
1466: AND request_status = 'PENDING';

Line 1484: last_updated_by = fnd_global.user_id,

1480:
1481: update hz_parties
1482: set status = 'I',
1483: last_update_date = Sysdate,
1484: last_updated_by = fnd_global.user_id,
1485: last_update_login = fnd_global.login_id
1486: where status = 'A' and
1487: created_by_module = 'POS_SUPPLIER_MGMT' and
1488: party_id = (select vendor_party_id

Line 1485: last_update_login = fnd_global.login_id

1481: update hz_parties
1482: set status = 'I',
1483: last_update_date = Sysdate,
1484: last_updated_by = fnd_global.user_id,
1485: last_update_login = fnd_global.login_id
1486: where status = 'A' and
1487: created_by_module = 'POS_SUPPLIER_MGMT' and
1488: party_id = (select vendor_party_id
1489: from pos_supplier_registrations

Line 1499: last_updated_by = fnd_global.user_id,

1495: UPDATE hz_party_usg_assignments
1496: SET effective_end_date=sysdate,
1497: status_flag = 'I',
1498: last_update_date = Sysdate,
1499: last_updated_by = fnd_global.user_id,
1500: last_update_login = fnd_global.login_id
1501: WHERE party_id= (select vendor_party_id
1502: from pos_supplier_registrations
1503: where supplier_reg_id = p_supplier_reg_id)

Line 1500: last_update_login = fnd_global.login_id

1496: SET effective_end_date=sysdate,
1497: status_flag = 'I',
1498: last_update_date = Sysdate,
1499: last_updated_by = fnd_global.user_id,
1500: last_update_login = fnd_global.login_id
1501: WHERE party_id= (select vendor_party_id
1502: from pos_supplier_registrations
1503: where supplier_reg_id = p_supplier_reg_id)
1504: and party_usage_code='SUPPLIER_PROSPECT';

Line 1589: last_updated_by = fnd_global.user_id,

1585:
1586: UPDATE pos_supplier_registrations
1587: SET registration_status = 'PENDING_APPROVAL',
1588: last_update_date = Sysdate,
1589: last_updated_by = fnd_global.user_id,
1590: last_update_login = fnd_global.login_id
1591: WHERE supplier_reg_id = p_supplier_reg_id;
1592:
1593: x_return_status := fnd_api.g_ret_sts_success;

Line 1590: last_update_login = fnd_global.login_id

1586: UPDATE pos_supplier_registrations
1587: SET registration_status = 'PENDING_APPROVAL',
1588: last_update_date = Sysdate,
1589: last_updated_by = fnd_global.user_id,
1590: last_update_login = fnd_global.login_id
1591: WHERE supplier_reg_id = p_supplier_reg_id;
1592:
1593: x_return_status := fnd_api.g_ret_sts_success;
1594: x_msg_count := 0;

Line 2248: fnd_global.user_id,

2244:
2245: -- Bug 15982192
2246: -- Added support for UDA security
2247: pos_data_security.get_privileges_prosp(p_supp_reg_id,
2248: fnd_global.user_id,
2249: l_return_status,
2250: l_privileges);
2251: l_privileges := '''' || REPLACE(l_privileges, ',', ''',''') || '''';
2252: