1 PACKAGE PAY_BEE_SS AUTHID CURRENT_USER as
2 /* $Header: pybeess.pkh 120.0.12020000.2 2013/03/22 09:05:11 bklingam noship $*/
3
4 procedure create_batch(p_batch_name in varchar2 default null
5 ,p_effective_date in varchar2 default null
6 ,p_action_if_exists in varchar2 default null
7 ,p_date_effective_changes in varchar2 default null
8 ,p_purge_after_transfer in varchar2 default null
9 ,p_reject_if_future_changes in varchar2 default null
10 ,p_item_key in varchar2
11 ,p_activity_id in varchar2
12 ,p_login_person_id in number
13 ,p_business_group_id in number
14 ,p_batch_status_flag in varchar2 default 'Unprocessed'
15 );
16
17
18
19
20 procedure create_batch_assignment_lines( p_element_name in varchar2,
21 p_element_type in varchar2,
22 p_effective_date in varchar2,
23 p_batch_name in varchar2,
24 p_employee_name in varchar2,
25 p_assignment_no in varchar2,
26 p_iterator in varchar2,
27 p_costing_id in varchar2,
28 p_delete_flag in varchar2 default 'N'
29 ,p_assignment_id in varchar2
30 ,p_login_person_id in number );
31
32 procedure create_batch_element_lines( p_element_name in varchar2,
33 p_element_type in varchar2,
34 p_effective_date in varchar2,
35 p_batch_name in varchar2,
36 p_employee_name in varchar2,
37 p_assignment_no in varchar2,
38 p_iterator in varchar2,
39 p_costing_id in varchar2,
40 p_element_id in varchar2,
41 p_delete_flag in varchar2 default 'N'
42 ,p_login_person_id in number
43 );
44 procedure set_input_values(p_input_value_name in varchar2,
45 p_input_value in varchar2,
46 p_iterator in varchar2,
47 p_element_name in varchar2,
48 p_assignment_no in varchar2,
49 p_login_person_id in number );
50
51 procedure set_element_input_values(p_input_value_name in varchar2,
52 p_input_value in varchar2,
53 p_iterator in varchar2,
54 p_login_person_id in number );
55
56
57 function get_transaction_id_batch_name(p_batch_name in varchar2) return number;
58
59 function get_item_key return number;
60 procedure set_item_key(p_item_key in number);
61 procedure update_delete_flag(p_transaction_id in number,p_name in varchar2);
62 procedure update_batch_header_table(p_batch_name in varchar2,
63 p_business_group_id in number);
64
65 procedure update_batch_lines_table(p_batch_name in varchar2,
66 p_business_group_id in number);
67
68 procedure update_element_lines_table(p_batch_name in varchar2,
69 p_business_group_id in number);
70
71 procedure validate_batch(errbuf OUT nocopy VARCHAR2, retcode OUT nocopy NUMBER,p_batch_name in varchar2,p_business_group_id in number);
72 procedure call_validate_batch(p_batch_name in varchar2,p_business_group_id in number);
73
74 procedure get_previous_page
75 (itemtype in varchar2
76 ,itemkey in varchar2
77 ,actid in number
78 ,funmode in varchar2
79 ,result out nocopy varchar2
80 );
81
82 procedure release_approval_block(p_item_key in varchar2);
83
84 procedure update_transaction_id(p_item_key in varchar2,p_batch_name in varchar2,p_login_person_id in number);
85
86 procedure delete_assignment_information(p_batch_name in varchar2,p_assignment_no in varchar2);
87
88 PROCEDURE process_api
89 (p_validate in boolean default false
90 ,p_transaction_step_id in number
91 ,p_effective_date in varchar2 default null
92 );
93
94 procedure transfer_batch(errbuf OUT nocopy VARCHAR2, retcode OUT nocopy NUMBER,p_batch_name in varchar2,p_business_group_id in number);
95
96 PROCEDURE process_dummy_api
97 (p_validate in boolean default false
98 ,p_transaction_step_id in number
99 ,p_effective_date in varchar2 default null
100 );
101
102 procedure delete_batch_on_cancel(p_batch_name in varchar2);
103
104 END PAY_BEE_SS;
[Home] [Help]