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 POS_CONT_ADDR_REQUESTS

Line 20: select address_req_id from pos_cont_addr_requests

16: l_location_id NUMBER;
17: l_address_request_id NUMBER;
18: l_lock_id NUMBER;
19: cursor l_cont_addr_cur is
20: select address_req_id from pos_cont_addr_requests
21: WHERE address_req_id = p_request_rec.address_request_id for update nowait;
22: l_cont_addr_rec l_cont_addr_cur%ROWTYPE;
23:
24: cursor l_address_note_cur is

Line 103: UPDATE pos_cont_addr_requests

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,
105: last_update_date = Sysdate,
106: last_updated_by = fnd_global.user_id,
107: last_update_login = fnd_global.login_id

Line 272: FROM pos_cont_addr_requests pcar,

268: pv.party_id,
269: pv.vendor_id,
270: pcr.contact_party_id,
271: pcar.party_site_id
272: FROM pos_cont_addr_requests pcar,
273: pos_contact_requests pcr,
274: pos_supplier_mappings psm,
275: po_vendors pv
276: WHERE pcar.contact_req_id = p_contact_request_id

Line 322: || ' in pos_cont_addr_requests table with cont_addr_request_id = '

318: ELSE
319: x_return_status := fnd_api.g_ret_sts_error;
320: x_msg_count := 1;
321: x_msg_data := 'invalid request type ' || l_rec.request_type
322: || ' in pos_cont_addr_requests table with cont_addr_request_id = '
323: || l_rec.cont_addr_request_id;
324: rollback to approve_cont_addr_requests;
325: RETURN;
326: END IF;

Line 329: UPDATE pos_cont_addr_requests

325: RETURN;
326: END IF;
327: END LOOP;
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

Line 336: FROM pos_cont_addr_requests pcar,

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,
338: pos_supplier_mappings psm,
339: po_vendors pv
340: WHERE pcar.contact_req_id = p_contact_request_id

Line 379: select contact_req_id from pos_cont_addr_requests

375: l_step VARCHAR2(100);
376: l_method VARCHAR2(30);
377: l_lock_id NUMBER;
378: cursor l_cont_addr_cur is
379: select contact_req_id from pos_cont_addr_requests
380: WHERE contact_req_id = p_request_rec.contact_request_id for update nowait;
381: l_cont_addr_rec l_cont_addr_cur%ROWTYPE;
382:
383: BEGIN

Line 493: UPDATE pos_cont_addr_requests

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

Line 1341: select address_req_id from pos_cont_addr_requests

1337: )
1338: IS
1339: l_lock_id number;
1340: cursor l_cont_addr_cur is
1341: select address_req_id from pos_cont_addr_requests
1342: WHERE address_req_id = p_request_id for update nowait;
1343: l_cont_addr_rec l_cont_addr_cur%ROWTYPE;
1344:
1345: BEGIN

Line 1374: UPDATE pos_cont_addr_requests

1370: last_updated_by = fnd_global.user_id,
1371: last_update_login = fnd_global.login_id
1372: WHERE address_request_id = p_request_id;
1373:
1374: UPDATE pos_cont_addr_requests
1375: SET request_status = 'REJECTED',
1376: last_update_date = Sysdate,
1377: last_updated_by = fnd_global.user_id,
1378: last_update_login = fnd_global.login_id

Line 1423: update pos_cont_addr_requests

1419: raise_application_error(-20084, x_msg_data, true);
1420: END;
1421:
1422: -- Bug # 5192274, the address requests should also be rejected
1423: update pos_cont_addr_requests
1424: set request_status = 'REJECTED',
1425: last_update_date = sysdate,
1426: last_updated_by = fnd_global.user_id,
1427: last_update_login = fnd_global.login_id

Line 2466: select CONT_ADDR_REQUEST_ID into l_lock_id from pos_cont_addr_requests

2462: BEGIN
2463:
2464: for i in 1..p_req_id_tbl.COUNT LOOP
2465:
2466: select CONT_ADDR_REQUEST_ID into l_lock_id from pos_cont_addr_requests
2467: WHERE PARTY_SITE_ID = p_req_id_tbl(i)
2468: and REQUEST_STATUS = 'PENDING'
2469: and CONTACT_REQ_ID = p_cont_req_id for update nowait;
2470:

Line 2486: UPDATE pos_cont_addr_requests

2482: END;
2483:
2484: for i in 1..p_req_id_tbl.COUNT LOOP
2485:
2486: UPDATE pos_cont_addr_requests
2487: SET request_status = 'REJECTED'
2488: WHERE PARTY_SITE_ID = p_req_id_tbl(i)
2489: and REQUEST_STATUS = 'PENDING'
2490: and CONTACT_REQ_ID = p_cont_req_id;

Line 2673: select address_req_id from pos_cont_addr_requests

2669: IS
2670:
2671: l_lock_id number;
2672: cursor l_cont_addr_cur is
2673: select address_req_id from pos_cont_addr_requests
2674: where address_req_id = p_request_id for update nowait;
2675: l_cont_addr_rec l_cont_addr_cur%ROWTYPE;
2676:
2677: BEGIN

Line 2709: UPDATE pos_cont_addr_requests

2705: last_updated_by = fnd_global.user_id,
2706: last_update_login = fnd_global.login_id
2707: WHERE address_request_id = p_request_id;
2708:
2709: UPDATE pos_cont_addr_requests
2710: SET party_site_id = p_party_site_id,
2711: last_update_date = Sysdate,
2712: last_updated_by = fnd_global.user_id,
2713: last_update_login = fnd_global.login_id

Line 2771: from pos_cont_addr_requests

2767: l_rec_req_type VARCHAR2(10);
2768: cursor req_rec_exists(p_mapping_id IN NUMBER,p_cont_party_id IN NUMBER, p_cont_req_id IN NUMBER,p_addr_req_id IN NUMBER,p_party_site_id IN NUMBER, p_req_type IN VARCHAR2)
2769: is
2770: select cont_addr_request_id
2771: from pos_cont_addr_requests
2772: where mapping_id = p_mapping_id
2773: and nvl(contact_party_id, -1) = nvl(p_cont_party_id, -1)
2774: and nvl(contact_req_id, -1) = nvl(p_cont_req_id, -1)
2775: and nvl(ADDRESS_REQ_ID, -1) = nvl(p_addr_req_id, -1)

Line 2804: update pos_cont_addr_requests

2800: LOOP
2801: fetch req_rec_exists into l_req_rec_exists_rec;
2802: EXIT WHEN req_rec_exists%NOTFOUND;
2803: x_return_status := 'Y';
2804: update pos_cont_addr_requests
2805: set request_status = 'DELETED'
2806: where cont_addr_request_id = l_req_rec_exists_rec.cont_addr_request_id;
2807: END LOOP;
2808: close req_rec_exists;