DBA Data[Home] [Help]

APPS.POS_USER_ADMIN_PKG dependencies on PO_TBL_VARCHAR30

Line 713: p_sec_attr_codes IN po_tbl_varchar30,

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,
717: x_msg_count OUT NOCOPY NUMBER,

Line 951: l_sec_attr_codes po_tbl_varchar30;

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);
955: lv_status VARCHAR2(240);

Line 964: l_sec_attr_codes := po_tbl_varchar30();

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 */
968: l_user_in_oid := 'N';

Line 1076: l_sec_attr_codes po_tbl_varchar30;

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();
1080: l_resp_app_ids := po_tbl_number();

Line 1081: 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
1085: (p_user_name => p_user_name,