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 498: UPDATE pos_cont_addr_requests

494: last_updated_by = fnd_global.user_id,
495: last_update_login = fnd_global.login_id
496: WHERE contact_request_id = p_request_rec.contact_request_id;
497:
498: UPDATE pos_cont_addr_requests
499: SET contact_party_id = l_person_party_id,
500: last_update_date = Sysdate,
501: last_updated_by = fnd_global.user_id,
502: last_update_login = fnd_global.login_id

Line 1395: select address_req_id from pos_cont_addr_requests

1391: )
1392: IS
1393: l_lock_id number;
1394: cursor l_cont_addr_cur is
1395: select address_req_id from pos_cont_addr_requests
1396: WHERE address_req_id = p_request_id for update nowait;
1397: l_cont_addr_rec l_cont_addr_cur%ROWTYPE;
1398:
1399: BEGIN

Line 1428: UPDATE pos_cont_addr_requests

1424: last_updated_by = fnd_global.user_id,
1425: last_update_login = fnd_global.login_id
1426: WHERE address_request_id = p_request_id;
1427:
1428: UPDATE pos_cont_addr_requests
1429: SET request_status = 'REJECTED',
1430: last_update_date = Sysdate,
1431: last_updated_by = fnd_global.user_id,
1432: last_update_login = fnd_global.login_id

Line 1477: update pos_cont_addr_requests

1473: raise_application_error(-20084, x_msg_data, true);
1474: END;
1475:
1476: -- Bug # 5192274, the address requests should also be rejected
1477: update pos_cont_addr_requests
1478: set request_status = 'REJECTED',
1479: last_update_date = sysdate,
1480: last_updated_by = fnd_global.user_id,
1481: last_update_login = fnd_global.login_id

Line 2530: select CONT_ADDR_REQUEST_ID into l_lock_id from pos_cont_addr_requests

2526: BEGIN
2527:
2528: for i in 1..p_req_id_tbl.COUNT LOOP
2529:
2530: select CONT_ADDR_REQUEST_ID into l_lock_id from pos_cont_addr_requests
2531: WHERE PARTY_SITE_ID = p_req_id_tbl(i)
2532: and REQUEST_STATUS = 'PENDING'
2533: and CONTACT_REQ_ID = p_cont_req_id for update nowait;
2534:

Line 2550: UPDATE pos_cont_addr_requests

2546: END;
2547:
2548: for i in 1..p_req_id_tbl.COUNT LOOP
2549:
2550: UPDATE pos_cont_addr_requests
2551: SET request_status = 'REJECTED'
2552: WHERE PARTY_SITE_ID = p_req_id_tbl(i)
2553: and REQUEST_STATUS = 'PENDING'
2554: and CONTACT_REQ_ID = p_cont_req_id;

Line 2747: select address_req_id from pos_cont_addr_requests

2743: IS
2744:
2745: l_lock_id number;
2746: cursor l_cont_addr_cur is
2747: select address_req_id from pos_cont_addr_requests
2748: where address_req_id = p_request_id for update nowait;
2749: l_cont_addr_rec l_cont_addr_cur%ROWTYPE;
2750:
2751: BEGIN

Line 2783: UPDATE pos_cont_addr_requests

2779: last_updated_by = fnd_global.user_id,
2780: last_update_login = fnd_global.login_id
2781: WHERE address_request_id = p_request_id;
2782:
2783: UPDATE pos_cont_addr_requests
2784: SET party_site_id = p_party_site_id,
2785: last_update_date = Sysdate,
2786: last_updated_by = fnd_global.user_id,
2787: last_update_login = fnd_global.login_id

Line 2845: from pos_cont_addr_requests

2841: l_rec_req_type VARCHAR2(10);
2842: 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)
2843: is
2844: select cont_addr_request_id
2845: from pos_cont_addr_requests
2846: where mapping_id = p_mapping_id
2847: and nvl(contact_party_id, -1) = nvl(p_cont_party_id, -1)
2848: and nvl(contact_req_id, -1) = nvl(p_cont_req_id, -1)
2849: and nvl(ADDRESS_REQ_ID, -1) = nvl(p_addr_req_id, -1)

Line 2878: update pos_cont_addr_requests

2874: LOOP
2875: fetch req_rec_exists into l_req_rec_exists_rec;
2876: EXIT WHEN req_rec_exists%NOTFOUND;
2877: x_return_status := 'Y';
2878: update pos_cont_addr_requests
2879: set request_status = 'DELETED'
2880: where cont_addr_request_id = l_req_rec_exists_rec.cont_addr_request_id;
2881: END LOOP;
2882: close req_rec_exists;