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.18 2007/09/21 11:34:43 vkodedal noship $ */
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.18 2007/09/21 11:34:43 vkodedal noship $ */
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 917: AND ( grant_date BETWEEN ( SELECT START_DATE FROM ben_tcs_stmt_perd

913: ben_cwb_stock_optn_dtls
914: WHERE ( person_id = v_person_id
915: OR (business_group_id = v_business_group
916: AND employee_number = p_emp_num) )
917: AND ( grant_date BETWEEN ( SELECT START_DATE FROM ben_tcs_stmt_perd
918: WHERE stmt_perd_id = v_stmt_perd_id )
919: AND v_period_end_date );
920:
921: stk_opts_rec c_stk_opts%ROWTYPE ;

Line 2225: FROM ben_tcs_stmt stmt

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

Line 2235: FROM ben_tcs_stmt stmt , ben_tcs_stmt_perd period

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

Line 2247: FROM ben_tcs_stmt stmt , ben_tcs_stmt_perd period

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

Line 2305: FROM ben_tcs_stmt stmt

2301:
2302: CURSOR c_bus_grp_id (v_stmt_id IN NUMBER)
2303: IS
2304: SELECT business_group_id
2305: FROM ben_tcs_stmt stmt
2306: WHERE stmt.stmt_id = v_stmt_id;
2307:
2308: CURSOR c_check_stmt_person(v_person_id IN NUMBER ,v_stmt_id IN NUMBER ,v_perd_id IN NUMBER)
2309: IS

Line 2376: FROM ben_tcs_stmt_perd

2372:
2373: SELECT start_date , end_date
2374: INTO l_period_start_date,
2375: l_actual_end_date
2376: FROM ben_tcs_stmt_perd
2377: WHERE stmt_perd_id = p_period_id ;
2378:
2379: WRITE ('=====================process====================');
2380: WRITE ('||Parameter Description ');

Line 2529: FROM BEN_TCS_STMT

2525: ELSIF (l_business_group_id IS NULL) THEN
2526: --IF( FND_PROFILE.VALUE('HR_CROSS_BUSINESS_GROUP')='Y' ) THEN
2527: SELECT name
2528: INTO l_stmt_name
2529: FROM BEN_TCS_STMT
2530: WHERE stmt_id = p_stmt_id
2531: AND name = p_stmt_name;
2532: IF ( l_stmt_name IS NULL ) THEN
2533: WRITE('The statement Name has been changed ');

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

2530: WHERE stmt_id = p_stmt_id
2531: AND name = p_stmt_name;
2532: IF ( l_stmt_name IS NULL ) THEN
2533: WRITE('The statement Name has been changed ');
2534: fnd_message.set_name ('BEN', 'BEN_TCS_STMT_NAME_CHG');
2535: fnd_message.raise_error;
2536: END IF;
2537: OPEN c_stmt_id_bg_id (p_stmt_name , l_period_start_date ,l_actual_end_date);
2538: LOOP

Line 2583: ben_tcs_stmt_valid_hrchy.stmt_gen_valid_process (

2579: );
2580: hr_utility.set_location (g_actn,159);
2581:
2582:
2583: ben_tcs_stmt_valid_hrchy.stmt_gen_valid_process (
2584: stmt_rec.stmt_id,
2585: stmt_rec.bg_id ,
2586: p_period_id ,
2587: item_hrchy_values,

Line 2651: ben_tcs_stmt_valid_hrchy.stmt_gen_valid_process(

2647: WRITE ( 'Time before validating the stataement '
2648: || TO_CHAR (SYSDATE, 'yyyy/mm/dd:hh:mi:ssam')
2649: );
2650:
2651: ben_tcs_stmt_valid_hrchy.stmt_gen_valid_process(
2652: stmt_record_rec (l_loop_cnt).statement_rec.stmt_id,
2653: stmt_record_rec (l_loop_cnt).statement_rec.bg_id ,
2654: stmt_record_rec (l_loop_cnt).statement_rec.period_id ,
2655: item_hrchy_values, subcat_hrchy_values,

Line 3201: FROM BEN_TCS_STMT

3197: IF (l_business_group_id IS NULL) THEN
3198: -- IF( FND_PROFILE.VALUE('HR_CROSS_BUSINESS_GROUP')='Y' ) THEN
3199: SELECT name
3200: INTO l_stmt_name
3201: FROM BEN_TCS_STMT
3202: WHERE stmt_id = p_stmt_id
3203: AND name = p_stmt_name;
3204: IF ( l_stmt_name IS NULL ) THEN
3205: WRITE('The statement Name has been changed ');

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

3202: WHERE stmt_id = p_stmt_id
3203: AND name = p_stmt_name;
3204: IF ( l_stmt_name IS NULL ) THEN
3205: WRITE('The statement Name has been changed ');
3206: fnd_message.set_name ('BEN', 'BEN_TCS_STMT_NAME_CHG');
3207: fnd_message.raise_error;
3208: END IF;
3209: OPEN c_stmt_id_bg_id1 (p_stmt_name , l_period_start_date ,l_actual_end_date);
3210: LOOP

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

3248: l_rep_rec(rep_count ).TOTAL_PERSONS := 0;
3249: l_rep_rec(rep_count ).PERIOD_ID := p_period_id ;
3250:
3251: WRITE('The person id :'||p_person_id || 'doesnt have the statement' ||stmt_rec.stmt_id );
3252: fnd_message.set_name ('BEN', 'BEN_TCS_STMT_DOESNT_EXIST');
3253: fnd_message.raise_error;
3254: ELSE
3255:
3256: t_prof_tbl (1).mndtry_flag := 'N';

Line 3698: end BEN_TCS_STMT_PROCESS;

3694:
3695:
3696:
3697:
3698: end BEN_TCS_STMT_PROCESS;