[Home] [Help]
PACKAGE: APPS.HXT_BATCH_PROCESS
Source
1 PACKAGE hxt_batch_process AS
2 /* $Header: hxtbat.pkh 120.4 2007/10/19 11:43:05 asrajago noship $ */
3
4 g_user_id fnd_user.user_id%TYPE := FND_GLOBAL.User_Id; -- SPR C163 by BC
5
6 --
7 /********Bug: 4620315 **********/
8
9 TYPE merge_batches_type_rec IS RECORD (batch_id pay_batch_headers.batch_id%TYPE,
10 tc_id hxt_timecards_f.id%TYPE,
11 valid_tc_retcode number,
12 tc_rowid varchar2(500),
13 for_person_id hxt_timecards_f.for_person_id%TYPE,
14 time_period_id hxt_timecards_f.time_period_id%TYPE,
15 auto_gen_flag hxt_timecards_f.auto_gen_flag%TYPE,
16 approv_person_id hxt_timecards_f.approv_person_id%TYPE,
17 approved_timestamp hxt_timecards_f.approved_timestamp%TYPE,
18 created_by hxt_timecards_f.created_by%TYPE,
19 creation_date hxt_timecards_f.creation_date%TYPE,
20 last_updated_by hxt_timecards_f.last_updated_by%TYPE,
21 last_update_date hxt_timecards_f.last_update_date%TYPE,
22 last_update_login hxt_timecards_f.last_update_login%TYPE,
23 payroll_id hxt_timecards_f.payroll_id%TYPE,
24 status hxt_timecards_f.status%TYPE,
25 effective_start_date hxt_timecards_f.effective_start_date%TYPE,
26 effective_end_date hxt_timecards_f.effective_end_date%TYPE,
27 object_version_number hxt_timecards_f.object_version_number%TYPE
28 ); /*** To record the validated timecards details ***/
29
30 TYPE merge_batches_type_table IS TABLE OF merge_batches_type_rec
31 INDEX BY BINARY_INTEGER;
32
33 TYPE del_empty_batches_type_rec IS RECORD (batch_id pay_batch_headers.batch_id%TYPE,
34 batch_ovn pay_batch_headers.object_version_number%TYPE
35 ); /*** To record the empty batches detail ***/
36
37 TYPE del_empty_batches_type_table IS TABLE OF del_empty_batches_type_rec
38 INDEX BY BINARY_INTEGER;
39
40 FUNCTION merge_batches
41 RETURN fnd_profile_option_values.profile_option_value%TYPE;
42
43 PROCEDURE merge_batches (p_merge_batch_name VARCHAR2,
44 p_merge_batches MERGE_BATCHES_TYPE_TABLE,
45 p_del_empty_batches DEL_EMPTY_BATCHES_TYPE_TABLE,
46 p_bus_group_id NUMBER,
47 p_mode VARCHAR2
48 );
49
50 /********Bug: 4620315 **********/
51
52 PROCEDURE Main_Process (
53 errbuf OUT NOCOPY VARCHAR2,
54 retcode OUT NOCOPY NUMBER,
55 p_payroll_id IN NUMBER,
56 p_date_earned IN VARCHAR2,
57 p_time_period_id IN NUMBER DEFAULT NULL,
58 p_from_batch_num IN NUMBER DEFAULT NULL,
59 p_to_batch_num IN NUMBER DEFAULT NULL,
60 p_ref_num IN VARCHAR2 DEFAULT NULL,
61 p_process_mode IN VARCHAR2,
62 p_bus_group_id IN NUMBER,
63 p_merge_flag IN VARCHAR2 DEFAULT '0',
64 p_merge_batch_name IN VARCHAR2 DEFAULT NULL,
65 p_merge_batch_specified IN VARCHAR2 DEFAULT null);
66 --
67 FUNCTION get_lookup_code (p_meaning IN VARCHAR2,
68 p_date_active IN DATE)
69 RETURN VARCHAR2;
70 --
71 PROCEDURE sum_to_mix (p_batch_id IN NUMBER,
72 p_time_period_id IN NUMBER,
73 p_sum_retcode IN OUT NOCOPY NUMBER);
74 --
75 PROCEDURE Transfer_To_Payroll( p_batch_id IN NUMBER
76 , p_payroll_id IN VARCHAR2
77 , p_batch_status IN VARCHAR2
78 , p_ref_num IN VARCHAR2
79 , p_process_mode IN VARCHAR2
80 , p_pay_retcode IN OUT NOCOPY NUMBER);
81
82
83 PROCEDURE Set_Batch_Status(p_date_earned DATE,
84 p_batch_id IN NUMBER, p_status IN VARCHAR2);
85
86 PROCEDURE rollback_paymix(p_batch_id IN NUMBER, p_time_period_id IN NUMBER,
87 p_rollback_retcode OUT NOCOPY NUMBER);
88
89 PROCEDURE Insert_Pay_Batch_Errors( p_batch_id IN NUMBER,
90 p_error_level IN VARCHAR2,
91 p_exception_details IN VARCHAR2,
92 p_return_code OUT NOCOPY NUMBER);
93 PROCEDURE Del_Prior_Errors( p_batch_id NUMBER );
94 PROCEDURE CALL_GEN_ERROR2 ( p_batch_id IN NUMBER
95 , p_tim_id IN NUMBER
96 , p_hrw_id IN NUMBER
97 , p_time_period_id IN NUMBER
98 , p_error_msg IN VARCHAR2
99 , p_loc IN VARCHAR2
100 , p_sql_err IN VARCHAR2
101 , p_TYPE IN VARCHAR2);
102
103 PROCEDURE dtl_to_bee ( p_values_rec IN HXT_BATCH_VALUES_V%ROWTYPE ,
104 p_sum_retcode IN OUT NOCOPY NUMBER,
105 p_batch_sequence IN NUMBER ) ;
106
107 END hxt_batch_process;