DBA Data[Home] [Help]

APPS.PN_VAR_RENT_PKG dependencies on PN_VAR_GRP_DATES

Line 7: grp_date_id PN_VAR_GRP_DATES.grp_date_id%TYPE,

3:
4: status VARCHAR2(30) := 'REVERSED';
5:
6: TYPE grp_date_info_rec IS RECORD (
7: grp_date_id PN_VAR_GRP_DATES.grp_date_id%TYPE,
8: grp_start_date PN_VAR_GRP_DATES.grp_start_date%TYPE,
9: grp_end_date PN_VAR_GRP_DATES.grp_end_date%TYPE,
10: group_date PN_VAR_GRP_DATES.group_date%TYPE,
11: reptg_due_date PN_VAR_GRP_DATES.reptg_due_date%TYPE,

Line 8: grp_start_date PN_VAR_GRP_DATES.grp_start_date%TYPE,

4: status VARCHAR2(30) := 'REVERSED';
5:
6: TYPE grp_date_info_rec IS RECORD (
7: grp_date_id PN_VAR_GRP_DATES.grp_date_id%TYPE,
8: grp_start_date PN_VAR_GRP_DATES.grp_start_date%TYPE,
9: grp_end_date PN_VAR_GRP_DATES.grp_end_date%TYPE,
10: group_date PN_VAR_GRP_DATES.group_date%TYPE,
11: reptg_due_date PN_VAR_GRP_DATES.reptg_due_date%TYPE,
12: inv_start_date PN_VAR_GRP_DATES.inv_start_date%TYPE,

Line 9: grp_end_date PN_VAR_GRP_DATES.grp_end_date%TYPE,

5:
6: TYPE grp_date_info_rec IS RECORD (
7: grp_date_id PN_VAR_GRP_DATES.grp_date_id%TYPE,
8: grp_start_date PN_VAR_GRP_DATES.grp_start_date%TYPE,
9: grp_end_date PN_VAR_GRP_DATES.grp_end_date%TYPE,
10: group_date PN_VAR_GRP_DATES.group_date%TYPE,
11: reptg_due_date PN_VAR_GRP_DATES.reptg_due_date%TYPE,
12: inv_start_date PN_VAR_GRP_DATES.inv_start_date%TYPE,
13: inv_end_date PN_VAR_GRP_DATES.inv_end_date%TYPE,

Line 10: group_date PN_VAR_GRP_DATES.group_date%TYPE,

6: TYPE grp_date_info_rec IS RECORD (
7: grp_date_id PN_VAR_GRP_DATES.grp_date_id%TYPE,
8: grp_start_date PN_VAR_GRP_DATES.grp_start_date%TYPE,
9: grp_end_date PN_VAR_GRP_DATES.grp_end_date%TYPE,
10: group_date PN_VAR_GRP_DATES.group_date%TYPE,
11: reptg_due_date PN_VAR_GRP_DATES.reptg_due_date%TYPE,
12: inv_start_date PN_VAR_GRP_DATES.inv_start_date%TYPE,
13: inv_end_date PN_VAR_GRP_DATES.inv_end_date%TYPE,
14: invoice_date PN_VAR_GRP_DATES.invoice_date%TYPE,

Line 11: reptg_due_date PN_VAR_GRP_DATES.reptg_due_date%TYPE,

7: grp_date_id PN_VAR_GRP_DATES.grp_date_id%TYPE,
8: grp_start_date PN_VAR_GRP_DATES.grp_start_date%TYPE,
9: grp_end_date PN_VAR_GRP_DATES.grp_end_date%TYPE,
10: group_date PN_VAR_GRP_DATES.group_date%TYPE,
11: reptg_due_date PN_VAR_GRP_DATES.reptg_due_date%TYPE,
12: inv_start_date PN_VAR_GRP_DATES.inv_start_date%TYPE,
13: inv_end_date PN_VAR_GRP_DATES.inv_end_date%TYPE,
14: invoice_date PN_VAR_GRP_DATES.invoice_date%TYPE,
15: inv_schedule_date PN_VAR_GRP_DATES.inv_schedule_date%TYPE,

Line 12: inv_start_date PN_VAR_GRP_DATES.inv_start_date%TYPE,

8: grp_start_date PN_VAR_GRP_DATES.grp_start_date%TYPE,
9: grp_end_date PN_VAR_GRP_DATES.grp_end_date%TYPE,
10: group_date PN_VAR_GRP_DATES.group_date%TYPE,
11: reptg_due_date PN_VAR_GRP_DATES.reptg_due_date%TYPE,
12: inv_start_date PN_VAR_GRP_DATES.inv_start_date%TYPE,
13: inv_end_date PN_VAR_GRP_DATES.inv_end_date%TYPE,
14: invoice_date PN_VAR_GRP_DATES.invoice_date%TYPE,
15: inv_schedule_date PN_VAR_GRP_DATES.inv_schedule_date%TYPE,
16: forecasted_exp_code PN_VAR_GRP_DATES.forecasted_exp_code%TYPE

Line 13: inv_end_date PN_VAR_GRP_DATES.inv_end_date%TYPE,

9: grp_end_date PN_VAR_GRP_DATES.grp_end_date%TYPE,
10: group_date PN_VAR_GRP_DATES.group_date%TYPE,
11: reptg_due_date PN_VAR_GRP_DATES.reptg_due_date%TYPE,
12: inv_start_date PN_VAR_GRP_DATES.inv_start_date%TYPE,
13: inv_end_date PN_VAR_GRP_DATES.inv_end_date%TYPE,
14: invoice_date PN_VAR_GRP_DATES.invoice_date%TYPE,
15: inv_schedule_date PN_VAR_GRP_DATES.inv_schedule_date%TYPE,
16: forecasted_exp_code PN_VAR_GRP_DATES.forecasted_exp_code%TYPE
17: );

Line 14: invoice_date PN_VAR_GRP_DATES.invoice_date%TYPE,

10: group_date PN_VAR_GRP_DATES.group_date%TYPE,
11: reptg_due_date PN_VAR_GRP_DATES.reptg_due_date%TYPE,
12: inv_start_date PN_VAR_GRP_DATES.inv_start_date%TYPE,
13: inv_end_date PN_VAR_GRP_DATES.inv_end_date%TYPE,
14: invoice_date PN_VAR_GRP_DATES.invoice_date%TYPE,
15: inv_schedule_date PN_VAR_GRP_DATES.inv_schedule_date%TYPE,
16: forecasted_exp_code PN_VAR_GRP_DATES.forecasted_exp_code%TYPE
17: );
18:

Line 15: inv_schedule_date PN_VAR_GRP_DATES.inv_schedule_date%TYPE,

11: reptg_due_date PN_VAR_GRP_DATES.reptg_due_date%TYPE,
12: inv_start_date PN_VAR_GRP_DATES.inv_start_date%TYPE,
13: inv_end_date PN_VAR_GRP_DATES.inv_end_date%TYPE,
14: invoice_date PN_VAR_GRP_DATES.invoice_date%TYPE,
15: inv_schedule_date PN_VAR_GRP_DATES.inv_schedule_date%TYPE,
16: forecasted_exp_code PN_VAR_GRP_DATES.forecasted_exp_code%TYPE
17: );
18:
19: TYPE proration_factor_rec IS RECORD (

Line 16: forecasted_exp_code PN_VAR_GRP_DATES.forecasted_exp_code%TYPE

12: inv_start_date PN_VAR_GRP_DATES.inv_start_date%TYPE,
13: inv_end_date PN_VAR_GRP_DATES.inv_end_date%TYPE,
14: invoice_date PN_VAR_GRP_DATES.invoice_date%TYPE,
15: inv_schedule_date PN_VAR_GRP_DATES.inv_schedule_date%TYPE,
16: forecasted_exp_code PN_VAR_GRP_DATES.forecasted_exp_code%TYPE
17: );
18:
19: TYPE proration_factor_rec IS RECORD (
20: per_start_proration PN_VAR_PERIODS.proration_factor%TYPE,

Line 24: grp_start_proration PN_VAR_GRP_DATES.proration_factor%TYPE,

20: per_start_proration PN_VAR_PERIODS.proration_factor%TYPE,
21: first_per_gl_days PN_VAR_PERIODS.proration_factor%TYPE,
22: per_end_proration PN_VAR_PERIODS.proration_factor%TYPE,
23: last_per_gl_days PN_VAR_PERIODS.proration_factor%TYPE,
24: grp_start_proration PN_VAR_GRP_DATES.proration_factor%TYPE,
25: first_grp_gl_days PN_VAR_GRP_DATES.proration_factor%TYPE,
26: grp_end_proration PN_VAR_GRP_DATES.proration_factor%TYPE,
27: last_grp_gl_days PN_VAR_GRP_DATES.proration_factor%TYPE
28: );

Line 25: first_grp_gl_days PN_VAR_GRP_DATES.proration_factor%TYPE,

21: first_per_gl_days PN_VAR_PERIODS.proration_factor%TYPE,
22: per_end_proration PN_VAR_PERIODS.proration_factor%TYPE,
23: last_per_gl_days PN_VAR_PERIODS.proration_factor%TYPE,
24: grp_start_proration PN_VAR_GRP_DATES.proration_factor%TYPE,
25: first_grp_gl_days PN_VAR_GRP_DATES.proration_factor%TYPE,
26: grp_end_proration PN_VAR_GRP_DATES.proration_factor%TYPE,
27: last_grp_gl_days PN_VAR_GRP_DATES.proration_factor%TYPE
28: );
29:

Line 26: grp_end_proration PN_VAR_GRP_DATES.proration_factor%TYPE,

22: per_end_proration PN_VAR_PERIODS.proration_factor%TYPE,
23: last_per_gl_days PN_VAR_PERIODS.proration_factor%TYPE,
24: grp_start_proration PN_VAR_GRP_DATES.proration_factor%TYPE,
25: first_grp_gl_days PN_VAR_GRP_DATES.proration_factor%TYPE,
26: grp_end_proration PN_VAR_GRP_DATES.proration_factor%TYPE,
27: last_grp_gl_days PN_VAR_GRP_DATES.proration_factor%TYPE
28: );
29:
30: PROCEDURE INSERT_PERIODS_ROW (

Line 27: last_grp_gl_days PN_VAR_GRP_DATES.proration_factor%TYPE

23: last_per_gl_days PN_VAR_PERIODS.proration_factor%TYPE,
24: grp_start_proration PN_VAR_GRP_DATES.proration_factor%TYPE,
25: first_grp_gl_days PN_VAR_GRP_DATES.proration_factor%TYPE,
26: grp_end_proration PN_VAR_GRP_DATES.proration_factor%TYPE,
27: last_grp_gl_days PN_VAR_GRP_DATES.proration_factor%TYPE
28: );
29:
30: PROCEDURE INSERT_PERIODS_ROW (
31: X_ROWID IN OUT NOCOPY VARCHAR2,