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.PN_VAREN_PVT dependencies on PN_VAR_BKHD_DEFAULTS_ALL

Line 524: FROM pn_var_bkhd_defaults_all

520:
521: CURSOR exists_hd_def_cur
522: IS
523: SELECT bkhd_default_id
524: FROM pn_var_bkhd_defaults_all
525: WHERE line_default_id = l_line_def_id;
526:
527: CURSOR exists_hd_def_cur_1
528: IS

Line 532: FROM pn_var_bkhd_defaults_all

528: IS
529: SELECT 'x'
530: FROM DUAL
531: WHERE EXISTS (SELECT bkhd_default_id
532: FROM pn_var_bkhd_defaults_all
533: WHERE var_rent_id = p_var_rent_id);
534: BEGIN
535: x_return_status := fnd_api.g_ret_sts_success;
536: l_dummy := NULL;

Line 3279: l_bkhd_default_id pn_var_bkhd_defaults_all.bkhd_default_id%TYPE;

3275: , p_validate_flag IN VARCHAR2
3276: , x_return_status OUT NOCOPY VARCHAR2
3277: )
3278: IS
3279: l_bkhd_default_id pn_var_bkhd_defaults_all.bkhd_default_id%TYPE;
3280: l_bkhd_start_date pn_var_bkhd_defaults_all.bkhd_start_date%TYPE;
3281: l_bkhd_end_date pn_var_bkhd_defaults_all.bkhd_end_date%TYPE;
3282: l_natural_break_rate pn_var_bkhd_defaults_all.natural_break_rate%TYPE;
3283: l_break_type pn_var_bkhd_defaults_all.break_type%TYPE;

Line 3280: l_bkhd_start_date pn_var_bkhd_defaults_all.bkhd_start_date%TYPE;

3276: , x_return_status OUT NOCOPY VARCHAR2
3277: )
3278: IS
3279: l_bkhd_default_id pn_var_bkhd_defaults_all.bkhd_default_id%TYPE;
3280: l_bkhd_start_date pn_var_bkhd_defaults_all.bkhd_start_date%TYPE;
3281: l_bkhd_end_date pn_var_bkhd_defaults_all.bkhd_end_date%TYPE;
3282: l_natural_break_rate pn_var_bkhd_defaults_all.natural_break_rate%TYPE;
3283: l_break_type pn_var_bkhd_defaults_all.break_type%TYPE;
3284: l_breakpoint_type pn_var_bkhd_defaults_all.breakpoint_type%TYPE;

Line 3281: l_bkhd_end_date pn_var_bkhd_defaults_all.bkhd_end_date%TYPE;

3277: )
3278: IS
3279: l_bkhd_default_id pn_var_bkhd_defaults_all.bkhd_default_id%TYPE;
3280: l_bkhd_start_date pn_var_bkhd_defaults_all.bkhd_start_date%TYPE;
3281: l_bkhd_end_date pn_var_bkhd_defaults_all.bkhd_end_date%TYPE;
3282: l_natural_break_rate pn_var_bkhd_defaults_all.natural_break_rate%TYPE;
3283: l_break_type pn_var_bkhd_defaults_all.break_type%TYPE;
3284: l_breakpoint_type pn_var_bkhd_defaults_all.breakpoint_type%TYPE;
3285: l_bkpt_details_val VARCHAR2 (1) := 'Y';

Line 3282: l_natural_break_rate pn_var_bkhd_defaults_all.natural_break_rate%TYPE;

3278: IS
3279: l_bkhd_default_id pn_var_bkhd_defaults_all.bkhd_default_id%TYPE;
3280: l_bkhd_start_date pn_var_bkhd_defaults_all.bkhd_start_date%TYPE;
3281: l_bkhd_end_date pn_var_bkhd_defaults_all.bkhd_end_date%TYPE;
3282: l_natural_break_rate pn_var_bkhd_defaults_all.natural_break_rate%TYPE;
3283: l_break_type pn_var_bkhd_defaults_all.break_type%TYPE;
3284: l_breakpoint_type pn_var_bkhd_defaults_all.breakpoint_type%TYPE;
3285: l_bkpt_details_val VARCHAR2 (1) := 'Y';
3286: l_period_id NUMBER;

Line 3283: l_break_type pn_var_bkhd_defaults_all.break_type%TYPE;

3279: l_bkhd_default_id pn_var_bkhd_defaults_all.bkhd_default_id%TYPE;
3280: l_bkhd_start_date pn_var_bkhd_defaults_all.bkhd_start_date%TYPE;
3281: l_bkhd_end_date pn_var_bkhd_defaults_all.bkhd_end_date%TYPE;
3282: l_natural_break_rate pn_var_bkhd_defaults_all.natural_break_rate%TYPE;
3283: l_break_type pn_var_bkhd_defaults_all.break_type%TYPE;
3284: l_breakpoint_type pn_var_bkhd_defaults_all.breakpoint_type%TYPE;
3285: l_bkpt_details_val VARCHAR2 (1) := 'Y';
3286: l_period_id NUMBER;
3287: -- := to_number(name_in('BKPTS_HEADER_BLK.period_id'));

Line 3284: l_breakpoint_type pn_var_bkhd_defaults_all.breakpoint_type%TYPE;

3280: l_bkhd_start_date pn_var_bkhd_defaults_all.bkhd_start_date%TYPE;
3281: l_bkhd_end_date pn_var_bkhd_defaults_all.bkhd_end_date%TYPE;
3282: l_natural_break_rate pn_var_bkhd_defaults_all.natural_break_rate%TYPE;
3283: l_break_type pn_var_bkhd_defaults_all.break_type%TYPE;
3284: l_breakpoint_type pn_var_bkhd_defaults_all.breakpoint_type%TYPE;
3285: l_bkpt_details_val VARCHAR2 (1) := 'Y';
3286: l_period_id NUMBER;
3287: -- := to_number(name_in('BKPTS_HEADER_BLK.period_id'));
3288: l_reporting_periods NUMBER;

Line 3309: FROM pn_var_bkhd_defaults_all

3305: , l_bkhd_end_date
3306: , l_natural_break_rate
3307: , l_break_type
3308: , l_breakpoint_type
3309: FROM pn_var_bkhd_defaults_all
3310: WHERE var_rent_id = p_breakpoint_details_rec_type.var_rent_id
3311: AND bkhd_default_id = p_breakpoint_details_rec_type.bkhd_default_id
3312: AND org_id = g_org_id; --l_org_id;
3313:

Line 5045: FROM pn_var_bkhd_defaults_all

5041: l_date_range_count := 0;
5042: BEGIN
5043: SELECT COUNT(1)
5044: INTO l_date_range_count
5045: FROM pn_var_bkhd_defaults_all
5046: WHERE var_rent_id = p_variable_rent_lines_tbl (i).var_rent_id
5047: AND line_default_id = p_variable_rent_lines_tbl (i).line_default_id
5048: AND (bkhd_start_date <= p_breakpoint_header_tbl (j).bkhd_end_date AND bkhd_end_date >= p_breakpoint_header_tbl (j).bkhd_start_date);
5049: EXCEPTION

Line 5448: FROM pn_var_bkhd_defaults_all

5444:
5445: BEGIN
5446: UPDATE pn_var_line_defaults_all
5447: SET line_start_date = (SELECT MIN(bkhd_start_date)
5448: FROM pn_var_bkhd_defaults_all
5449: WHERE line_default_id = p_variable_rent_lines_tbl(i).line_default_id
5450: AND org_id = g_org_id
5451: )
5452: ,line_end_date = (SELECT MAX(bkhd_end_date)

Line 5453: FROM pn_var_bkhd_defaults_all

5449: WHERE line_default_id = p_variable_rent_lines_tbl(i).line_default_id
5450: AND org_id = g_org_id
5451: )
5452: ,line_end_date = (SELECT MAX(bkhd_end_date)
5453: FROM pn_var_bkhd_defaults_all
5454: WHERE line_default_id = p_variable_rent_lines_tbl(i).line_default_id
5455: AND org_id = g_org_id
5456: )
5457: WHERE line_default_id = p_variable_rent_lines_tbl(i).line_default_id

Line 9902: FROM pn_var_bkhd_defaults_all

9898:
9899: CURSOR c_def_bkdtexist
9900: IS
9901: SELECT COUNT (*)
9902: FROM pn_var_bkhd_defaults_all
9903: WHERE line_default_id IN (SELECT line_default_id
9904: FROM pn_var_line_defaults_all
9905: WHERE var_rent_id = p_var_rent_id);
9906:

Line 10274: DELETE pn_var_bkhd_defaults_all

10270:
10271: DELETE FROM pn_var_bkdt_defaults_all
10272: WHERE var_rent_id = l_varentid;
10273:
10274: DELETE pn_var_bkhd_defaults_all
10275: WHERE var_rent_id = l_varentid;
10276:
10277: DELETE pn_var_line_defaults_all
10278: WHERE var_rent_id = l_varentid;

Line 10709: FROM pn_var_bkhd_defaults_all

10705: , attribute13
10706: , attribute14
10707: , attribute15
10708: , org_id
10709: FROM pn_var_bkhd_defaults_all
10710: -- Commented by Vivek on 09-DEC-2010
10711: --WHERE var_rent_id = p_upd_var_rent_rec.var_rent_id;
10712: -- Below lines have been added by Vivek on 09-DEC-2010
10713: WHERE bkhd_default_id = p_bkhd_default_id

Line 14628: FROM pn_var_bkhd_defaults_all

14624:
14625:
14626: SELECT COUNT(1)
14627: INTO l_date_range_count
14628: FROM pn_var_bkhd_defaults_all
14629: WHERE var_rent_id = p_breakpoint_header_tbl (ubk).var_rent_id
14630: AND bkhd_default_id<> p_breakpoint_header_tbl (ubk).bkhd_default_id
14631: AND line_default_id = p_breakpoint_header_tbl (ubk).line_default_id
14632: AND (bkhd_start_date <= p_breakpoint_header_tbl (ubk).bkhd_end_date AND bkhd_end_date >= p_breakpoint_header_tbl (ubk).bkhd_start_date);