[Home] [Help]
PACKAGE: APPS.BEN_TCS_STMT_PROCESS
Source
1 PACKAGE BEN_TCS_STMT_PROCESS
2 /* $Header: bentcssg.pkh 120.2 2007/09/21 07:46:02 vkodedal noship $ */
3 AUTHID CURRENT_USER AS
4 TYPE g_rep_rec IS RECORD (
5 P_TYPE NUMBER(15),
6 BENEFIT_ACTION_ID NUMBER(15),
7 ASSIGNMENT_NUMBER VARCHAR2(30),
8 EMPLOYEE_NUMBER VARCHAR2(30),
9 JOB_NAME VARCHAR2(240),
10 BUSINESS_GROUP_ID NUMBER(15),
11 BUSINESS_GROUP_NAME VARCHAR2(240),
12 FULL_NAME VARCHAR2(240),
13 STMT_CREATED VARCHAR2(30),
14 ERROR VARCHAR2(2000),
15 ELIGY_ID NUMBER(15),
16 ELIGY_PROF_NAME VARCHAR2(240),
17 STMT_ID NUMBER(15),
18 STMT_NAME VARCHAR2(240),
19 SETUP_VALID VARCHAR2(30),
20 TOTAL_PERSONS NUMBER(15),
21 BEN_TCS_RPT_DET_ID NUMBER(15),
22 ASSIGNMENT_ID NUMBER(15),
23 PERSON_ID NUMBER(15),
24 PERIOD_ID NUMBER(15)
25 );
26
27 TYPE g_rep_rec_tab IS TABLE OF g_rep_rec
28 INDEX BY BINARY_INTEGER;
29
30
31 PROCEDURE do_multithread (
32 errbuf OUT NOCOPY VARCHAR2,
33 retcode OUT NOCOPY NUMBER,
34 p_validate IN VARCHAR2 DEFAULT 'N',
35 p_benefit_action_id IN NUMBER,
36 p_thread_id IN NUMBER,
37 p_effective_date IN VARCHAR2,
38 p_audit_log IN VARCHAR2 DEFAULT 'N',
39 p_run_type IN VARCHAR2,
40 p_start_date IN DATE,
41 p_end_date IN DATE
42 );
43
44 PROCEDURE process (
45 errbuf OUT NOCOPY VARCHAR2,
46 retcode OUT NOCOPY NUMBER,
47 p_validate IN VARCHAR2 DEFAULT 'N',
48 p_run_type IN VARCHAR2,
49 p_stmt_name IN VARCHAR2,
50 p_stmt_id IN VARCHAR2 ,
51 p_person_id IN VARCHAR2 DEFAULT NULL,
52 p_period_id IN VARCHAR2 ,
53 p_partial_end IN VARCHAR2 DEFAULT NULL,
54 p_audit_log IN VARCHAR2 DEFAULT 'Y',
55 p_business_group_id IN NUMBER DEFAULT NULL,
56 p_org_id IN NUMBER DEFAULT NULL,
57 p_location_id IN NUMBER DEFAULT NULL,
58 p_ben_grp_id IN NUMBER DEFAULT NULL,
59 p_payroll_id IN NUMBER DEFAULT NULL,
60 p_job_id IN NUMBER DEFAULT NULL,
61 p_position_id IN NUMBER DEFAULT NULL,
62 p_supervisor_id IN NUMBER DEFAULT NULL
63 );
64 END BEN_TCS_STMT_PROCESS;
65