APPS.POS_PROFILE_CHANGE_REQUEST_PKG dependencies on POS_ADDRESS_REQUESTS

Line 7: (p_request_rec IN pos_address_requests%ROWTYPE,

3:
4: g_module VARCHAR2(30) := 'POS_PROFILE_CHANGE_REQUEST_PKG';
5:
6: PROCEDURE approve_new_address_req
7: (p_request_rec IN pos_address_requests%ROWTYPE,
8: p_vendor_id IN NUMBER,
9: p_vendor_party_id IN NUMBER,
10: x_return_status OUT nocopy VARCHAR2,
11: x_msg_count OUT nocopy NUMBER,

Line 34: select address_request_id into l_lock_id from pos_address_requests

30: savepoint approve_new_address_req;
31: -- Lock the rows: This is done as part of ECO 5209555
32: BEGIN
33:
34: select address_request_id into l_lock_id from pos_address_requests
35: WHERE address_request_id = p_request_rec.address_request_id for update nowait;
36:
37: open l_cont_addr_cur;
38: fetch l_cont_addr_cur into l_cont_addr_rec;

Line 95: UPDATE pos_address_requests

91: UPDATE pos_address_notes
92: SET party_site_id = l_party_site_id
93: WHERE address_req_id = p_request_rec.address_request_id;
94:
95: UPDATE pos_address_requests
96: SET party_site_id = l_party_site_id,
97: request_status = 'APPROVED',
98: last_update_date = Sysdate,
99: last_updated_by = fnd_global.user_id,

Line 141: (p_request_rec IN pos_address_requests%ROWTYPE,

137:
138: END approve_new_address_req;
139:
140: PROCEDURE approve_update_address_req
141: (p_request_rec IN pos_address_requests%ROWTYPE,
142: p_vendor_id IN NUMBER,
143: p_vendor_party_id IN NUMBER,
144: x_return_status OUT nocopy VARCHAR2,
145: x_msg_count OUT nocopy NUMBER,

Line 175: select address_request_id into l_lock_id from pos_address_requests

171:
172: -- Lock the rows: This is done as part of ECO 5209555
173: BEGIN
174:
175: select address_request_id into l_lock_id from pos_address_requests
176: WHERE address_request_id = p_request_rec.address_request_id for update nowait;
177:
178: EXCEPTION
179:

Line 242: UPDATE pos_address_requests

238: x_msg_count => x_msg_count,
239: x_msg_data => x_msg_data
240: );
241:
242: UPDATE pos_address_requests
243: SET request_status = 'APPROVED',
244: last_update_date = Sysdate,
245: last_updated_by = fnd_global.user_id,
246: last_update_login = fnd_global.login_id

Line 819: FROM pos_address_requests

815: )
816: IS
817: CURSOR l_cur IS
818: SELECT *
819: FROM pos_address_requests
820: WHERE address_request_id = p_request_id FOR UPDATE NOWAIT;
821: -- ECO 5209555 Add the nowait clause
822:
823: l_rec l_cur%ROWTYPE;

Line 893: UPDATE pos_address_requests

889: );
890:
891: ELSIF l_rec.request_type = 'DELETE' then
892:
893: UPDATE pos_address_requests
894: SET request_status = 'APPROVED',
895: last_update_date = Sysdate,
896: last_updated_by = fnd_global.user_id,
897: last_update_login = fnd_global.login_id

Line 1403: select address_request_id into l_lock_id from pos_address_requests

1399: BEGIN
1400: savepoint reject_address_req;
1401: -- Lock the rows: This is done as part of ECO 5209555
1402: BEGIN
1403: select address_request_id into l_lock_id from pos_address_requests
1404: WHERE address_request_id = p_request_id for update nowait;
1405:
1406: open l_cont_addr_cur;
1407: fetch l_cont_addr_cur into l_cont_addr_rec;

Line 1421: UPDATE pos_address_requests

1417: END IF;
1418: raise_application_error(-20086, x_msg_data, true);
1419: END;
1420:
1421: UPDATE pos_address_requests
1422: SET request_status = 'REJECTED',
1423: last_update_date = Sysdate,
1424: last_updated_by = fnd_global.user_id,
1425: last_update_login = fnd_global.login_id

Line 1614: select address_request_id into l_lock_id from pos_address_requests

1610: -- Lock the rows: This is done as part of ECO 5209555
1611: BEGIN
1612: for i in 1..p_req_id_tbl.COUNT LOOP
1613:
1614: select address_request_id into l_lock_id from pos_address_requests
1615: WHERE address_request_id = p_req_id_tbl(i) for update nowait;
1616:
1617: END LOOP;
1618:

Line 1851: select address_request_id into l_lock_id from pos_address_requests

1847: -- Lock the rows: This is done as part of ECO 5209555
1848: BEGIN
1849: for i in 1..p_req_id_tbl.COUNT LOOP
1850:
1851: select address_request_id into l_lock_id from pos_address_requests
1852: WHERE address_request_id = p_req_id_tbl(i) for update nowait;
1853:
1854: END LOOP;
1855:

Line 2283: select ADDRESS_REQUEST_ID into l_lock_id from POS_ADDRESS_REQUESTS

2279:
2280: savepoint chg_address_req_approval;
2281: -- Lock the rows: This is done as part of ECO 5209555
2282: BEGIN
2283: select ADDRESS_REQUEST_ID into l_lock_id from POS_ADDRESS_REQUESTS
2284: WHERE ADDRESS_REQUEST_ID = p_request_id for update nowait;
2285: EXCEPTION
2286:
2287: WHEN OTHERS THEN

Line 2300: UPDATE POS_ADDRESS_REQUESTS

2296: x_return_status := FND_API.G_RET_STS_SUCCESS;
2297:
2298: l_step := 1;
2299:
2300: UPDATE POS_ADDRESS_REQUESTS
2301: SET PARTY_SITE_NAME = p_party_site_name,
2302: COUNTRY = p_country,
2303: ADDRESS_LINE1 = p_address_line1,
2304: ADDRESS_LINE2 = p_address_line2,

Line 2344: from pos_address_requests

2340: if p_status = 'I' then
2341:
2342: select party_site_id
2343: into l_party_site_id
2344: from pos_address_requests
2345: where address_request_id = p_request_id;
2346:
2347: l_step := 4;
2348:

Line 2757: select address_request_id into l_lock_id from pos_address_requests

2753:
2754: -- Lock the rows: This is done as part of ECO 5209555
2755: BEGIN
2756:
2757: select address_request_id into l_lock_id from pos_address_requests
2758: WHERE address_request_id = p_request_id for update nowait;
2759:
2760: open l_cont_addr_cur;
2761: fetch l_cont_addr_cur into l_cont_addr_rec;

Line 2775: UPDATE pos_address_requests

2771: END IF;
2772: raise_application_error(-20056, x_msg_data, true);
2773: END;
2774:
2775: UPDATE pos_address_requests
2776: SET request_status = p_req_status,
2777: PARTY_SITE_ID = p_party_site_id,
2778: last_update_date = Sysdate,
2779: last_updated_by = fnd_global.user_id,