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_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 250: -- Delete the row in POS_ACNT_ADDR_REQ if needed

246: , x_exception_msg => x_exception_msg
247: );
248:
249: l_step := 9;
250: -- Delete the row in POS_ACNT_ADDR_REQ if needed
251: if l_needToDelete = true then
252:
253: -- Check if there are any other rows left.
254: l_step := 10;

Line 259: POS_SBD_TBL_PKG.del_row_pos_acnt_addr_req (

255: open l_assign_req_detail_above_cur;
256: fetch l_assign_req_detail_above_cur into l_assign_req_detail_above_rec;
257: if l_assign_req_detail_above_cur%NOTFOUND then
258: l_step := 11;
259: POS_SBD_TBL_PKG.del_row_pos_acnt_addr_req (
260: p_assignment_request_id => l_assignment_request_id
261: , x_status => x_status
262: , x_exception_msg => x_exception_msg
263: );

Line 280: POS_SBD_TBL_PKG.del_row_pos_acnt_addr_req (

276: l_needToDelete := true;
277: end loop;
278:
279: if l_needToDelete = true then
280: POS_SBD_TBL_PKG.del_row_pos_acnt_addr_req (
281: p_assignment_request_id => l_assignment_request_id
282: , x_status => x_status
283: , x_exception_msg => x_exception_msg
284: );

Line 1477: -- Remove the rows in the POS_ACNT_ADDR_REQ

1473:
1474: end loop;
1475:
1476: l_step := 2;
1477: -- Remove the rows in the POS_ACNT_ADDR_REQ
1478: POS_SBD_TBL_PKG.del_row_pos_acnt_addr_req (
1479: p_assignment_request_id => p_assignment_request_id
1480: , x_status => x_status
1481: , x_exception_msg => x_exception_msg

Line 1478: POS_SBD_TBL_PKG.del_row_pos_acnt_addr_req (

1474: end loop;
1475:
1476: l_step := 2;
1477: -- Remove the rows in the POS_ACNT_ADDR_REQ
1478: POS_SBD_TBL_PKG.del_row_pos_acnt_addr_req (
1479: p_assignment_request_id => p_assignment_request_id
1480: , x_status => x_status
1481: , x_exception_msg => x_exception_msg
1482: );

Line 1517: select * from pos_acnt_addr_req

1513: l_pay_instr_rec IBY_FNDCPT_SETUP_PUB.PmtInstrument_rec_type;
1514: l_pay_assign_rec IBY_FNDCPT_SETUP_PUB.PmtInstrAssignment_rec_type;
1515:
1516: cursor l_acnt_req_cur is
1517: select * from pos_acnt_addr_req
1518: where assignment_request_id = p_assignment_request_id
1519: and object_version_number = p_object_version_number for update nowait;
1520: l_acnt_req_rec l_acnt_req_cur%ROWTYPE;
1521:

Line 1524: l_request_type POS_ACNT_ADDR_REQ.request_type%TYPE;

1520: l_acnt_req_rec l_acnt_req_cur%ROWTYPE;
1521:
1522: l_object_version_number number;
1523:
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

Line 1525: l_request_status POS_ACNT_ADDR_REQ.request_status%TYPE;

1521:
1522: l_object_version_number number;
1523:
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

Line 1537: l_address_request_id POS_ACNT_ADDR_REQ.address_request_id%TYPE;

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;
1540: l_priority POS_ACNT_ADDR_SUMM_REQ.priority%TYPE;
1541: l_payee_assignment_id number;

Line 1683: -- update the record in POS_ACNT_ADDR_REQ to Approved.

1679: , x_exception_msg => x_exception_msg
1680: );
1681: end loop;
1682:
1683: -- update the record in POS_ACNT_ADDR_REQ to Approved.
1684: l_step := 6;
1685:
1686: POS_SBD_TBL_PKG.del_row_pos_acnt_addr_req (
1687: p_assignment_request_id => p_assignment_request_id

Line 1686: POS_SBD_TBL_PKG.del_row_pos_acnt_addr_req (

1682:
1683: -- update the record in POS_ACNT_ADDR_REQ to Approved.
1684: l_step := 6;
1685:
1686: POS_SBD_TBL_PKG.del_row_pos_acnt_addr_req (
1687: p_assignment_request_id => p_assignment_request_id
1688: , x_status => x_status
1689: , x_exception_msg => x_exception_msg);
1690:

Line 1719: l_request_type POS_ACNT_ADDR_REQ.request_type%TYPE;

1715: )
1716: IS
1717:
1718: l_step number;
1719: l_request_type POS_ACNT_ADDR_REQ.request_type%TYPE;
1720:
1721: l_number number;
1722:
1723: cursor assign_exists_cur is

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 1907: select assignment_request_id from pos_acnt_addr_req

1903: and sysdate between NVL(act.start_date,sysdate) AND NVL(act.end_date,sysdate)
1904: and act.ext_bank_account_id = p_ext_bank_account_id;
1905:
1906: cursor l_supplier_req_cur is
1907: select assignment_request_id from pos_acnt_addr_req
1908: where request_type = 'SUPPLIER'
1909: and mapping_id = p_mapping_id
1910: and request_status = 'PENDING'
1911: and party_site_id is null

Line 1915: select assignment_request_id from pos_acnt_addr_req

1911: and party_site_id is null
1912: and address_request_id is null;
1913:
1914: cursor l_address_req_cur is
1915: select assignment_request_id from pos_acnt_addr_req
1916: where request_type = 'ADDRESS'
1917: and mapping_id = p_mapping_id
1918: and request_status = 'PENDING'
1919: and ( (address_request_id = p_address_request_id and address_request_id is not null and p_address_request_id is not null)

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 2009: POS_SBD_TBL_PKG.insert_row_pos_acnt_addr_req (

2005: if l_assignment_request_id is null then
2006:
2007: l_step := 5;
2008:
2009: POS_SBD_TBL_PKG.insert_row_pos_acnt_addr_req (
2010: p_mapping_id => p_mapping_id
2011: , p_request_type => p_request_type
2012: , p_party_site_id => p_party_site_id
2013: , p_address_request_id => p_address_request_id

Line 2494: select addr.assignment_request_id from pos_acnt_addr_req addr

2490: l_assignment_request_id number;
2491: l_assignment_id number;
2492:
2493: cursor l_is_all_current is
2494: select addr.assignment_request_id from pos_acnt_addr_req addr
2495: where addr.mapping_id = p_mapping_id
2496: and (
2497: (addr.request_type = 'SUPPLIER' and p_address_request_id is null and p_address_request_id is null) OR
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

Line 2552: POS_SBD_TBL_PKG.del_row_pos_acnt_addr_req (

2548:
2549: end loop;
2550: l_step := 4;
2551:
2552: POS_SBD_TBL_PKG.del_row_pos_acnt_addr_req (
2553: p_assignment_request_id => l_assignment_request_id
2554: , x_status => x_status
2555: , x_exception_msg => x_exception_msg
2556: );

Line 2599: update pos_acnt_addr_req

2595:
2596: x_status := 'S';
2597: l_step := 1;
2598:
2599: update pos_acnt_addr_req
2600: set party_site_id = p_party_site_id, address_request_id = null
2601: where address_request_id = p_address_request_id;
2602:
2603: l_step := 2;