DBA Data[Home] [Help]

APPS.POS_VENDOR_REG_PKG dependencies on FND_GLOBAL

Line 397: last_updated_by = fnd_global.user_id,

393:
394: UPDATE pos_supplier_mappings
395: SET vendor_id = x_vendor_id,
396: party_id = x_party_id,
397: last_updated_by = fnd_global.user_id,
398: last_update_date = Sysdate,
399: last_update_login = fnd_global.login_id
400: WHERE supplier_reg_id = p_supplier_reg_rec.supplier_reg_id;
401:

Line 399: last_update_login = fnd_global.login_id

395: SET vendor_id = x_vendor_id,
396: party_id = x_party_id,
397: last_updated_by = fnd_global.user_id,
398: last_update_date = Sysdate,
399: last_update_login = fnd_global.login_id
400: WHERE supplier_reg_id = p_supplier_reg_rec.supplier_reg_id;
401:
402: l_step := 'update pos_supplier_registrations with ids';
403:

Line 415: last_updated_by = fnd_global.user_id,

411: UPDATE pos_supplier_registrations
412: SET registration_status = 'APPROVED',
413: po_vendor_id = x_vendor_id,
414: vendor_party_id = x_party_id,
415: last_updated_by = fnd_global.user_id,
416: last_update_date = Sysdate,
417: last_update_login = fnd_global.login_id
418: WHERE supplier_reg_id = p_supplier_reg_rec.supplier_reg_id;
419:

Line 417: last_update_login = fnd_global.login_id

413: po_vendor_id = x_vendor_id,
414: vendor_party_id = x_party_id,
415: last_updated_by = fnd_global.user_id,
416: last_update_date = Sysdate,
417: last_update_login = fnd_global.login_id
418: WHERE supplier_reg_id = p_supplier_reg_rec.supplier_reg_id;
419:
420: x_return_status := fnd_api.g_ret_sts_success;
421:

Line 1217: last_updated_by = fnd_global.user_id,

1213:
1214: UPDATE pos_supplier_registrations
1215: SET registration_status = 'REJECTED',
1216: last_update_date = Sysdate,
1217: last_updated_by = fnd_global.user_id,
1218: last_update_login = fnd_global.login_id
1219: WHERE supplier_reg_id = p_supplier_reg_id;
1220:
1221: UPDATE pos_address_requests

Line 1218: last_update_login = fnd_global.login_id

1214: UPDATE pos_supplier_registrations
1215: SET registration_status = 'REJECTED',
1216: last_update_date = Sysdate,
1217: last_updated_by = fnd_global.user_id,
1218: last_update_login = fnd_global.login_id
1219: WHERE supplier_reg_id = p_supplier_reg_id;
1220:
1221: UPDATE pos_address_requests
1222: SET request_status = 'REJECTED',

Line 1224: last_updated_by = fnd_global.user_id,

1220:
1221: UPDATE pos_address_requests
1222: SET request_status = 'REJECTED',
1223: last_update_date = Sysdate,
1224: last_updated_by = fnd_global.user_id,
1225: last_update_login = fnd_global.login_id
1226: WHERE mapping_id =
1227: (SELECT mapping_id FROM pos_supplier_mappings
1228: WHERE supplier_reg_id = p_supplier_reg_id)

Line 1225: last_update_login = fnd_global.login_id

1221: UPDATE pos_address_requests
1222: SET request_status = 'REJECTED',
1223: last_update_date = Sysdate,
1224: last_updated_by = fnd_global.user_id,
1225: last_update_login = fnd_global.login_id
1226: WHERE mapping_id =
1227: (SELECT mapping_id FROM pos_supplier_mappings
1228: WHERE supplier_reg_id = p_supplier_reg_id)
1229: AND request_status = 'PENDING';

Line 1234: last_updated_by = fnd_global.user_id,

1230:
1231: UPDATE pos_contact_requests
1232: SET request_status = 'REJECTED',
1233: last_update_date = Sysdate,
1234: last_updated_by = fnd_global.user_id,
1235: last_update_login = fnd_global.login_id
1236: WHERE mapping_id =
1237: (SELECT mapping_id FROM pos_supplier_mappings
1238: WHERE supplier_reg_id = p_supplier_reg_id)

Line 1235: last_update_login = fnd_global.login_id

1231: UPDATE pos_contact_requests
1232: SET request_status = 'REJECTED',
1233: last_update_date = Sysdate,
1234: last_updated_by = fnd_global.user_id,
1235: last_update_login = fnd_global.login_id
1236: WHERE mapping_id =
1237: (SELECT mapping_id FROM pos_supplier_mappings
1238: WHERE supplier_reg_id = p_supplier_reg_id)
1239: AND request_status = 'PENDING';

Line 1244: last_updated_by = fnd_global.user_id,

1240:
1241: UPDATE pos_cont_addr_requests
1242: SET request_status = 'REJECTED',
1243: last_update_date = Sysdate,
1244: last_updated_by = fnd_global.user_id,
1245: last_update_login = fnd_global.login_id
1246: WHERE mapping_id =
1247: (SELECT mapping_id FROM pos_supplier_mappings
1248: WHERE supplier_reg_id = p_supplier_reg_id)

Line 1245: last_update_login = fnd_global.login_id

1241: UPDATE pos_cont_addr_requests
1242: SET request_status = 'REJECTED',
1243: last_update_date = Sysdate,
1244: last_updated_by = fnd_global.user_id,
1245: last_update_login = fnd_global.login_id
1246: WHERE mapping_id =
1247: (SELECT mapping_id FROM pos_supplier_mappings
1248: WHERE supplier_reg_id = p_supplier_reg_id)
1249: AND request_status = 'PENDING';

Line 1328: last_updated_by = fnd_global.user_id,

1324:
1325: UPDATE pos_supplier_registrations
1326: SET registration_status = 'PENDING_APPROVAL',
1327: last_update_date = Sysdate,
1328: last_updated_by = fnd_global.user_id,
1329: last_update_login = fnd_global.login_id
1330: WHERE supplier_reg_id = p_supplier_reg_id;
1331:
1332: x_return_status := fnd_api.g_ret_sts_success;

Line 1329: last_update_login = fnd_global.login_id

1325: UPDATE pos_supplier_registrations
1326: SET registration_status = 'PENDING_APPROVAL',
1327: last_update_date = Sysdate,
1328: last_updated_by = fnd_global.user_id,
1329: last_update_login = fnd_global.login_id
1330: WHERE supplier_reg_id = p_supplier_reg_id;
1331:
1332: x_return_status := fnd_api.g_ret_sts_success;
1333: x_msg_count := 0;