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 905: l_sec_attr_codes po_tbl_varchar30;

901: )
902: IS
903: l_resp_ids po_tbl_number;
904: l_resp_app_ids po_tbl_number;
905: l_sec_attr_codes po_tbl_varchar30;
906: l_sec_attr_numbers po_tbl_number;
907: l_enterprise_name hz_parties.party_name%TYPE;
908: lv_exception_msg VARCHAR2(32000);
909: lv_status VARCHAR2(240);

Line 918: l_sec_attr_codes := po_tbl_varchar30();

914:
915: BEGIN
916: l_resp_ids := po_tbl_number();
917: l_resp_app_ids := po_tbl_number();
918: l_sec_attr_codes := po_tbl_varchar30();
919: l_sec_attr_numbers := po_tbl_number();
920:
921: /* Bug 5680160 Start */
922: l_user_in_oid := 'N';

Line 1016: l_sec_attr_codes po_tbl_varchar30;

1012: )
1013: IS
1014: l_resp_ids po_tbl_number;
1015: l_resp_app_ids po_tbl_number;
1016: l_sec_attr_codes po_tbl_varchar30;
1017: l_sec_attr_numbers po_tbl_number;
1018: BEGIN
1019: l_resp_ids := po_tbl_number();
1020: l_resp_app_ids := po_tbl_number();

Line 1021: l_sec_attr_codes := po_tbl_varchar30();

1017: l_sec_attr_numbers po_tbl_number;
1018: BEGIN
1019: l_resp_ids := po_tbl_number();
1020: l_resp_app_ids := po_tbl_number();
1021: l_sec_attr_codes := po_tbl_varchar30();
1022: l_sec_attr_numbers := po_tbl_number();
1023:
1024: create_supplier_user_account
1025: (p_user_name => p_user_name,