DBA Data[Home] [Help]

APPS.POS_PROFILE_CHANGE_REQUEST_PKG dependencies on PO_TBL_NUMBER

Line 1545: ( p_req_id_tbl IN po_tbl_number,

1541:
1542: END reject_ps_req;
1543:
1544: PROCEDURE reject_mult_address_reqs
1545: ( p_req_id_tbl IN po_tbl_number,
1546: x_return_status OUT nocopy VARCHAR2,
1547: x_msg_count OUT nocopy NUMBER,
1548: x_msg_data OUT nocopy VARCHAR2
1549: )

Line 1603: ( p_req_id_tbl IN po_tbl_number,

1599:
1600: END reject_mult_address_reqs;
1601:
1602: PROCEDURE reject_mult_contact_reqs
1603: ( p_req_id_tbl IN po_tbl_number,
1604: x_return_status OUT nocopy VARCHAR2,
1605: x_msg_count OUT nocopy NUMBER,
1606: x_msg_data OUT nocopy VARCHAR2
1607: )

Line 1662: ( p_req_id_tbl IN po_tbl_number,

1658:
1659: END reject_mult_contact_reqs;
1660:
1661: PROCEDURE reject_mult_bus_class_reqs
1662: ( p_req_id_tbl IN po_tbl_number,
1663: x_return_status OUT nocopy VARCHAR2,
1664: x_msg_count OUT nocopy NUMBER,
1665: x_msg_data OUT nocopy VARCHAR2
1666: )

Line 1723: ( p_req_id_tbl IN po_tbl_number,

1719:
1720: END reject_mult_bus_class_reqs;
1721:
1722: PROCEDURE reject_mult_ps_reqs
1723: ( p_req_id_tbl IN po_tbl_number,
1724: x_return_status OUT nocopy VARCHAR2,
1725: x_msg_count OUT nocopy NUMBER,
1726: x_msg_data OUT nocopy VARCHAR2
1727: )

Line 1782: ( p_req_id_tbl IN po_tbl_number,

1778:
1779: END reject_mult_ps_reqs;
1780:
1781: PROCEDURE approve_mult_address_reqs
1782: ( p_req_id_tbl IN po_tbl_number,
1783: x_return_status OUT nocopy VARCHAR2,
1784: x_msg_count OUT nocopy NUMBER,
1785: x_msg_data OUT nocopy VARCHAR2
1786: )

Line 1841: ( p_req_id_tbl IN po_tbl_number,

1837:
1838: END approve_mult_address_reqs;
1839:
1840: PROCEDURE approve_mult_contact_reqs
1841: ( p_req_id_tbl IN po_tbl_number,
1842: x_return_status OUT nocopy VARCHAR2,
1843: x_msg_count OUT nocopy NUMBER,
1844: x_msg_data OUT nocopy VARCHAR2
1845: )

Line 2006: ( p_req_id_tbl IN po_tbl_number,

2002:
2003: END approve_mult_contact_reqs;
2004:
2005: PROCEDURE approve_mult_bus_class_reqs
2006: ( p_req_id_tbl IN po_tbl_number,
2007: x_return_status OUT nocopy VARCHAR2,
2008: x_msg_count OUT nocopy NUMBER,
2009: x_msg_data OUT nocopy VARCHAR2
2010: )

Line 2064: ( p_req_id_tbl IN po_tbl_number,

2060:
2061: END approve_mult_bus_class_reqs;
2062:
2063: PROCEDURE approve_mult_ps_reqs
2064: ( p_req_id_tbl IN po_tbl_number,
2065: x_return_status OUT nocopy VARCHAR2,
2066: x_msg_count OUT nocopy NUMBER,
2067: x_msg_data OUT nocopy VARCHAR2
2068: )

Line 2132: l_req_id_tbl po_tbl_number;

2128: x_msg_count OUT NOCOPY NUMBER,
2129: x_msg_data OUT NOCOPY VARCHAR2
2130: )
2131: IS
2132: l_req_id_tbl po_tbl_number;
2133: l_lock_id NUMBER;
2134: BEGIN
2135: savepoint approve_update_mult_bc_reqs;
2136:

Line 2158: l_req_id_tbl := PO_TBL_NUMBER();

2154: END IF;
2155: raise_application_error(-20064, x_msg_data, true);
2156: END;
2157:
2158: l_req_id_tbl := PO_TBL_NUMBER();
2159:
2160: for i in 1..p_pos_bus_rec_tbl.COUNT LOOP
2161:
2162: UPDATE pos_bus_class_reqs

Line 2448: p_req_id_tbl IN po_tbl_number,

2444: END chg_contact_req_approval;
2445:
2446: PROCEDURE reject_mult_cont_addr_reqs
2447: ( p_cont_req_id IN NUMBER,
2448: p_req_id_tbl IN po_tbl_number,
2449: x_return_status OUT nocopy VARCHAR2,
2450: x_msg_count OUT nocopy NUMBER,
2451: x_msg_data OUT nocopy VARCHAR2
2452: )

Line 2613: ( p_site_id_tbl IN po_tbl_number,

2609: END new_contact_req_approval;
2610:
2611:
2612: PROCEDURE assign_mult_address_to_contact
2613: ( p_site_id_tbl IN po_tbl_number,
2614: p_cont_party_id IN NUMBER,
2615: p_vendor_id IN NUMBER,
2616: x_return_status OUT nocopy VARCHAR2,
2617: x_msg_count OUT nocopy NUMBER,

Line 2641: ( p_req_id_tbl IN po_tbl_number,

2637: x_return_status := FND_API.G_RET_STS_SUCCESS;
2638: END assign_mult_address_to_contact;
2639:
2640: PROCEDURE assign_user_sec_attr
2641: ( p_req_id_tbl IN po_tbl_number,
2642: p_usr_id IN NUMBER,
2643: p_code_name IN VARCHAR2,
2644: x_return_status OUT nocopy VARCHAR2,
2645: x_msg_count OUT nocopy NUMBER,