1 package ben_process_user_ss_api AUTHID CURRENT_USER AS
2 /* $Header: benusrwf.pkh 115.7 2002/12/23 13:22:49 rpgupta noship $*/
3 --
4 -- Global constants
5 g_column_delimiter constant varchar2(3) := '~^|';
6 g_user_process_seq number default null;
7 --
8 -- ---------------------------------------------------------------------------
9 -- Purpose: This procedure will get transaction data which are pending for
10 -- approval in workflow for a transaction step id.
11 -- This is the procedure which does the actual work.
12 -- ---------------------------------------------------------------------------
13 procedure get_user_data_from_tt
14 (p_transaction_step_id in number
15 ,p_user_name out nocopy varchar2
16 ,p_user_pswd out nocopy varchar2
17 ,p_pswd_hint out nocopy varchar2
18 ,p_owner out nocopy varchar2
19 ,p_session_number out nocopy number
20 ,p_start_date out nocopy date
21 ,p_end_date out nocopy date
22 ,p_last_logon_date out nocopy date
23 ,p_password_date out nocopy date
24 ,p_password_accesses_left out nocopy number
25 ,p_password_lifespan_accesses out nocopy number
26 ,p_password_lifespan_days out nocopy number
27 ,p_employee_id out nocopy number
28 ,p_email_address out nocopy varchar2
29 ,p_fax out nocopy varchar2
30 ,p_customer_id out nocopy number
31 ,p_supplier_id out nocopy number
32 ,p_business_group_id out nocopy number
33 ,p_respons_id out nocopy number
34 ,p_respons_appl_id out nocopy number
35 );
36 --
37 -- ---------------------------------------------------------------------------
38 -- ------------------------- < update_user_details > -------------------------
39 -- ---------------------------------------------------------------------------
40 -- Purpose: This procedure will perform validations when a user presses Next
41 -- on user page or on the Review page.
42 -- Either case, the data will be saved to the transaction table.
43 -- If this procedure is invoked from Review page, it will first check
44 -- that if a transaction already exists. If it does, it will update
45 -- the current transaction record.
46 -- NOTE: The p_validate_mode cannot be in boolean because this
47 -- procedure will be called from Java which has a different
48 -- boolean value from pl/sql.
49 -- ---------------------------------------------------------------------------
50 procedure update_user_details
51 (p_item_type in varchar2
52 ,p_item_key in varchar2
53 ,p_actid in number
54 ,p_login_person_id in number
55 ,p_process_section_name in varchar2
56 ,p_review_page_region_code in varchar2
57 ,p_user_name in varchar2
58 ,p_owner in varchar2
59 ,p_unencrypted_password in varchar2
60 ,p_session_number in number
61 ,p_start_date in date
62 ,p_end_date in date
63 ,p_last_logon_date in date
64 ,p_description in varchar2
65 ,p_password_date in date
66 ,p_password_accesses_left in number
67 ,p_password_lifespan_accesses in number
68 ,p_password_lifespan_days in number
69 ,p_employee_id in number
70 ,p_email_address in varchar2
71 ,p_fax in varchar2
72 ,p_customer_id in number
73 ,p_supplier_id in number
74 ,p_business_group_id in number
75 );
76 --
77 -- ---------------------------------------------------------------------------
78 -- ---------------------- < create_user_details> -------------------------
79 -- ---------------------------------------------------------------------------
80 -- Purpose: This procedure does have user hooks and actually calls fnd_user_pkg to do inserts.
81 -- ---------------------------------------------------------------------------
82 procedure create_user_details
83 (p_validate in boolean default false
84 ,p_user_name in varchar2
85 ,p_owner in varchar2 default null
86 ,p_unencrypted_password in varchar2
87 ,p_session_number in number default 0
88 ,p_start_date in date default sysdate
89 ,p_end_date in date default null
90 ,p_last_logon_date in date default null
91 ,p_description in varchar2 default null
92 ,p_password_date in date default sysdate
93 ,p_password_accesses_left in number default null
94 ,p_password_lifespan_accesses in number default null
95 ,p_password_lifespan_days in number default null
96 ,p_employee_id in number default null
97 ,p_email_address in varchar2 default null
98 ,p_fax in varchar2 default null
99 ,p_customer_id in number default null
100 ,p_supplier_id in number default null
101 ,p_business_group_id in number default null
102 ,p_responsibility_id in number default null
103 ,p_respons_application_id in number default null
104 ,p_api_error out nocopy boolean
105 ,p_user_id out nocopy number
106 );
107 -- ---------------------------------------------------------------------------
108 -- ---------------------------------------------------------------------------
109 -- ----------------------------- < process_api > -----------------------------
110 -- ---------------------------------------------------------------------------
111 -- Purpose: This procedure will be invoked in workflow notification
112 -- when an approver approves all the changes. This procedure
113 -- will call the api to update to the database with p_validate
114 -- equal to false.
115 -- ---------------------------------------------------------------------------
116 procedure process_api
117 (p_validate in boolean default false
118 ,p_transaction_step_id in number);
119 --
120 -- ---------------------------------------------------------------------------
121 end ben_process_user_ss_api;
122 --