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_USER_ADMIN_PKG dependencies on PO_TBL_NUMBER

Line 229: , p_resp_ids IN po_tbl_number

225: END grant_user_resp;
226:
227: procedure grant_user_resps
228: ( p_user_id IN NUMBER
229: , p_resp_ids IN po_tbl_number
230: , p_resp_app_ids IN po_tbl_number
231: , x_return_status OUT NOCOPY VARCHAR2
232: , x_msg_count OUT NOCOPY NUMBER
233: , x_msg_data OUT NOCOPY VARCHAR2

Line 230: , p_resp_app_ids IN po_tbl_number

226:
227: procedure grant_user_resps
228: ( p_user_id IN NUMBER
229: , p_resp_ids IN po_tbl_number
230: , p_resp_app_ids IN po_tbl_number
231: , x_return_status OUT NOCOPY VARCHAR2
232: , x_msg_count OUT NOCOPY NUMBER
233: , x_msg_data OUT NOCOPY VARCHAR2
234: )

Line 299: , p_resp_ids IN po_tbl_number

295: END revoke_user_resp;
296:
297: procedure revoke_user_resps
298: ( p_user_id IN NUMBER
299: , p_resp_ids IN po_tbl_number
300: , p_resp_app_ids IN po_tbl_number
301: , x_return_status OUT NOCOPY VARCHAR2
302: , x_msg_count OUT NOCOPY NUMBER
303: , x_msg_data OUT NOCOPY VARCHAR2

Line 300: , p_resp_app_ids IN po_tbl_number

296:
297: procedure revoke_user_resps
298: ( p_user_id IN NUMBER
299: , p_resp_ids IN po_tbl_number
300: , p_resp_app_ids IN po_tbl_number
301: , x_return_status OUT NOCOPY VARCHAR2
302: , x_msg_count OUT NOCOPY NUMBER
303: , x_msg_data OUT NOCOPY VARCHAR2
304: )

Line 711: p_resp_ids IN po_tbl_number,

707: PROCEDURE create_supplier_user_account
708: (p_user_name IN VARCHAR2,
709: p_user_email IN VARCHAR2,
710: p_person_party_id IN NUMBER,
711: p_resp_ids IN po_tbl_number,
712: p_resp_app_ids IN po_tbl_number,
713: p_sec_attr_codes IN po_tbl_varchar30,
714: p_sec_attr_numbers IN po_tbl_number,
715: p_password IN VARCHAR2 DEFAULT NULL,

Line 712: p_resp_app_ids IN po_tbl_number,

708: (p_user_name IN VARCHAR2,
709: p_user_email IN VARCHAR2,
710: p_person_party_id IN NUMBER,
711: p_resp_ids IN po_tbl_number,
712: p_resp_app_ids IN po_tbl_number,
713: p_sec_attr_codes IN po_tbl_varchar30,
714: p_sec_attr_numbers IN po_tbl_number,
715: p_password IN VARCHAR2 DEFAULT NULL,
716: x_return_status OUT NOCOPY VARCHAR2,

Line 714: p_sec_attr_numbers IN po_tbl_number,

710: p_person_party_id IN NUMBER,
711: p_resp_ids IN po_tbl_number,
712: p_resp_app_ids IN po_tbl_number,
713: p_sec_attr_codes IN po_tbl_varchar30,
714: p_sec_attr_numbers IN po_tbl_number,
715: p_password IN VARCHAR2 DEFAULT NULL,
716: x_return_status OUT NOCOPY VARCHAR2,
717: x_msg_count OUT NOCOPY NUMBER,
718: x_msg_data OUT NOCOPY VARCHAR2,

Line 949: l_resp_ids po_tbl_number;

945: x_user_id OUT NOCOPY NUMBER,
946: x_password OUT NOCOPY VARCHAR2
947: )
948: IS
949: l_resp_ids po_tbl_number;
950: l_resp_app_ids po_tbl_number;
951: l_sec_attr_codes po_tbl_varchar30;
952: l_sec_attr_numbers po_tbl_number;
953: l_enterprise_name hz_parties.party_name%TYPE;

Line 950: l_resp_app_ids po_tbl_number;

946: x_password OUT NOCOPY VARCHAR2
947: )
948: IS
949: l_resp_ids po_tbl_number;
950: l_resp_app_ids po_tbl_number;
951: l_sec_attr_codes po_tbl_varchar30;
952: l_sec_attr_numbers po_tbl_number;
953: l_enterprise_name hz_parties.party_name%TYPE;
954: lv_exception_msg VARCHAR2(32000);

Line 952: l_sec_attr_numbers po_tbl_number;

948: IS
949: l_resp_ids po_tbl_number;
950: l_resp_app_ids po_tbl_number;
951: l_sec_attr_codes po_tbl_varchar30;
952: l_sec_attr_numbers po_tbl_number;
953: l_enterprise_name hz_parties.party_name%TYPE;
954: lv_exception_msg VARCHAR2(32000);
955: lv_status VARCHAR2(240);
956: l_itemtype wf_items.item_type%TYPE;

Line 962: l_resp_ids := po_tbl_number();

958: l_process wf_process_activities.process_name%TYPE;
959: l_user_in_oid VARCHAR2(1);
960:
961: BEGIN
962: l_resp_ids := po_tbl_number();
963: l_resp_app_ids := po_tbl_number();
964: l_sec_attr_codes := po_tbl_varchar30();
965: l_sec_attr_numbers := po_tbl_number();
966:

Line 963: l_resp_app_ids := po_tbl_number();

959: l_user_in_oid VARCHAR2(1);
960:
961: BEGIN
962: l_resp_ids := po_tbl_number();
963: l_resp_app_ids := po_tbl_number();
964: l_sec_attr_codes := po_tbl_varchar30();
965: l_sec_attr_numbers := po_tbl_number();
966:
967: /* Bug 5680160 Start */

Line 965: l_sec_attr_numbers := po_tbl_number();

961: BEGIN
962: l_resp_ids := po_tbl_number();
963: l_resp_app_ids := po_tbl_number();
964: l_sec_attr_codes := po_tbl_varchar30();
965: l_sec_attr_numbers := po_tbl_number();
966:
967: /* Bug 5680160 Start */
968: l_user_in_oid := 'N';
969: if (FND_USER_PKG.TestUserName(p_user_name) = FND_USER_PKG.USER_SYNCHED) then

Line 1074: l_resp_ids po_tbl_number;

1070: x_user_id OUT NOCOPY NUMBER,
1071: x_password OUT NOCOPY VARCHAR2
1072: )
1073: IS
1074: l_resp_ids po_tbl_number;
1075: l_resp_app_ids po_tbl_number;
1076: l_sec_attr_codes po_tbl_varchar30;
1077: l_sec_attr_numbers po_tbl_number;
1078: BEGIN

Line 1075: l_resp_app_ids po_tbl_number;

1071: x_password OUT NOCOPY VARCHAR2
1072: )
1073: IS
1074: l_resp_ids po_tbl_number;
1075: l_resp_app_ids po_tbl_number;
1076: l_sec_attr_codes po_tbl_varchar30;
1077: l_sec_attr_numbers po_tbl_number;
1078: BEGIN
1079: l_resp_ids := po_tbl_number();

Line 1077: l_sec_attr_numbers po_tbl_number;

1073: IS
1074: l_resp_ids po_tbl_number;
1075: l_resp_app_ids po_tbl_number;
1076: l_sec_attr_codes po_tbl_varchar30;
1077: l_sec_attr_numbers po_tbl_number;
1078: BEGIN
1079: l_resp_ids := po_tbl_number();
1080: l_resp_app_ids := po_tbl_number();
1081: l_sec_attr_codes := po_tbl_varchar30();

Line 1079: l_resp_ids := po_tbl_number();

1075: l_resp_app_ids po_tbl_number;
1076: l_sec_attr_codes po_tbl_varchar30;
1077: l_sec_attr_numbers po_tbl_number;
1078: BEGIN
1079: l_resp_ids := po_tbl_number();
1080: l_resp_app_ids := po_tbl_number();
1081: l_sec_attr_codes := po_tbl_varchar30();
1082: l_sec_attr_numbers := po_tbl_number();
1083:

Line 1080: l_resp_app_ids := po_tbl_number();

1076: l_sec_attr_codes po_tbl_varchar30;
1077: l_sec_attr_numbers po_tbl_number;
1078: BEGIN
1079: l_resp_ids := po_tbl_number();
1080: l_resp_app_ids := po_tbl_number();
1081: l_sec_attr_codes := po_tbl_varchar30();
1082: l_sec_attr_numbers := po_tbl_number();
1083:
1084: create_supplier_user_account

Line 1082: l_sec_attr_numbers := po_tbl_number();

1078: BEGIN
1079: l_resp_ids := po_tbl_number();
1080: l_resp_app_ids := po_tbl_number();
1081: l_sec_attr_codes := po_tbl_varchar30();
1082: l_sec_attr_numbers := po_tbl_number();
1083:
1084: create_supplier_user_account
1085: (p_user_name => p_user_name,
1086: p_user_email => p_user_email,