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_SBD_PKG dependencies on POS_ACNT_ADDR_SUMM_REQ

Line 106: FROM pos_acnt_addr_req req, pos_acnt_addr_summ_req summ

102: CURSOR l_assign_req_cur IS
103: SELECT req.assignment_request_id, summ.assignment_id, summ.priority,
104: req.request_type, req.mapping_id, req.party_site_id,
105: req.address_request_id, req.object_version_number
106: FROM pos_acnt_addr_req req, pos_acnt_addr_summ_req summ
107: where req.assignment_request_id = summ.assignment_request_id
108: AND summ.account_request_id = p_account_request_id for update nowait;
109:
110: l_assign_req_rec l_assign_req_cur%ROWTYPE;

Line 122: FROM pos_acnt_addr_summ_req

118: -- Assignment Details
119: CURSOR l_assign_req_detail_below_cur IS
120: SELECT assignment_id, priority, start_date, end_date,
121: ext_bank_account_id, account_request_id, assignment_status
122: FROM pos_acnt_addr_summ_req
123: where assignment_request_id = l_assignment_request_id
124: and priority > l_priority for update nowait;
125: l_assign_req_det_below_rec l_assign_req_detail_below_cur%ROWTYPE;
126:

Line 129: FROM pos_acnt_addr_summ_req

125: l_assign_req_det_below_rec l_assign_req_detail_below_cur%ROWTYPE;
126:
127: CURSOR l_assign_req_detail_above_cur IS
128: SELECT assignment_id, priority
129: FROM pos_acnt_addr_summ_req
130: where assignment_request_id = l_assignment_request_id
131: and priority < l_priority;
132: l_assign_req_detail_above_rec l_assign_req_detail_above_cur%ROWTYPE;
133:

Line 135: select summ.assignment_id from pos_acnt_addr_summ_req summ

131: and priority < l_priority;
132: l_assign_req_detail_above_rec l_assign_req_detail_above_cur%ROWTYPE;
133:
134: CURSOR l_need_to_del_cur is
135: select summ.assignment_id from pos_acnt_addr_summ_req summ
136: where assignment_request_id = l_assignment_request_id
137: and assignment_status = 'CURRENT'
138: and not exists(select 1 from pos_acnt_addr_summ_req
139: where assignment_request_id = l_assignment_request_id

Line 138: and not exists(select 1 from pos_acnt_addr_summ_req

134: CURSOR l_need_to_del_cur is
135: select summ.assignment_id from pos_acnt_addr_summ_req summ
136: where assignment_request_id = l_assignment_request_id
137: and assignment_status = 'CURRENT'
138: and not exists(select 1 from pos_acnt_addr_summ_req
139: where assignment_request_id = l_assignment_request_id
140: and assignment_status <> 'CURRENT');
141: l_need_to_del_rec l_need_to_del_cur%ROWTYPE;
142: BEGIN

Line 202: -- Update the priorities in POS_ACNT_ADDR_SUMM_REQ

198: , x_status => x_status
199: , x_exception_msg => x_exception_msg
200: );
201:
202: -- Update the priorities in POS_ACNT_ADDR_SUMM_REQ
203: -- Delete the row in the POS_ACNT_ADDR_SUMM_REQ
204: l_step := 5;
205:
206: for l_assign_req_rec in l_assign_req_cur loop

Line 203: -- Delete the row in the POS_ACNT_ADDR_SUMM_REQ

199: , x_exception_msg => x_exception_msg
200: );
201:
202: -- Update the priorities in POS_ACNT_ADDR_SUMM_REQ
203: -- Delete the row in the POS_ACNT_ADDR_SUMM_REQ
204: l_step := 5;
205:
206: for l_assign_req_rec in l_assign_req_cur loop
207:

Line 218: -- Update the priority in POS_ACNT_ADDR_SUMM_REQ

214:
215: for l_assign_req_det_below_rec in l_assign_req_detail_below_cur loop
216: l_step := 7;
217:
218: -- Update the priority in POS_ACNT_ADDR_SUMM_REQ
219: POS_SBD_PKG.supplier_update_assignment(
220: p_assignment_id => l_assign_req_det_below_rec.assignment_id
221: , p_assignment_request_id => l_assign_req_rec.assignment_request_id
222: , p_object_version_number => l_assign_req_rec.object_version_number

Line 240: -- Delete the row in POS_ACNT_ADDR_SUMM_REQ

236: l_needToDelete := false;
237: end loop;
238:
239: l_step := 8;
240: -- Delete the row in POS_ACNT_ADDR_SUMM_REQ
241: l_assignment_id := l_assign_req_rec.assignment_id;
242:
243: POS_SBD_TBL_PKG.del_row_pos_acnt_summ_req (
244: p_assignment_id => l_assignment_id

Line 887: -- update all the records in POS_ACNT_ADDR_SUMM_REQ with the account id

883: , x_status => x_status
884: , x_exception_msg => x_exception_msg
885: );
886:
887: -- update all the records in POS_ACNT_ADDR_SUMM_REQ with the account id
888: update pos_acnt_addr_summ_req
889: set account_request_id = x_account_request_id
890: where ext_bank_account_id = p_ext_bank_account_id;
891:

Line 888: update pos_acnt_addr_summ_req

884: , x_exception_msg => x_exception_msg
885: );
886:
887: -- update all the records in POS_ACNT_ADDR_SUMM_REQ with the account id
888: update pos_acnt_addr_summ_req
889: set account_request_id = x_account_request_id
890: where ext_bank_account_id = p_ext_bank_account_id;
891:
892: end if;

Line 1395: update pos_acnt_addr_summ_req

1391: );
1392:
1393: l_step := 7;
1394:
1395: update pos_acnt_addr_summ_req
1396: set account_request_id = null,
1397: last_update_date = sysdate,
1398: last_updated_by = fnd_global.user_id,
1399: last_update_login = fnd_global.login_id

Line 1447: select assignment_id from pos_acnt_addr_summ_req

1443:
1444: l_step number;
1445:
1446: cursor l_addr_summ_req_cur is
1447: select assignment_id from pos_acnt_addr_summ_req
1448: where assignment_request_id = p_assignment_request_id for update nowait;
1449:
1450: l_addr_summ_req_rec l_addr_summ_req_cur%ROWTYPE;
1451:

Line 1465: -- Remove all the rows in the POS_ACNT_ADDR_SUMM_REQ

1461: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1462: ' p_party_id ' || p_party_id);
1463: END IF;
1464:
1465: -- Remove all the rows in the POS_ACNT_ADDR_SUMM_REQ
1466: for l_addr_summ_req_rec in l_addr_summ_req_cur loop
1467:
1468: l_step := 2;
1469: POS_SBD_TBL_PKG.del_row_pos_acnt_summ_req (

Line 1528: select * from pos_acnt_addr_summ_req

1524: l_request_type POS_ACNT_ADDR_REQ.request_type%TYPE;
1525: l_request_status POS_ACNT_ADDR_REQ.request_status%TYPE;
1526:
1527: cursor l_acnt_req_summ_cur is
1528: select * from pos_acnt_addr_summ_req
1529: where assignment_request_id = p_assignment_request_id
1530: order by priority for update nowait;
1531: l_acnt_req_summ_rec l_acnt_req_summ_cur%ROWTYPE;
1532:

Line 1533: l_assignment_status POS_ACNT_ADDR_SUMM_REQ.assignment_status%TYPE;

1529: where assignment_request_id = p_assignment_request_id
1530: order by priority for update nowait;
1531: l_acnt_req_summ_rec l_acnt_req_summ_cur%ROWTYPE;
1532:
1533: l_assignment_status POS_ACNT_ADDR_SUMM_REQ.assignment_status%TYPE;
1534: l_ext_bank_account_id POS_ACNT_ADDR_SUMM_REQ.ext_bank_account_id%TYPE;
1535: l_assignment_id POS_ACNT_ADDR_SUMM_REQ.assignment_id%TYPE;
1536: l_party_site_id HZ_PARTY_SITES.party_site_id%TYPE;
1537: l_address_request_id POS_ACNT_ADDR_REQ.address_request_id%TYPE;

Line 1534: l_ext_bank_account_id POS_ACNT_ADDR_SUMM_REQ.ext_bank_account_id%TYPE;

1530: order by priority for update nowait;
1531: l_acnt_req_summ_rec l_acnt_req_summ_cur%ROWTYPE;
1532:
1533: l_assignment_status POS_ACNT_ADDR_SUMM_REQ.assignment_status%TYPE;
1534: l_ext_bank_account_id POS_ACNT_ADDR_SUMM_REQ.ext_bank_account_id%TYPE;
1535: l_assignment_id POS_ACNT_ADDR_SUMM_REQ.assignment_id%TYPE;
1536: l_party_site_id HZ_PARTY_SITES.party_site_id%TYPE;
1537: l_address_request_id POS_ACNT_ADDR_REQ.address_request_id%TYPE;
1538: l_end_date POS_ACNT_ADDR_SUMM_REQ.end_date%TYPE;

Line 1535: l_assignment_id POS_ACNT_ADDR_SUMM_REQ.assignment_id%TYPE;

1531: l_acnt_req_summ_rec l_acnt_req_summ_cur%ROWTYPE;
1532:
1533: l_assignment_status POS_ACNT_ADDR_SUMM_REQ.assignment_status%TYPE;
1534: l_ext_bank_account_id POS_ACNT_ADDR_SUMM_REQ.ext_bank_account_id%TYPE;
1535: l_assignment_id POS_ACNT_ADDR_SUMM_REQ.assignment_id%TYPE;
1536: l_party_site_id HZ_PARTY_SITES.party_site_id%TYPE;
1537: l_address_request_id POS_ACNT_ADDR_REQ.address_request_id%TYPE;
1538: l_end_date POS_ACNT_ADDR_SUMM_REQ.end_date%TYPE;
1539: l_start_date POS_ACNT_ADDR_SUMM_REQ.start_date%TYPE;

Line 1538: l_end_date POS_ACNT_ADDR_SUMM_REQ.end_date%TYPE;

1534: l_ext_bank_account_id POS_ACNT_ADDR_SUMM_REQ.ext_bank_account_id%TYPE;
1535: l_assignment_id POS_ACNT_ADDR_SUMM_REQ.assignment_id%TYPE;
1536: l_party_site_id HZ_PARTY_SITES.party_site_id%TYPE;
1537: l_address_request_id POS_ACNT_ADDR_REQ.address_request_id%TYPE;
1538: l_end_date POS_ACNT_ADDR_SUMM_REQ.end_date%TYPE;
1539: l_start_date POS_ACNT_ADDR_SUMM_REQ.start_date%TYPE;
1540: l_priority POS_ACNT_ADDR_SUMM_REQ.priority%TYPE;
1541: l_payee_assignment_id number;
1542: l_msg_count number;

Line 1539: l_start_date POS_ACNT_ADDR_SUMM_REQ.start_date%TYPE;

1535: l_assignment_id POS_ACNT_ADDR_SUMM_REQ.assignment_id%TYPE;
1536: l_party_site_id HZ_PARTY_SITES.party_site_id%TYPE;
1537: l_address_request_id POS_ACNT_ADDR_REQ.address_request_id%TYPE;
1538: l_end_date POS_ACNT_ADDR_SUMM_REQ.end_date%TYPE;
1539: l_start_date POS_ACNT_ADDR_SUMM_REQ.start_date%TYPE;
1540: l_priority POS_ACNT_ADDR_SUMM_REQ.priority%TYPE;
1541: l_payee_assignment_id number;
1542: l_msg_count number;
1543:

Line 1540: l_priority POS_ACNT_ADDR_SUMM_REQ.priority%TYPE;

1536: l_party_site_id HZ_PARTY_SITES.party_site_id%TYPE;
1537: l_address_request_id POS_ACNT_ADDR_REQ.address_request_id%TYPE;
1538: l_end_date POS_ACNT_ADDR_SUMM_REQ.end_date%TYPE;
1539: l_start_date POS_ACNT_ADDR_SUMM_REQ.start_date%TYPE;
1540: l_priority POS_ACNT_ADDR_SUMM_REQ.priority%TYPE;
1541: l_payee_assignment_id number;
1542: l_msg_count number;
1543:
1544: BEGIN

Line 1675: -- Delete the row in POS_ACNT_ADDR_SUMM_REQ

1671: l_step := 5;
1672: raise_application_error(-20029, 'IBY Failed to create assignment ' || x_exception_msg, true);
1673: end if;
1674:
1675: -- Delete the row in POS_ACNT_ADDR_SUMM_REQ
1676: POS_SBD_TBL_PKG.del_row_pos_acnt_summ_req (
1677: p_assignment_id => l_assignment_id
1678: , x_status => x_status
1679: , x_exception_msg => x_exception_msg

Line 1724: select 1 from pos_acnt_addr_summ_req poss, pos_acnt_addr_req req

1720:
1721: l_number number;
1722:
1723: cursor assign_exists_cur is
1724: select 1 from pos_acnt_addr_summ_req poss, pos_acnt_addr_req req
1725: where poss.assignment_request_id = req.assignment_request_id
1726: and req.mapping_id = p_mapping_id
1727: and ( (poss.account_request_id = p_account_request_id
1728: and poss.account_request_id is not null and p_account_request_id is not null) OR

Line 1855: l_assignment_status pos_acnt_addr_summ_req.assignment_status%TYPE;

1851: )
1852: IS
1853:
1854: l_step NUMBER;
1855: l_assignment_status pos_acnt_addr_summ_req.assignment_status%TYPE;
1856:
1857: l_start_date pos_acnt_addr_summ_req.start_date%TYPE;
1858: l_end_date pos_acnt_addr_summ_req.end_date%TYPE;
1859: l_priority pos_acnt_addr_summ_req.priority%TYPE;

Line 1857: l_start_date pos_acnt_addr_summ_req.start_date%TYPE;

1853:
1854: l_step NUMBER;
1855: l_assignment_status pos_acnt_addr_summ_req.assignment_status%TYPE;
1856:
1857: l_start_date pos_acnt_addr_summ_req.start_date%TYPE;
1858: l_end_date pos_acnt_addr_summ_req.end_date%TYPE;
1859: l_priority pos_acnt_addr_summ_req.priority%TYPE;
1860: l_f_priority pos_acnt_addr_summ_req.priority%TYPE;
1861: l_assignment_request_id pos_acnt_addr_summ_req.assignment_request_id%TYPE;

Line 1858: l_end_date pos_acnt_addr_summ_req.end_date%TYPE;

1854: l_step NUMBER;
1855: l_assignment_status pos_acnt_addr_summ_req.assignment_status%TYPE;
1856:
1857: l_start_date pos_acnt_addr_summ_req.start_date%TYPE;
1858: l_end_date pos_acnt_addr_summ_req.end_date%TYPE;
1859: l_priority pos_acnt_addr_summ_req.priority%TYPE;
1860: l_f_priority pos_acnt_addr_summ_req.priority%TYPE;
1861: l_assignment_request_id pos_acnt_addr_summ_req.assignment_request_id%TYPE;
1862: l_assignment_id pos_acnt_addr_summ_req.assignment_id%TYPE;

Line 1859: l_priority pos_acnt_addr_summ_req.priority%TYPE;

1855: l_assignment_status pos_acnt_addr_summ_req.assignment_status%TYPE;
1856:
1857: l_start_date pos_acnt_addr_summ_req.start_date%TYPE;
1858: l_end_date pos_acnt_addr_summ_req.end_date%TYPE;
1859: l_priority pos_acnt_addr_summ_req.priority%TYPE;
1860: l_f_priority pos_acnt_addr_summ_req.priority%TYPE;
1861: l_assignment_request_id pos_acnt_addr_summ_req.assignment_request_id%TYPE;
1862: l_assignment_id pos_acnt_addr_summ_req.assignment_id%TYPE;
1863: l_c_assignment_id pos_acnt_addr_summ_req.assignment_id%TYPE;

Line 1860: l_f_priority pos_acnt_addr_summ_req.priority%TYPE;

1856:
1857: l_start_date pos_acnt_addr_summ_req.start_date%TYPE;
1858: l_end_date pos_acnt_addr_summ_req.end_date%TYPE;
1859: l_priority pos_acnt_addr_summ_req.priority%TYPE;
1860: l_f_priority pos_acnt_addr_summ_req.priority%TYPE;
1861: l_assignment_request_id pos_acnt_addr_summ_req.assignment_request_id%TYPE;
1862: l_assignment_id pos_acnt_addr_summ_req.assignment_id%TYPE;
1863: l_c_assignment_id pos_acnt_addr_summ_req.assignment_id%TYPE;
1864: l_snapshot_created varchar2(1);

Line 1861: l_assignment_request_id pos_acnt_addr_summ_req.assignment_request_id%TYPE;

1857: l_start_date pos_acnt_addr_summ_req.start_date%TYPE;
1858: l_end_date pos_acnt_addr_summ_req.end_date%TYPE;
1859: l_priority pos_acnt_addr_summ_req.priority%TYPE;
1860: l_f_priority pos_acnt_addr_summ_req.priority%TYPE;
1861: l_assignment_request_id pos_acnt_addr_summ_req.assignment_request_id%TYPE;
1862: l_assignment_id pos_acnt_addr_summ_req.assignment_id%TYPE;
1863: l_c_assignment_id pos_acnt_addr_summ_req.assignment_id%TYPE;
1864: l_snapshot_created varchar2(1);
1865:

Line 1862: l_assignment_id pos_acnt_addr_summ_req.assignment_id%TYPE;

1858: l_end_date pos_acnt_addr_summ_req.end_date%TYPE;
1859: l_priority pos_acnt_addr_summ_req.priority%TYPE;
1860: l_f_priority pos_acnt_addr_summ_req.priority%TYPE;
1861: l_assignment_request_id pos_acnt_addr_summ_req.assignment_request_id%TYPE;
1862: l_assignment_id pos_acnt_addr_summ_req.assignment_id%TYPE;
1863: l_c_assignment_id pos_acnt_addr_summ_req.assignment_id%TYPE;
1864: l_snapshot_created varchar2(1);
1865:
1866: cursor l_supplier_assign_cur is

Line 1863: l_c_assignment_id pos_acnt_addr_summ_req.assignment_id%TYPE;

1859: l_priority pos_acnt_addr_summ_req.priority%TYPE;
1860: l_f_priority pos_acnt_addr_summ_req.priority%TYPE;
1861: l_assignment_request_id pos_acnt_addr_summ_req.assignment_request_id%TYPE;
1862: l_assignment_id pos_acnt_addr_summ_req.assignment_id%TYPE;
1863: l_c_assignment_id pos_acnt_addr_summ_req.assignment_id%TYPE;
1864: l_snapshot_created varchar2(1);
1865:
1866: cursor l_supplier_assign_cur is
1867:

Line 1884: select assignment_id from pos_acnt_addr_summ_req req

1880: and sysdate between NVL(act.start_date,sysdate) AND NVL(act.end_date,sysdate)
1881: and act.ext_bank_account_id = p_ext_bank_account_id;
1882:
1883: cursor l_exist_assign_req_cur is
1884: select assignment_id from pos_acnt_addr_summ_req req
1885: where assignment_request_id = l_assignment_request_id
1886: and ((ext_bank_account_id = p_ext_bank_account_id and ext_bank_account_id is not null and p_ext_bank_account_id is not null) OR
1887: (account_request_id = p_account_request_id and account_request_id is not null and p_account_request_id is not null and p_ext_bank_account_id is null));
1888:

Line 1944: from pos_acnt_addr_summ_req summ, pos_acnt_addr_req req

1940:
1941:
1942: cursor l_max_priority_cur is
1943: select max(summ.priority)
1944: from pos_acnt_addr_summ_req summ, pos_acnt_addr_req req
1945: where req.mapping_id = p_mapping_id
1946: and req.assignment_request_id = summ.assignment_request_id
1947: and ((req.party_site_id = p_party_site_id and req.party_site_id is
1948: not null and p_party_site_id is not null)

Line 2330: update pos_acnt_addr_summ_req

2326: , x_status => x_status
2327: , x_exception_msg => x_exception_msg
2328: );
2329:
2330: update pos_acnt_addr_summ_req
2331: set account_request_id = null
2332: where account_request_id = p_account_request_id;
2333:
2334: l_ntf_status := 'REJECTED';

Line 2502: and not exists (select 1 from pos_acnt_addr_summ_req summ

2498: (addr.request_type = 'ADDRESS' and addr.party_site_id = p_party_site_id and p_party_site_id is not null and addr.party_site_id is not null) OR
2499: (addr.request_type = 'ADDRESS' and addr.address_request_id = p_address_request_id and p_address_request_id is not null and addr.address_request_id is not null)
2500: )
2501: and addr.REQUEST_STATUS = 'PENDING'
2502: and not exists (select 1 from pos_acnt_addr_summ_req summ
2503: where addr.assignment_request_id = summ.assignment_request_id
2504: and summ.assignment_status <> ('CURRENT')
2505: and rownum = 1);
2506:

Line 2508: select assignment_id from pos_acnt_addr_summ_req

2504: and summ.assignment_status <> ('CURRENT')
2505: and rownum = 1);
2506:
2507: cursor l_assignment_id_cur is
2508: select assignment_id from pos_acnt_addr_summ_req
2509: where assignment_request_id = l_assignment_request_id;
2510:
2511: l_assignment_id_rec l_assignment_id_cur%ROWTYPE;
2512: