DBA Data[Home] [Help]

APPS.POS_PROFILE_CHANGE_REQUEST_PKG dependencies on PO_TBL_NUMBER

Line 1599: ( p_req_id_tbl IN po_tbl_number,

1595:
1596: END reject_ps_req;
1597:
1598: PROCEDURE reject_mult_address_reqs
1599: ( p_req_id_tbl IN po_tbl_number,
1600: x_return_status OUT nocopy VARCHAR2,
1601: x_msg_count OUT nocopy NUMBER,
1602: x_msg_data OUT nocopy VARCHAR2
1603: )

Line 1657: ( p_req_id_tbl IN po_tbl_number,

1653:
1654: END reject_mult_address_reqs;
1655:
1656: PROCEDURE reject_mult_contact_reqs
1657: ( p_req_id_tbl IN po_tbl_number,
1658: x_return_status OUT nocopy VARCHAR2,
1659: x_msg_count OUT nocopy NUMBER,
1660: x_msg_data OUT nocopy VARCHAR2
1661: )

Line 1716: ( p_req_id_tbl IN po_tbl_number,

1712:
1713: END reject_mult_contact_reqs;
1714:
1715: PROCEDURE reject_mult_bus_class_reqs
1716: ( p_req_id_tbl IN po_tbl_number,
1717: x_return_status OUT nocopy VARCHAR2,
1718: x_msg_count OUT nocopy NUMBER,
1719: x_msg_data OUT nocopy VARCHAR2
1720: )

Line 1777: ( p_req_id_tbl IN po_tbl_number,

1773:
1774: END reject_mult_bus_class_reqs;
1775:
1776: PROCEDURE reject_mult_ps_reqs
1777: ( p_req_id_tbl IN po_tbl_number,
1778: x_return_status OUT nocopy VARCHAR2,
1779: x_msg_count OUT nocopy NUMBER,
1780: x_msg_data OUT nocopy VARCHAR2
1781: )

Line 1836: ( p_req_id_tbl IN po_tbl_number,

1832:
1833: END reject_mult_ps_reqs;
1834:
1835: PROCEDURE approve_mult_address_reqs
1836: ( p_req_id_tbl IN po_tbl_number,
1837: x_return_status OUT nocopy VARCHAR2,
1838: x_msg_count OUT nocopy NUMBER,
1839: x_msg_data OUT nocopy VARCHAR2
1840: )

Line 1895: ( p_req_id_tbl IN po_tbl_number,

1891:
1892: END approve_mult_address_reqs;
1893:
1894: PROCEDURE approve_mult_contact_reqs
1895: ( p_req_id_tbl IN po_tbl_number,
1896: x_return_status OUT nocopy VARCHAR2,
1897: x_msg_count OUT nocopy NUMBER,
1898: x_msg_data OUT nocopy VARCHAR2
1899: )

Line 2060: ( p_req_id_tbl IN po_tbl_number,

2056:
2057: END approve_mult_contact_reqs;
2058:
2059: PROCEDURE approve_mult_bus_class_reqs
2060: ( p_req_id_tbl IN po_tbl_number,
2061: x_return_status OUT nocopy VARCHAR2,
2062: x_msg_count OUT nocopy NUMBER,
2063: x_msg_data OUT nocopy VARCHAR2
2064: )

Line 2118: ( p_req_id_tbl IN po_tbl_number,

2114:
2115: END approve_mult_bus_class_reqs;
2116:
2117: PROCEDURE approve_mult_ps_reqs
2118: ( p_req_id_tbl IN po_tbl_number,
2119: x_return_status OUT nocopy VARCHAR2,
2120: x_msg_count OUT nocopy NUMBER,
2121: x_msg_data OUT nocopy VARCHAR2
2122: )

Line 2186: l_req_id_tbl po_tbl_number;

2182: x_msg_count OUT NOCOPY NUMBER,
2183: x_msg_data OUT NOCOPY VARCHAR2
2184: )
2185: IS
2186: l_req_id_tbl po_tbl_number;
2187: l_lock_id NUMBER;
2188: BEGIN
2189: savepoint approve_update_mult_bc_reqs;
2190:

Line 2212: l_req_id_tbl := PO_TBL_NUMBER();

2208: END IF;
2209: raise_application_error(-20064, x_msg_data, true);
2210: END;
2211:
2212: l_req_id_tbl := PO_TBL_NUMBER();
2213:
2214: for i in 1..p_pos_bus_rec_tbl.COUNT LOOP
2215:
2216: UPDATE pos_bus_class_reqs

Line 2512: p_req_id_tbl IN po_tbl_number,

2508: END chg_contact_req_approval;
2509:
2510: PROCEDURE reject_mult_cont_addr_reqs
2511: ( p_cont_req_id IN NUMBER,
2512: p_req_id_tbl IN po_tbl_number,
2513: x_return_status OUT nocopy VARCHAR2,
2514: x_msg_count OUT nocopy NUMBER,
2515: x_msg_data OUT nocopy VARCHAR2
2516: )

Line 2687: ( p_site_id_tbl IN po_tbl_number,

2683: END new_contact_req_approval;
2684:
2685:
2686: PROCEDURE assign_mult_address_to_contact
2687: ( p_site_id_tbl IN po_tbl_number,
2688: p_cont_party_id IN NUMBER,
2689: p_vendor_id IN NUMBER,
2690: x_return_status OUT nocopy VARCHAR2,
2691: x_msg_count OUT nocopy NUMBER,

Line 2715: ( p_req_id_tbl IN po_tbl_number,

2711: x_return_status := FND_API.G_RET_STS_SUCCESS;
2712: END assign_mult_address_to_contact;
2713:
2714: PROCEDURE assign_user_sec_attr
2715: ( p_req_id_tbl IN po_tbl_number,
2716: p_usr_id IN NUMBER,
2717: p_code_name IN VARCHAR2,
2718: x_return_status OUT nocopy VARCHAR2,
2719: x_msg_count OUT nocopy NUMBER,