eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_TCS_STMT_PROCESS dependencies on BEN_TCS_STMT

Line 1: PACKAGE BODY BEN_TCS_STMT_PROCESS as

1: PACKAGE BODY BEN_TCS_STMT_PROCESS as
2: /* $Header: bentcssg.pkb 120.23.12020000.3 2013/02/05 06:48:16 sgnanama ship $ */
3: g_package VARCHAR2 (80) := 'BEN_TCS_STMT_PROCESS';
4: g_proc VARCHAR2 (80);
5: g_actn VARCHAR2 (2000);

Line 3: g_package VARCHAR2 (80) := 'BEN_TCS_STMT_PROCESS';

1: PACKAGE BODY BEN_TCS_STMT_PROCESS as
2: /* $Header: bentcssg.pkb 120.23.12020000.3 2013/02/05 06:48:16 sgnanama ship $ */
3: g_package VARCHAR2 (80) := 'BEN_TCS_STMT_PROCESS';
4: g_proc VARCHAR2 (80);
5: g_actn VARCHAR2 (2000);
6: g_run_type VARCHAR2(30);
7: g_validate VARCHAR2(1);

Line 10: item_hrchy_values BEN_TCS_STMT_VALID_HRCHY.cat_item_hrchy_table ;

6: g_run_type VARCHAR2(30);
7: g_validate VARCHAR2(1);
8: l_rep_rec g_rep_rec_tab ;
9:
10: item_hrchy_values BEN_TCS_STMT_VALID_HRCHY.cat_item_hrchy_table ;
11: subcat_hrchy_values BEN_TCS_STMT_VALID_HRCHY.cat_subcat_hrchy_table ;
12:
13: TYPE g_number_type IS VARRAY (200) OF NUMBER;
14: TYPE g_exceution_params_rec IS RECORD (

Line 11: subcat_hrchy_values BEN_TCS_STMT_VALID_HRCHY.cat_subcat_hrchy_table ;

7: g_validate VARCHAR2(1);
8: l_rep_rec g_rep_rec_tab ;
9:
10: item_hrchy_values BEN_TCS_STMT_VALID_HRCHY.cat_item_hrchy_table ;
11: subcat_hrchy_values BEN_TCS_STMT_VALID_HRCHY.cat_subcat_hrchy_table ;
12:
13: TYPE g_number_type IS VARRAY (200) OF NUMBER;
14: TYPE g_exceution_params_rec IS RECORD (
15: Number_Of_BGs NUMBER (15),

Line 77: FROM ben_tcs_per_stmt_perd per_perd, ben_tcs_stmt_perd perd

73: p_period_end_date IN DATE,
74: p_stmt_id IN NUMBER)
75: IS
76: SELECT per_perd.stmt_id
77: FROM ben_tcs_per_stmt_perd per_perd, ben_tcs_stmt_perd perd
78: WHERE per_perd.stmt_id <> p_stmt_id
79: AND per_perd.person_id = p_person_id
80: AND per_perd.end_date = p_period_end_date
81: AND perd.stmt_perd_id = per_perd.stmt_perd_id

Line 407: UPDATE BEN_TCS_STMT

403: IF (c_stmt_period%FOUND) THEN
404: IF (stmt_perd_rec.stmt_id IS NOT NULL ) THEN
405: -- WRITE('Updating the statement generated flag .Stmt Id :'|| stmt_perd_rec.stmt_id );
406: hr_utility.set_location('Updating the statement generated flag .Stmt Id : ',52);
407: UPDATE BEN_TCS_STMT
408: SET stmt_generated_flag = 'Y'
409: WHERE stmt_id = stmt_perd_rec.stmt_id ;
410: END IF;
411: IF (stmt_perd_rec.stmt_perd_id IS NOT NULL ) THEN

Line 414: UPDATE BEN_TCS_STMT_PERD

410: END IF;
411: IF (stmt_perd_rec.stmt_perd_id IS NOT NULL ) THEN
412: --WRITE('Updating the statement generated flag .Stmt Period Id :'|| stmt_perd_rec.stmt_perd_id );
413: hr_utility.set_location('Updating the statement generated flag .Stmt Period Id : ',53);
414: UPDATE BEN_TCS_STMT_PERD
415: SET stmt_generated_flag = 'STMTGEN'
416: WHERE stmt_perd_id = stmt_perd_rec.stmt_perd_id ;
417: END IF;
418: END IF;

Line 566: UPDATE BEN_TCS_STMT_PERD

562: FETCH c_per_stmt_period
563: INTO l_perd_id ;
564: IF (c_per_stmt_period%NOTFOUND) THEN
565: hr_utility.set_location('Statement Generated Flag reset for period' || l_rep_rec(i).PERIOD_ID ,62);
566: UPDATE BEN_TCS_STMT_PERD
567: SET stmt_generated_flag = 'STMTNGEN'
568: WHERE stmt_perd_id = l_rep_rec(i).PERIOD_ID ;
569:
570: OPEN c_item_hrchy_val ( l_rep_rec(i).PERIOD_ID);

Line 635: UPDATE BEN_TCS_STMT

631: FETCH c_per_stmt
632: INTO l_stmt_id ;
633: IF (c_per_stmt%NOTFOUND) THEN
634: hr_utility.set_location('Stmt Generated flag reset for stmt' || l_rep_rec(i).STMT_ID,67);
635: UPDATE BEN_TCS_STMT
636: SET stmt_generated_flag = 'N'
637: WHERE stmt_id = l_rep_rec(i).STMT_ID;
638: END IF;
639: CLOSE c_per_stmt;

Line 925: AND ( grant_date BETWEEN ( SELECT START_DATE FROM ben_tcs_stmt_perd

921: ben_cwb_stock_optn_dtls
922: WHERE ( person_id = v_person_id
923: OR (business_group_id = v_business_group
924: AND employee_number = p_emp_num) )
925: AND ( grant_date BETWEEN ( SELECT START_DATE FROM ben_tcs_stmt_perd
926: WHERE stmt_perd_id = v_stmt_perd_id )
927: AND v_period_end_date );
928:
929: stk_opts_rec c_stk_opts%ROWTYPE ;

Line 2226: FROM ben_tcs_stmt stmt

2222: CURSOR c_stmt_id (v_stmt_id NUMBER,v_period_id NUMBER )
2223: IS
2224: SELECT stmt.stmt_id stmt_id, v_period_id period_id ,stmt.ee_profile_id ee_id,'Y' valid_flag,
2225: stmt.business_group_id bg_id
2226: FROM ben_tcs_stmt stmt
2227: WHERE stmt.stmt_id = v_stmt_id ;
2228:
2229:
2230: stmt_rec c_stmt_id%ROWTYPE;

Line 2236: FROM ben_tcs_stmt stmt , ben_tcs_stmt_perd period

2232: CURSOR c_stmt_id_bg_id (v_stmt_name VARCHAR2, v_period_start_date IN DATE,v_period_end_date IN DATE)
2233: IS
2234: SELECT stmt.stmt_id stmt_id, period.stmt_perd_id period_id ,stmt.ee_profile_id ee_id,'Y' valid_flag,
2235: stmt.business_group_id bg_id
2236: FROM ben_tcs_stmt stmt , ben_tcs_stmt_perd period
2237: WHERE stmt.NAME = v_stmt_name
2238: AND period.start_date = v_period_start_date
2239: AND period.end_date = v_period_end_date
2240: AND period.stmt_id = stmt.stmt_id

Line 2248: FROM ben_tcs_stmt stmt , ben_tcs_stmt_perd period

2244:
2245: CURSOR c_stmt_id_bg_id1 (v_stmt_name VARCHAR2, v_period_start_date IN DATE,v_period_end_date IN DATE)
2246: IS
2247: SELECT stmt.stmt_id stmt_id, period.stmt_perd_id period_id ,stmt.business_group_id bg_id
2248: FROM ben_tcs_stmt stmt , ben_tcs_stmt_perd period
2249: WHERE stmt.NAME = v_stmt_name
2250: AND period.start_date = v_period_start_date
2251: AND period.end_date = v_period_end_date
2252: AND period.stmt_id = stmt.stmt_id;

Line 2326: FROM ben_tcs_stmt stmt

2322:
2323: CURSOR c_bus_grp_id (v_stmt_id IN NUMBER)
2324: IS
2325: SELECT business_group_id
2326: FROM ben_tcs_stmt stmt
2327: WHERE stmt.stmt_id = v_stmt_id;
2328:
2329: CURSOR c_check_stmt_person(v_person_id IN NUMBER ,v_stmt_id IN NUMBER ,v_perd_id IN NUMBER)
2330: IS

Line 2407: FROM ben_tcs_stmt_perd

2403:
2404: SELECT start_date , end_date
2405: INTO l_period_start_date,
2406: l_actual_end_date
2407: FROM ben_tcs_stmt_perd
2408: WHERE stmt_perd_id = p_period_id ;
2409:
2410: WRITE ('=====================process====================');
2411: WRITE ('||Parameter Description ');

Line 2560: FROM BEN_TCS_STMT

2556: ELSIF (l_business_group_id IS NULL) THEN
2557: --IF( FND_PROFILE.VALUE('HR_CROSS_BUSINESS_GROUP')='Y' ) THEN
2558: SELECT name
2559: INTO l_stmt_name
2560: FROM BEN_TCS_STMT
2561: WHERE stmt_id = p_stmt_id
2562: AND name = p_stmt_name;
2563: IF ( l_stmt_name IS NULL ) THEN
2564: WRITE('The statement Name has been changed ');

Line 2565: fnd_message.set_name ('BEN', 'BEN_TCS_STMT_NAME_CHG');

2561: WHERE stmt_id = p_stmt_id
2562: AND name = p_stmt_name;
2563: IF ( l_stmt_name IS NULL ) THEN
2564: WRITE('The statement Name has been changed ');
2565: fnd_message.set_name ('BEN', 'BEN_TCS_STMT_NAME_CHG');
2566: fnd_message.raise_error;
2567: END IF;
2568: OPEN c_stmt_id_bg_id (p_stmt_name , l_period_start_date ,l_actual_end_date);
2569: LOOP

Line 2614: ben_tcs_stmt_valid_hrchy.stmt_gen_valid_process (

2610: );
2611: hr_utility.set_location (g_actn,159);
2612:
2613:
2614: ben_tcs_stmt_valid_hrchy.stmt_gen_valid_process (
2615: stmt_rec.stmt_id,
2616: stmt_rec.bg_id ,
2617: p_period_id ,
2618: item_hrchy_values,

Line 2682: ben_tcs_stmt_valid_hrchy.stmt_gen_valid_process(

2678: WRITE ( 'Time before validating the stataement '
2679: || TO_CHAR (SYSDATE, 'yyyy/mm/dd:hh:mi:ssam')
2680: );
2681:
2682: ben_tcs_stmt_valid_hrchy.stmt_gen_valid_process(
2683: stmt_record_rec (l_loop_cnt).statement_rec.stmt_id,
2684: stmt_record_rec (l_loop_cnt).statement_rec.bg_id ,
2685: stmt_record_rec (l_loop_cnt).statement_rec.period_id ,
2686: item_hrchy_values, subcat_hrchy_values,

Line 3232: FROM BEN_TCS_STMT

3228: IF (l_business_group_id IS NULL) THEN
3229: -- IF( FND_PROFILE.VALUE('HR_CROSS_BUSINESS_GROUP')='Y' ) THEN
3230: SELECT name
3231: INTO l_stmt_name
3232: FROM BEN_TCS_STMT
3233: WHERE stmt_id = p_stmt_id
3234: AND name = p_stmt_name;
3235: IF ( l_stmt_name IS NULL ) THEN
3236: WRITE('The statement Name has been changed ');

Line 3237: fnd_message.set_name ('BEN', 'BEN_TCS_STMT_NAME_CHG');

3233: WHERE stmt_id = p_stmt_id
3234: AND name = p_stmt_name;
3235: IF ( l_stmt_name IS NULL ) THEN
3236: WRITE('The statement Name has been changed ');
3237: fnd_message.set_name ('BEN', 'BEN_TCS_STMT_NAME_CHG');
3238: fnd_message.raise_error;
3239: END IF;
3240: OPEN c_stmt_id_bg_id1 (p_stmt_name , l_period_start_date ,l_actual_end_date);
3241: LOOP

Line 3283: fnd_message.set_name ('BEN', 'BEN_TCS_STMT_DOESNT_EXIST');

3279: l_rep_rec(rep_count ).TOTAL_PERSONS := 0;
3280: l_rep_rec(rep_count ).PERIOD_ID := p_period_id ;
3281:
3282: WRITE('The person id :'||p_person_id || 'doesnt have the statement' ||stmt_rec.stmt_id );
3283: fnd_message.set_name ('BEN', 'BEN_TCS_STMT_DOESNT_EXIST');
3284: fnd_message.raise_error;
3285: ELSE
3286:
3287: t_prof_tbl (1).mndtry_flag := 'N';

Line 3745: end BEN_TCS_STMT_PROCESS;

3741:
3742:
3743:
3744:
3745: end BEN_TCS_STMT_PROCESS;