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,
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,
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,
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,
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,
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
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: );
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:
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 (
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,
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: );
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:
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 (
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,