APPS.POS_VENDOR_REG_PKG dependencies on POS_SUPPLIER_MAPPINGS

Line 64: , pos_supplier_mappings psm

60: IS
61: CURSOR l_cur IS
62: SELECT ext_attr_1
63: FROM pos_bus_class_reqs pbcr
64: , pos_supplier_mappings psm
65: , pos_supplier_registrations psr
66: WHERE psm.supplier_reg_id = psr.supplier_reg_id
67: AND psr.supplier_reg_id = p_supplier_reg_id
68: AND pbcr.mapping_id = psm.mapping_id

Line 383: l_step := 'update pos_supplier_mappings with ids';

379: x_return_status <> fnd_api.g_ret_sts_success THEN
380: RETURN;
381: END IF;
382:
383: l_step := 'update pos_supplier_mappings with ids';
384: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
385: fnd_log.string
386: (fnd_log.level_statement
387: , g_module || '.' || l_method

Line 394: UPDATE pos_supplier_mappings

390: || ' x_msg_data ' || x_msg_data
391: );
392: END IF;
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,

Line 448: , pos_supplier_mappings psm

444: ) IS
445: CURSOR l_cur IS
446: SELECT par.address_request_id
447: FROM pos_address_requests par
448: , pos_supplier_mappings psm
449: WHERE par.request_type = 'ADD'
450: AND par.request_status = 'PENDING'
451: AND par.mapping_id = psm.mapping_id
452: AND psm.supplier_reg_id = p_supplier_reg_id;

Line 483: , pos_supplier_mappings psm

479: IS
480: CURSOR l_cur IS
481: SELECT pcr.contact_request_id, pcr.email_address, psm.vendor_id, create_user_account
482: FROM pos_contact_requests pcr
483: , pos_supplier_mappings psm
484: WHERE pcr.request_type = 'ADD'
485: AND pcr.request_status = 'PENDING'
486: AND pcr.mapping_id = psm.mapping_id
487: AND psm.supplier_reg_id = p_supplier_reg_id;

Line 595: , pos_supplier_mappings psm

591: IS
592: CURSOR l_cur IS
593: SELECT pbcr.bus_class_request_id
594: FROM pos_bus_class_reqs pbcr
595: , pos_supplier_mappings psm
596: WHERE pbcr.request_type = 'ADD'
597: AND pbcr.request_status = 'PENDING'
598: AND pbcr.mapping_id = psm.mapping_id
599: AND psm.supplier_reg_id = p_supplier_reg_id;

Line 630: , pos_supplier_mappings psm

626: IS
627: CURSOR l_cur IS
628: SELECT ppsr.ps_request_id
629: FROM pos_product_service_requests ppsr
630: , pos_supplier_mappings psm
631: WHERE ppsr.request_type = 'ADD'
632: AND ppsr.request_status = 'PENDING'
633: AND ppsr.mapping_id = psm.mapping_id
634: AND psm.supplier_reg_id = p_supplier_reg_id;

Line 666: FROM pos_supplier_mappings

662: SELECT fu.user_name, fu.user_id
663: FROM pos_contact_requests pcr, fnd_user fu
664: WHERE pcr.mapping_id =
665: (SELECT mapping_id
666: FROM pos_supplier_mappings
667: WHERE supplier_reg_id = p_supplier_reg_id
668: )
669: AND pcr.request_status = 'APPROVED'
670: AND pcr.do_not_delete = 'Y'

Line 1227: (SELECT mapping_id FROM pos_supplier_mappings

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';
1230:
1231: UPDATE pos_contact_requests

Line 1237: (SELECT mapping_id FROM pos_supplier_mappings

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';
1240:
1241: UPDATE pos_cont_addr_requests

Line 1247: (SELECT mapping_id FROM pos_supplier_mappings

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';
1250:
1251: pos_spm_wf_pkg1.notify_supplier_rejected