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 POS_SUPPLIER_REGISTRATIONS

Line 21: x_supplier_reg_rec OUT NOCOPY pos_supplier_registrations%ROWTYPE

17: (p_supplier_reg_id IN NUMBER,
18: x_return_status OUT NOCOPY VARCHAR2,
19: x_msg_count OUT NOCOPY NUMBER,
20: x_msg_data OUT NOCOPY VARCHAR2,
21: x_supplier_reg_rec OUT NOCOPY pos_supplier_registrations%ROWTYPE
22: )
23: IS
24: CURSOR l_cur IS
25: SELECT *

Line 26: FROM pos_supplier_registrations

22: )
23: IS
24: CURSOR l_cur IS
25: SELECT *
26: FROM pos_supplier_registrations
27: WHERE supplier_reg_id = p_supplier_reg_id FOR UPDATE;
28: BEGIN
29: OPEN l_cur;
30: FETCH l_cur INTO x_supplier_reg_rec;

Line 65: , pos_supplier_registrations psr

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
69: AND pbcr.request_type = 'ADD'

Line 140: (p_supplier_reg_rec IN pos_supplier_registrations%ROWTYPE,

136: );
137: END save_duns_number;
138:
139: PROCEDURE create_vendor_and_party
140: (p_supplier_reg_rec IN pos_supplier_registrations%ROWTYPE,
141: x_return_status OUT NOCOPY VARCHAR2,
142: x_msg_count OUT NOCOPY NUMBER,
143: x_msg_data OUT NOCOPY VARCHAR2,
144: x_vendor_id OUT NOCOPY NUMBER,

Line 402: l_step := 'update pos_supplier_registrations with ids';

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:
404: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
405: fnd_log.string
406: (fnd_log.level_statement

Line 411: UPDATE pos_supplier_registrations

407: , g_module || '.' || l_method
408: , l_step);
409: END IF;
410:
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,

Line 500: FROM pos_supplier_registrations

496: l_user_id NUMBER;
497:
498: CURSOR l_reg_type_cur IS
499: SELECT registration_type
500: FROM pos_supplier_registrations
501: WHERE supplier_reg_id = p_supplier_reg_id;
502:
503: l_reg_type_rec l_reg_type_cur%ROWTYPE;
504:

Line 789: l_supplier_reg_rec pos_supplier_registrations%ROWTYPE;

785: x_msg_count OUT NOCOPY NUMBER,
786: x_msg_data OUT NOCOPY VARCHAR2
787: )
788: IS
789: l_supplier_reg_rec pos_supplier_registrations%ROWTYPE;
790: l_step VARCHAR2(100);
791: l_method VARCHAR2(30);
792: l_vendor_id NUMBER;
793: l_vendor_party_id NUMBER;

Line 1111: from pos_supplier_registrations

1107:
1108: update ap_suppliers
1109: set bus_class_last_certified_by = l_user_id,
1110: bus_class_last_certified_date = (select creation_date
1111: from pos_supplier_registrations
1112: where supplier_reg_id = p_supplier_reg_id ),
1113: last_updated_by = l_user_id,
1114: last_update_date = sysdate
1115:

Line 1163: l_supplier_reg_rec pos_supplier_registrations%ROWTYPE;

1159: l_itemtype wf_items.item_type%TYPE;
1160: l_itemkey wf_items.item_key%TYPE;
1161: l_receiver fnd_user.user_name%TYPE;
1162:
1163: l_supplier_reg_rec pos_supplier_registrations%ROWTYPE;
1164:
1165: BEGIN
1166: l_method := 'reject_supplier_reg';
1167:

Line 1214: UPDATE pos_supplier_registrations

1210:
1211: RETURN;
1212: END IF;
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

Line 1273: l_supplier_reg_rec pos_supplier_registrations%ROWTYPE;

1269: ) IS
1270:
1271: l_step VARCHAR2(100);
1272: l_method VARCHAR2(30);
1273: l_supplier_reg_rec pos_supplier_registrations%ROWTYPE;
1274: BEGIN
1275: l_method := 'submit_supplier_reg';
1276:
1277: l_step := 'lock supplier reg row';

Line 1325: UPDATE pos_supplier_registrations

1321:
1322: RETURN;
1323: END IF;
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

Line 1396: FROM pos_supplier_registrations

1392: RETURN 'N';
1393: END IF;
1394:
1395: FOR x IN (SELECT supplier_number
1396: FROM pos_supplier_registrations
1397: WHERE supplier_reg_id <> p_supp_regid
1398: --AND registration_status <> 'REJECTED'
1399: -- the unique key POS_SUPPLIER_REG_U2 is on supplier_number only
1400: -- without considering the registration_status

Line 1433: FROM pos_supplier_registrations psr

1429: IS
1430:
1431: CURSOR supp_reg_cur IS
1432: SELECT -1
1433: FROM pos_supplier_registrations psr
1434: WHERE psr.supplier_reg_id <> p_supp_regid
1435: AND psr.taxpayer_id = p_taxpayer_id
1436: AND ((psr.tax_reg_country_code is not null and p_country is not null and psr.tax_reg_country_code = p_country) OR
1437: (p_country is null))

Line 1489: FROM pos_supplier_registrations psr

1485: l_party_id hz_parties.party_id%TYPE := -1;
1486:
1487: CURSOR supp_reg_cur IS
1488: SELECT -1
1489: FROM pos_supplier_registrations psr
1490: WHERE psr.supplier_reg_id <> p_supp_regid
1491: AND psr.duns_number = p_duns_num
1492: AND psr.registration_status = 'PENDING_APPROVAL';
1493:

Line 1554: FROM pos_supplier_registrations psr

1550: IS
1551:
1552: CURSOR supp_reg_cur IS
1553: SELECT -1
1554: FROM pos_supplier_registrations psr
1555: WHERE psr.supplier_reg_id <> p_supp_regid
1556: AND psr.tax_registration_number = p_taxreg_num
1557: AND ((psr.tax_reg_country_code is not null and p_country is not null and psr.tax_reg_country_code = p_country) OR
1558: (p_country is null))