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_VAR_RENT_PUB dependencies on PN_VAREN_PVT

Line 32: --Called subprograms: pn_varen_pvt.create_var_rent

28: --Name: create_var_rent
29: --Type: Procedure
30: --Description: This procedure can be used to create a new variable rent.
31: --
32: --Called subprograms: pn_varen_pvt.create_var_rent
33: --
34: --
35: -- History:
36: -- 20-SEP-2010 vkatta o Created

Line 47: , p_var_rent_rec IN OUT NOCOPY pn_varen_pvt.var_rent_rec_type

43: p_api_version IN NUMBER
44: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
45: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
46: , p_validate_flag IN VARCHAR2 DEFAULT 'N'
47: , p_var_rent_rec IN OUT NOCOPY pn_varen_pvt.var_rent_rec_type
48: , p_variable_rent_lines_tbl IN OUT NOCOPY pn_varen_pvt.variable_rent_lines_tbl_type
49: , p_breakpoint_header_tbl IN OUT NOCOPY pn_varen_pvt.breakpoint_header_tbl_type
50: , p_breakpoint_details_tbl IN OUT NOCOPY pn_varen_pvt.breakpoint_details_tbl_type
51: , p_constraints_tbl IN OUT NOCOPY pn_varen_pvt.constraints_tbl_type

Line 48: , p_variable_rent_lines_tbl IN OUT NOCOPY pn_varen_pvt.variable_rent_lines_tbl_type

44: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
45: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
46: , p_validate_flag IN VARCHAR2 DEFAULT 'N'
47: , p_var_rent_rec IN OUT NOCOPY pn_varen_pvt.var_rent_rec_type
48: , p_variable_rent_lines_tbl IN OUT NOCOPY pn_varen_pvt.variable_rent_lines_tbl_type
49: , p_breakpoint_header_tbl IN OUT NOCOPY pn_varen_pvt.breakpoint_header_tbl_type
50: , p_breakpoint_details_tbl IN OUT NOCOPY pn_varen_pvt.breakpoint_details_tbl_type
51: , p_constraints_tbl IN OUT NOCOPY pn_varen_pvt.constraints_tbl_type
52: , p_allow_abat_tbl IN OUT NOCOPY pn_varen_pvt.allow_abat_tbl_type

Line 49: , p_breakpoint_header_tbl IN OUT NOCOPY pn_varen_pvt.breakpoint_header_tbl_type

45: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
46: , p_validate_flag IN VARCHAR2 DEFAULT 'N'
47: , p_var_rent_rec IN OUT NOCOPY pn_varen_pvt.var_rent_rec_type
48: , p_variable_rent_lines_tbl IN OUT NOCOPY pn_varen_pvt.variable_rent_lines_tbl_type
49: , p_breakpoint_header_tbl IN OUT NOCOPY pn_varen_pvt.breakpoint_header_tbl_type
50: , p_breakpoint_details_tbl IN OUT NOCOPY pn_varen_pvt.breakpoint_details_tbl_type
51: , p_constraints_tbl IN OUT NOCOPY pn_varen_pvt.constraints_tbl_type
52: , p_allow_abat_tbl IN OUT NOCOPY pn_varen_pvt.allow_abat_tbl_type
53: , p_generate_periods IN VARCHAR2 DEFAULT 'N'

Line 50: , p_breakpoint_details_tbl IN OUT NOCOPY pn_varen_pvt.breakpoint_details_tbl_type

46: , p_validate_flag IN VARCHAR2 DEFAULT 'N'
47: , p_var_rent_rec IN OUT NOCOPY pn_varen_pvt.var_rent_rec_type
48: , p_variable_rent_lines_tbl IN OUT NOCOPY pn_varen_pvt.variable_rent_lines_tbl_type
49: , p_breakpoint_header_tbl IN OUT NOCOPY pn_varen_pvt.breakpoint_header_tbl_type
50: , p_breakpoint_details_tbl IN OUT NOCOPY pn_varen_pvt.breakpoint_details_tbl_type
51: , p_constraints_tbl IN OUT NOCOPY pn_varen_pvt.constraints_tbl_type
52: , p_allow_abat_tbl IN OUT NOCOPY pn_varen_pvt.allow_abat_tbl_type
53: , p_generate_periods IN VARCHAR2 DEFAULT 'N'
54: , p_generate_breakpoints IN VARCHAR2 DEFAULT 'N'

Line 51: , p_constraints_tbl IN OUT NOCOPY pn_varen_pvt.constraints_tbl_type

47: , p_var_rent_rec IN OUT NOCOPY pn_varen_pvt.var_rent_rec_type
48: , p_variable_rent_lines_tbl IN OUT NOCOPY pn_varen_pvt.variable_rent_lines_tbl_type
49: , p_breakpoint_header_tbl IN OUT NOCOPY pn_varen_pvt.breakpoint_header_tbl_type
50: , p_breakpoint_details_tbl IN OUT NOCOPY pn_varen_pvt.breakpoint_details_tbl_type
51: , p_constraints_tbl IN OUT NOCOPY pn_varen_pvt.constraints_tbl_type
52: , p_allow_abat_tbl IN OUT NOCOPY pn_varen_pvt.allow_abat_tbl_type
53: , p_generate_periods IN VARCHAR2 DEFAULT 'N'
54: , p_generate_breakpoints IN VARCHAR2 DEFAULT 'N'
55: , p_generate_constraints IN VARCHAR2 DEFAULT 'N'

Line 52: , p_allow_abat_tbl IN OUT NOCOPY pn_varen_pvt.allow_abat_tbl_type

48: , p_variable_rent_lines_tbl IN OUT NOCOPY pn_varen_pvt.variable_rent_lines_tbl_type
49: , p_breakpoint_header_tbl IN OUT NOCOPY pn_varen_pvt.breakpoint_header_tbl_type
50: , p_breakpoint_details_tbl IN OUT NOCOPY pn_varen_pvt.breakpoint_details_tbl_type
51: , p_constraints_tbl IN OUT NOCOPY pn_varen_pvt.constraints_tbl_type
52: , p_allow_abat_tbl IN OUT NOCOPY pn_varen_pvt.allow_abat_tbl_type
53: , p_generate_periods IN VARCHAR2 DEFAULT 'N'
54: , p_generate_breakpoints IN VARCHAR2 DEFAULT 'N'
55: , p_generate_constraints IN VARCHAR2 DEFAULT 'N'
56: , x_return_status OUT NOCOPY VARCHAR2

Line 70: l_var_rent_rec pn_varen_pvt.var_rent_rec_type := p_var_rent_rec;

66: || '.'
67: || l_api_name;
68: l_org_return_status VARCHAR2 (1);
69: l_org_id NUMBER;
70: l_var_rent_rec pn_varen_pvt.var_rent_rec_type := p_var_rent_rec;
71: BEGIN
72: -- NUll;
73: x_return_status := fnd_api.g_ret_sts_success;
74: -- Standard Start of API savepoint

Line 145: || 'Before calling pn_varen_pvt.create_var_rent package - l_org_return_status '

141: x_return_status := fnd_api.g_ret_sts_error;
142: ELSE
143: pn_varen_util.pvt_debug ( l_api_name_full
144: || ' : '
145: || 'Before calling pn_varen_pvt.create_var_rent package - l_org_return_status '
146: || l_org_return_status
147: , 3
148: );
149: --pn_varen_util.pvt_debug ('Public : pn_varen_pvt.create_var_rent', 3);

Line 149: --pn_varen_util.pvt_debug ('Public : pn_varen_pvt.create_var_rent', 3);

145: || 'Before calling pn_varen_pvt.create_var_rent package - l_org_return_status '
146: || l_org_return_status
147: , 3
148: );
149: --pn_varen_util.pvt_debug ('Public : pn_varen_pvt.create_var_rent', 3);
150: pn_varen_pvt.create_var_rent (p_api_version => 1.0
151: , p_init_msg_list => p_init_msg_list
152: , p_commit => p_commit
153: , p_validate_flag => p_validate_flag

Line 150: pn_varen_pvt.create_var_rent (p_api_version => 1.0

146: || l_org_return_status
147: , 3
148: );
149: --pn_varen_util.pvt_debug ('Public : pn_varen_pvt.create_var_rent', 3);
150: pn_varen_pvt.create_var_rent (p_api_version => 1.0
151: , p_init_msg_list => p_init_msg_list
152: , p_commit => p_commit
153: , p_validate_flag => p_validate_flag
154: , p_var_rent_rec => l_var_rent_rec

Line 265: --Called subprograms: pn_varen_pvt.generate_periods

261: --Name: generate_periods
262: --Type: Procedure
263: --Description: This procedure can be used to generate period for variable rent.
264: --
265: --Called subprograms: pn_varen_pvt.generate_periods
266: --
267: --
268: -- History:
269: -- 20-SEP-2010 vkatta o Created

Line 341: pn_varen_pvt.generate_periods (p_api_version => 1.0

337: );
338: fnd_msg_pub.ADD;
339: RAISE fnd_api.g_exc_error;
340: ELSE
341: pn_varen_pvt.generate_periods (p_api_version => 1.0
342: , p_init_msg_list => fnd_api.g_false
343: , p_commit => fnd_api.g_false
344: , p_var_rent_id => p_var_rent_id
345: , p_var_rent_num => NULL --for future use

Line 448: --Called subprograms: pn_varen_pvt.create_bkpt_const_allow_abat

444: --Name: create_bkpt_const_allow_abat
445: --Type: Procedure
446: --Description: This procedure can be used to create breakpoints, constraints, allowances, and abatements for variable rent.
447: --
448: --Called subprograms: pn_varen_pvt.create_bkpt_const_allow_abat
449: --
450: --
451: -- History:
452: -- 20-SEP-2010 vkatta o Created

Line 462: , p_variable_rent_lines_tbl IN OUT NOCOPY pn_varen_pvt.variable_rent_lines_tbl_type

458: p_api_version IN NUMBER
459: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
460: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
461: , p_validate_flag IN VARCHAR2 DEFAULT 'N'
462: , p_variable_rent_lines_tbl IN OUT NOCOPY pn_varen_pvt.variable_rent_lines_tbl_type
463: , p_breakpoint_header_tbl IN OUT NOCOPY pn_varen_pvt.breakpoint_header_tbl_type
464: , p_breakpoint_details_tbl IN OUT NOCOPY pn_varen_pvt.breakpoint_details_tbl_type
465: , p_constraints_tbl IN OUT NOCOPY pn_varen_pvt.constraints_tbl_type
466: , p_allow_abat_tbl IN OUT NOCOPY pn_varen_pvt.allow_abat_tbl_type

Line 463: , p_breakpoint_header_tbl IN OUT NOCOPY pn_varen_pvt.breakpoint_header_tbl_type

459: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
460: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
461: , p_validate_flag IN VARCHAR2 DEFAULT 'N'
462: , p_variable_rent_lines_tbl IN OUT NOCOPY pn_varen_pvt.variable_rent_lines_tbl_type
463: , p_breakpoint_header_tbl IN OUT NOCOPY pn_varen_pvt.breakpoint_header_tbl_type
464: , p_breakpoint_details_tbl IN OUT NOCOPY pn_varen_pvt.breakpoint_details_tbl_type
465: , p_constraints_tbl IN OUT NOCOPY pn_varen_pvt.constraints_tbl_type
466: , p_allow_abat_tbl IN OUT NOCOPY pn_varen_pvt.allow_abat_tbl_type
467: , x_return_status OUT NOCOPY VARCHAR2

Line 464: , p_breakpoint_details_tbl IN OUT NOCOPY pn_varen_pvt.breakpoint_details_tbl_type

460: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
461: , p_validate_flag IN VARCHAR2 DEFAULT 'N'
462: , p_variable_rent_lines_tbl IN OUT NOCOPY pn_varen_pvt.variable_rent_lines_tbl_type
463: , p_breakpoint_header_tbl IN OUT NOCOPY pn_varen_pvt.breakpoint_header_tbl_type
464: , p_breakpoint_details_tbl IN OUT NOCOPY pn_varen_pvt.breakpoint_details_tbl_type
465: , p_constraints_tbl IN OUT NOCOPY pn_varen_pvt.constraints_tbl_type
466: , p_allow_abat_tbl IN OUT NOCOPY pn_varen_pvt.allow_abat_tbl_type
467: , x_return_status OUT NOCOPY VARCHAR2
468: , x_msg_count OUT NOCOPY NUMBER

Line 465: , p_constraints_tbl IN OUT NOCOPY pn_varen_pvt.constraints_tbl_type

461: , p_validate_flag IN VARCHAR2 DEFAULT 'N'
462: , p_variable_rent_lines_tbl IN OUT NOCOPY pn_varen_pvt.variable_rent_lines_tbl_type
463: , p_breakpoint_header_tbl IN OUT NOCOPY pn_varen_pvt.breakpoint_header_tbl_type
464: , p_breakpoint_details_tbl IN OUT NOCOPY pn_varen_pvt.breakpoint_details_tbl_type
465: , p_constraints_tbl IN OUT NOCOPY pn_varen_pvt.constraints_tbl_type
466: , p_allow_abat_tbl IN OUT NOCOPY pn_varen_pvt.allow_abat_tbl_type
467: , x_return_status OUT NOCOPY VARCHAR2
468: , x_msg_count OUT NOCOPY NUMBER
469: , x_msg_data OUT NOCOPY VARCHAR2

Line 466: , p_allow_abat_tbl IN OUT NOCOPY pn_varen_pvt.allow_abat_tbl_type

462: , p_variable_rent_lines_tbl IN OUT NOCOPY pn_varen_pvt.variable_rent_lines_tbl_type
463: , p_breakpoint_header_tbl IN OUT NOCOPY pn_varen_pvt.breakpoint_header_tbl_type
464: , p_breakpoint_details_tbl IN OUT NOCOPY pn_varen_pvt.breakpoint_details_tbl_type
465: , p_constraints_tbl IN OUT NOCOPY pn_varen_pvt.constraints_tbl_type
466: , p_allow_abat_tbl IN OUT NOCOPY pn_varen_pvt.allow_abat_tbl_type
467: , x_return_status OUT NOCOPY VARCHAR2
468: , x_msg_count OUT NOCOPY NUMBER
469: , x_msg_data OUT NOCOPY VARCHAR2
470: )

Line 531: pn_varen_pvt.create_bkpt_const_allow_abat (p_api_version => 1.0

527: || ' : '
528: || 'Start of Create Breakpoints, Constraints, Allowanced and Abatements package'
529: , 3
530: );
531: pn_varen_pvt.create_bkpt_const_allow_abat (p_api_version => 1.0
532: , p_init_msg_list => p_init_msg_list
533: , p_commit => p_commit
534: , p_validate_flag => p_validate_flag
535: , p_variable_rent_lines_tbl => p_variable_rent_lines_tbl

Line 647: --Called subprograms: pn_varen_pvt.update_var_rent

643: --Name: update_var_rent
644: --Type: Procedure
645: --Description: This procedure can be used to update variable rent.
646: --
647: --Called subprograms: pn_varen_pvt.update_var_rent
648: --
649: --
650: -- History:
651: -- 20-SEP-2010 vkatta o Created

Line 662: , p_upd_var_rent_rec IN OUT NOCOPY pn_varen_pvt.upd_var_rent_rec_type

658: p_api_version IN NUMBER
659: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
660: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
661: , p_validate_flag IN VARCHAR2 DEFAULT 'Y'
662: , p_upd_var_rent_rec IN OUT NOCOPY pn_varen_pvt.upd_var_rent_rec_type
663: , p_var_rent_lines_tbl IN OUT NOCOPY pn_varen_pvt.variable_rent_lines_tbl_type
664: , p_breakpoint_header_tbl IN OUT NOCOPY pn_varen_pvt.breakpoint_header_tbl_type
665: , p_breakpoint_details_tbl IN OUT NOCOPY pn_varen_pvt.breakpoint_details_tbl_type
666: , p_constraints_tbl IN OUT NOCOPY pn_varen_pvt.constraints_tbl_type

Line 663: , p_var_rent_lines_tbl IN OUT NOCOPY pn_varen_pvt.variable_rent_lines_tbl_type

659: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
660: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
661: , p_validate_flag IN VARCHAR2 DEFAULT 'Y'
662: , p_upd_var_rent_rec IN OUT NOCOPY pn_varen_pvt.upd_var_rent_rec_type
663: , p_var_rent_lines_tbl IN OUT NOCOPY pn_varen_pvt.variable_rent_lines_tbl_type
664: , p_breakpoint_header_tbl IN OUT NOCOPY pn_varen_pvt.breakpoint_header_tbl_type
665: , p_breakpoint_details_tbl IN OUT NOCOPY pn_varen_pvt.breakpoint_details_tbl_type
666: , p_constraints_tbl IN OUT NOCOPY pn_varen_pvt.constraints_tbl_type
667: , p_allow_abat_tbl IN OUT NOCOPY pn_varen_pvt.allow_abat_tbl_type

Line 664: , p_breakpoint_header_tbl IN OUT NOCOPY pn_varen_pvt.breakpoint_header_tbl_type

660: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
661: , p_validate_flag IN VARCHAR2 DEFAULT 'Y'
662: , p_upd_var_rent_rec IN OUT NOCOPY pn_varen_pvt.upd_var_rent_rec_type
663: , p_var_rent_lines_tbl IN OUT NOCOPY pn_varen_pvt.variable_rent_lines_tbl_type
664: , p_breakpoint_header_tbl IN OUT NOCOPY pn_varen_pvt.breakpoint_header_tbl_type
665: , p_breakpoint_details_tbl IN OUT NOCOPY pn_varen_pvt.breakpoint_details_tbl_type
666: , p_constraints_tbl IN OUT NOCOPY pn_varen_pvt.constraints_tbl_type
667: , p_allow_abat_tbl IN OUT NOCOPY pn_varen_pvt.allow_abat_tbl_type
668: , p_undo_periods IN VARCHAR2 DEFAULT 'N'

Line 665: , p_breakpoint_details_tbl IN OUT NOCOPY pn_varen_pvt.breakpoint_details_tbl_type

661: , p_validate_flag IN VARCHAR2 DEFAULT 'Y'
662: , p_upd_var_rent_rec IN OUT NOCOPY pn_varen_pvt.upd_var_rent_rec_type
663: , p_var_rent_lines_tbl IN OUT NOCOPY pn_varen_pvt.variable_rent_lines_tbl_type
664: , p_breakpoint_header_tbl IN OUT NOCOPY pn_varen_pvt.breakpoint_header_tbl_type
665: , p_breakpoint_details_tbl IN OUT NOCOPY pn_varen_pvt.breakpoint_details_tbl_type
666: , p_constraints_tbl IN OUT NOCOPY pn_varen_pvt.constraints_tbl_type
667: , p_allow_abat_tbl IN OUT NOCOPY pn_varen_pvt.allow_abat_tbl_type
668: , p_undo_periods IN VARCHAR2 DEFAULT 'N'
669: , p_undo_breakpoints IN VARCHAR2 DEFAULT 'N'

Line 666: , p_constraints_tbl IN OUT NOCOPY pn_varen_pvt.constraints_tbl_type

662: , p_upd_var_rent_rec IN OUT NOCOPY pn_varen_pvt.upd_var_rent_rec_type
663: , p_var_rent_lines_tbl IN OUT NOCOPY pn_varen_pvt.variable_rent_lines_tbl_type
664: , p_breakpoint_header_tbl IN OUT NOCOPY pn_varen_pvt.breakpoint_header_tbl_type
665: , p_breakpoint_details_tbl IN OUT NOCOPY pn_varen_pvt.breakpoint_details_tbl_type
666: , p_constraints_tbl IN OUT NOCOPY pn_varen_pvt.constraints_tbl_type
667: , p_allow_abat_tbl IN OUT NOCOPY pn_varen_pvt.allow_abat_tbl_type
668: , p_undo_periods IN VARCHAR2 DEFAULT 'N'
669: , p_undo_breakpoints IN VARCHAR2 DEFAULT 'N'
670: , p_undo_constraints IN VARCHAR2 DEFAULT 'N'

Line 667: , p_allow_abat_tbl IN OUT NOCOPY pn_varen_pvt.allow_abat_tbl_type

663: , p_var_rent_lines_tbl IN OUT NOCOPY pn_varen_pvt.variable_rent_lines_tbl_type
664: , p_breakpoint_header_tbl IN OUT NOCOPY pn_varen_pvt.breakpoint_header_tbl_type
665: , p_breakpoint_details_tbl IN OUT NOCOPY pn_varen_pvt.breakpoint_details_tbl_type
666: , p_constraints_tbl IN OUT NOCOPY pn_varen_pvt.constraints_tbl_type
667: , p_allow_abat_tbl IN OUT NOCOPY pn_varen_pvt.allow_abat_tbl_type
668: , p_undo_periods IN VARCHAR2 DEFAULT 'N'
669: , p_undo_breakpoints IN VARCHAR2 DEFAULT 'N'
670: , p_undo_constraints IN VARCHAR2 DEFAULT 'N'
671: , x_return_status OUT NOCOPY VARCHAR2

Line 738: pn_varen_pvt.update_var_rent (p_api_version => 1.0

734: , 3
735: );
736:
737:
738: pn_varen_pvt.update_var_rent (p_api_version => 1.0
739: , p_init_msg_list => fnd_api.g_false
740: , p_commit => fnd_api.g_false
741: , p_validate_flag => p_validate_flag
742: , p_upd_var_rent_rec => p_upd_var_rent_rec