APPS.PN_VAREN_PVT dependencies on PN_VAR_TEMPLATES_ALL

Line 5960: l_purpose_code pn_var_templates_all.purpose_code%TYPE;

5956: l_ret_status VARCHAR2 (1);
5957: l_return_msg VARCHAR2 (10);
5958: l_lease_commencement_date pn_lease_details_all.lease_commencement_date%TYPE;
5959: l_lease_termination_date pn_lease_details_all.lease_termination_date%TYPE;
5960: l_purpose_code pn_var_templates_all.purpose_code%TYPE;
5961: l_type_code pn_var_templates_all.type_code%TYPE;
5962: l_cumulative_vol pn_var_templates_all.cumulative_vol%TYPE;
5963: l_invoice_on pn_var_templates_all.invoice_on%TYPE;
5964: l_negative_rent pn_var_templates_all.negative_rent%TYPE;

Line 5961: l_type_code pn_var_templates_all.type_code%TYPE;

5957: l_return_msg VARCHAR2 (10);
5958: l_lease_commencement_date pn_lease_details_all.lease_commencement_date%TYPE;
5959: l_lease_termination_date pn_lease_details_all.lease_termination_date%TYPE;
5960: l_purpose_code pn_var_templates_all.purpose_code%TYPE;
5961: l_type_code pn_var_templates_all.type_code%TYPE;
5962: l_cumulative_vol pn_var_templates_all.cumulative_vol%TYPE;
5963: l_invoice_on pn_var_templates_all.invoice_on%TYPE;
5964: l_negative_rent pn_var_templates_all.negative_rent%TYPE;
5965: l_term_template_id pn_var_templates_all.term_template_id%TYPE;

Line 5962: l_cumulative_vol pn_var_templates_all.cumulative_vol%TYPE;

5958: l_lease_commencement_date pn_lease_details_all.lease_commencement_date%TYPE;
5959: l_lease_termination_date pn_lease_details_all.lease_termination_date%TYPE;
5960: l_purpose_code pn_var_templates_all.purpose_code%TYPE;
5961: l_type_code pn_var_templates_all.type_code%TYPE;
5962: l_cumulative_vol pn_var_templates_all.cumulative_vol%TYPE;
5963: l_invoice_on pn_var_templates_all.invoice_on%TYPE;
5964: l_negative_rent pn_var_templates_all.negative_rent%TYPE;
5965: l_term_template_id pn_var_templates_all.term_template_id%TYPE;
5966: l_abatement_amount pn_var_templates_all.abatement_amount%TYPE;

Line 5963: l_invoice_on pn_var_templates_all.invoice_on%TYPE;

5959: l_lease_termination_date pn_lease_details_all.lease_termination_date%TYPE;
5960: l_purpose_code pn_var_templates_all.purpose_code%TYPE;
5961: l_type_code pn_var_templates_all.type_code%TYPE;
5962: l_cumulative_vol pn_var_templates_all.cumulative_vol%TYPE;
5963: l_invoice_on pn_var_templates_all.invoice_on%TYPE;
5964: l_negative_rent pn_var_templates_all.negative_rent%TYPE;
5965: l_term_template_id pn_var_templates_all.term_template_id%TYPE;
5966: l_abatement_amount pn_var_templates_all.abatement_amount%TYPE;
5967: l_proration_rule pn_var_templates_all.proration_rule%TYPE;

Line 5964: l_negative_rent pn_var_templates_all.negative_rent%TYPE;

5960: l_purpose_code pn_var_templates_all.purpose_code%TYPE;
5961: l_type_code pn_var_templates_all.type_code%TYPE;
5962: l_cumulative_vol pn_var_templates_all.cumulative_vol%TYPE;
5963: l_invoice_on pn_var_templates_all.invoice_on%TYPE;
5964: l_negative_rent pn_var_templates_all.negative_rent%TYPE;
5965: l_term_template_id pn_var_templates_all.term_template_id%TYPE;
5966: l_abatement_amount pn_var_templates_all.abatement_amount%TYPE;
5967: l_proration_rule pn_var_templates_all.proration_rule%TYPE;
5968: l_vrg_reptg_freq_code pn_var_templates_all.vrg_reptg_freq_code%TYPE;

Line 5965: l_term_template_id pn_var_templates_all.term_template_id%TYPE;

5961: l_type_code pn_var_templates_all.type_code%TYPE;
5962: l_cumulative_vol pn_var_templates_all.cumulative_vol%TYPE;
5963: l_invoice_on pn_var_templates_all.invoice_on%TYPE;
5964: l_negative_rent pn_var_templates_all.negative_rent%TYPE;
5965: l_term_template_id pn_var_templates_all.term_template_id%TYPE;
5966: l_abatement_amount pn_var_templates_all.abatement_amount%TYPE;
5967: l_proration_rule pn_var_templates_all.proration_rule%TYPE;
5968: l_vrg_reptg_freq_code pn_var_templates_all.vrg_reptg_freq_code%TYPE;
5969: l_period_freq_code pn_var_templates_all.period_freq_code%TYPE;

Line 5966: l_abatement_amount pn_var_templates_all.abatement_amount%TYPE;

5962: l_cumulative_vol pn_var_templates_all.cumulative_vol%TYPE;
5963: l_invoice_on pn_var_templates_all.invoice_on%TYPE;
5964: l_negative_rent pn_var_templates_all.negative_rent%TYPE;
5965: l_term_template_id pn_var_templates_all.term_template_id%TYPE;
5966: l_abatement_amount pn_var_templates_all.abatement_amount%TYPE;
5967: l_proration_rule pn_var_templates_all.proration_rule%TYPE;
5968: l_vrg_reptg_freq_code pn_var_templates_all.vrg_reptg_freq_code%TYPE;
5969: l_period_freq_code pn_var_templates_all.period_freq_code%TYPE;
5970: l_use_gl_calendar pn_var_templates_all.use_gl_calendar%TYPE;

Line 5967: l_proration_rule pn_var_templates_all.proration_rule%TYPE;

5963: l_invoice_on pn_var_templates_all.invoice_on%TYPE;
5964: l_negative_rent pn_var_templates_all.negative_rent%TYPE;
5965: l_term_template_id pn_var_templates_all.term_template_id%TYPE;
5966: l_abatement_amount pn_var_templates_all.abatement_amount%TYPE;
5967: l_proration_rule pn_var_templates_all.proration_rule%TYPE;
5968: l_vrg_reptg_freq_code pn_var_templates_all.vrg_reptg_freq_code%TYPE;
5969: l_period_freq_code pn_var_templates_all.period_freq_code%TYPE;
5970: l_use_gl_calendar pn_var_templates_all.use_gl_calendar%TYPE;
5971: l_year_start_date pn_var_templates_all.year_start_date%TYPE;

Line 5968: l_vrg_reptg_freq_code pn_var_templates_all.vrg_reptg_freq_code%TYPE;

5964: l_negative_rent pn_var_templates_all.negative_rent%TYPE;
5965: l_term_template_id pn_var_templates_all.term_template_id%TYPE;
5966: l_abatement_amount pn_var_templates_all.abatement_amount%TYPE;
5967: l_proration_rule pn_var_templates_all.proration_rule%TYPE;
5968: l_vrg_reptg_freq_code pn_var_templates_all.vrg_reptg_freq_code%TYPE;
5969: l_period_freq_code pn_var_templates_all.period_freq_code%TYPE;
5970: l_use_gl_calendar pn_var_templates_all.use_gl_calendar%TYPE;
5971: l_year_start_date pn_var_templates_all.year_start_date%TYPE;
5972: l_gl_period_set_name pn_var_templates_all.gl_period_set_name%TYPE;

Line 5969: l_period_freq_code pn_var_templates_all.period_freq_code%TYPE;

5965: l_term_template_id pn_var_templates_all.term_template_id%TYPE;
5966: l_abatement_amount pn_var_templates_all.abatement_amount%TYPE;
5967: l_proration_rule pn_var_templates_all.proration_rule%TYPE;
5968: l_vrg_reptg_freq_code pn_var_templates_all.vrg_reptg_freq_code%TYPE;
5969: l_period_freq_code pn_var_templates_all.period_freq_code%TYPE;
5970: l_use_gl_calendar pn_var_templates_all.use_gl_calendar%TYPE;
5971: l_year_start_date pn_var_templates_all.year_start_date%TYPE;
5972: l_gl_period_set_name pn_var_templates_all.gl_period_set_name%TYPE;
5973: l_period_type pn_var_templates_all.period_type%TYPE;

Line 5970: l_use_gl_calendar pn_var_templates_all.use_gl_calendar%TYPE;

5966: l_abatement_amount pn_var_templates_all.abatement_amount%TYPE;
5967: l_proration_rule pn_var_templates_all.proration_rule%TYPE;
5968: l_vrg_reptg_freq_code pn_var_templates_all.vrg_reptg_freq_code%TYPE;
5969: l_period_freq_code pn_var_templates_all.period_freq_code%TYPE;
5970: l_use_gl_calendar pn_var_templates_all.use_gl_calendar%TYPE;
5971: l_year_start_date pn_var_templates_all.year_start_date%TYPE;
5972: l_gl_period_set_name pn_var_templates_all.gl_period_set_name%TYPE;
5973: l_period_type pn_var_templates_all.period_type%TYPE;
5974: l_reptg_freq_code pn_var_templates_all.reptg_freq_code%TYPE;

Line 5971: l_year_start_date pn_var_templates_all.year_start_date%TYPE;

5967: l_proration_rule pn_var_templates_all.proration_rule%TYPE;
5968: l_vrg_reptg_freq_code pn_var_templates_all.vrg_reptg_freq_code%TYPE;
5969: l_period_freq_code pn_var_templates_all.period_freq_code%TYPE;
5970: l_use_gl_calendar pn_var_templates_all.use_gl_calendar%TYPE;
5971: l_year_start_date pn_var_templates_all.year_start_date%TYPE;
5972: l_gl_period_set_name pn_var_templates_all.gl_period_set_name%TYPE;
5973: l_period_type pn_var_templates_all.period_type%TYPE;
5974: l_reptg_freq_code pn_var_templates_all.reptg_freq_code%TYPE;
5975: l_reptg_day_of_month pn_var_templates_all.reptg_day_of_month%TYPE;

Line 5972: l_gl_period_set_name pn_var_templates_all.gl_period_set_name%TYPE;

5968: l_vrg_reptg_freq_code pn_var_templates_all.vrg_reptg_freq_code%TYPE;
5969: l_period_freq_code pn_var_templates_all.period_freq_code%TYPE;
5970: l_use_gl_calendar pn_var_templates_all.use_gl_calendar%TYPE;
5971: l_year_start_date pn_var_templates_all.year_start_date%TYPE;
5972: l_gl_period_set_name pn_var_templates_all.gl_period_set_name%TYPE;
5973: l_period_type pn_var_templates_all.period_type%TYPE;
5974: l_reptg_freq_code pn_var_templates_all.reptg_freq_code%TYPE;
5975: l_reptg_day_of_month pn_var_templates_all.reptg_day_of_month%TYPE;
5976: l_reptg_days_after pn_var_templates_all.reptg_days_after%TYPE;

Line 5973: l_period_type pn_var_templates_all.period_type%TYPE;

5969: l_period_freq_code pn_var_templates_all.period_freq_code%TYPE;
5970: l_use_gl_calendar pn_var_templates_all.use_gl_calendar%TYPE;
5971: l_year_start_date pn_var_templates_all.year_start_date%TYPE;
5972: l_gl_period_set_name pn_var_templates_all.gl_period_set_name%TYPE;
5973: l_period_type pn_var_templates_all.period_type%TYPE;
5974: l_reptg_freq_code pn_var_templates_all.reptg_freq_code%TYPE;
5975: l_reptg_day_of_month pn_var_templates_all.reptg_day_of_month%TYPE;
5976: l_reptg_days_after pn_var_templates_all.reptg_days_after%TYPE;
5977: l_invg_freq_code pn_var_templates_all.invg_freq_code%TYPE;

Line 5974: l_reptg_freq_code pn_var_templates_all.reptg_freq_code%TYPE;

5970: l_use_gl_calendar pn_var_templates_all.use_gl_calendar%TYPE;
5971: l_year_start_date pn_var_templates_all.year_start_date%TYPE;
5972: l_gl_period_set_name pn_var_templates_all.gl_period_set_name%TYPE;
5973: l_period_type pn_var_templates_all.period_type%TYPE;
5974: l_reptg_freq_code pn_var_templates_all.reptg_freq_code%TYPE;
5975: l_reptg_day_of_month pn_var_templates_all.reptg_day_of_month%TYPE;
5976: l_reptg_days_after pn_var_templates_all.reptg_days_after%TYPE;
5977: l_invg_freq_code pn_var_templates_all.invg_freq_code%TYPE;
5978: l_invg_spread_code pn_var_templates_all.invg_spread_code%TYPE;

Line 5975: l_reptg_day_of_month pn_var_templates_all.reptg_day_of_month%TYPE;

5971: l_year_start_date pn_var_templates_all.year_start_date%TYPE;
5972: l_gl_period_set_name pn_var_templates_all.gl_period_set_name%TYPE;
5973: l_period_type pn_var_templates_all.period_type%TYPE;
5974: l_reptg_freq_code pn_var_templates_all.reptg_freq_code%TYPE;
5975: l_reptg_day_of_month pn_var_templates_all.reptg_day_of_month%TYPE;
5976: l_reptg_days_after pn_var_templates_all.reptg_days_after%TYPE;
5977: l_invg_freq_code pn_var_templates_all.invg_freq_code%TYPE;
5978: l_invg_spread_code pn_var_templates_all.invg_spread_code%TYPE;
5979: l_invg_day_of_month pn_var_templates_all.invg_day_of_month%TYPE;

Line 5976: l_reptg_days_after pn_var_templates_all.reptg_days_after%TYPE;

5972: l_gl_period_set_name pn_var_templates_all.gl_period_set_name%TYPE;
5973: l_period_type pn_var_templates_all.period_type%TYPE;
5974: l_reptg_freq_code pn_var_templates_all.reptg_freq_code%TYPE;
5975: l_reptg_day_of_month pn_var_templates_all.reptg_day_of_month%TYPE;
5976: l_reptg_days_after pn_var_templates_all.reptg_days_after%TYPE;
5977: l_invg_freq_code pn_var_templates_all.invg_freq_code%TYPE;
5978: l_invg_spread_code pn_var_templates_all.invg_spread_code%TYPE;
5979: l_invg_day_of_month pn_var_templates_all.invg_day_of_month%TYPE;
5980: l_invg_days_after pn_var_templates_all.invg_days_after%TYPE;

Line 5977: l_invg_freq_code pn_var_templates_all.invg_freq_code%TYPE;

5973: l_period_type pn_var_templates_all.period_type%TYPE;
5974: l_reptg_freq_code pn_var_templates_all.reptg_freq_code%TYPE;
5975: l_reptg_day_of_month pn_var_templates_all.reptg_day_of_month%TYPE;
5976: l_reptg_days_after pn_var_templates_all.reptg_days_after%TYPE;
5977: l_invg_freq_code pn_var_templates_all.invg_freq_code%TYPE;
5978: l_invg_spread_code pn_var_templates_all.invg_spread_code%TYPE;
5979: l_invg_day_of_month pn_var_templates_all.invg_day_of_month%TYPE;
5980: l_invg_days_after pn_var_templates_all.invg_days_after%TYPE;
5981: l_comments pn_var_templates_all.comments%TYPE;

Line 5978: l_invg_spread_code pn_var_templates_all.invg_spread_code%TYPE;

5974: l_reptg_freq_code pn_var_templates_all.reptg_freq_code%TYPE;
5975: l_reptg_day_of_month pn_var_templates_all.reptg_day_of_month%TYPE;
5976: l_reptg_days_after pn_var_templates_all.reptg_days_after%TYPE;
5977: l_invg_freq_code pn_var_templates_all.invg_freq_code%TYPE;
5978: l_invg_spread_code pn_var_templates_all.invg_spread_code%TYPE;
5979: l_invg_day_of_month pn_var_templates_all.invg_day_of_month%TYPE;
5980: l_invg_days_after pn_var_templates_all.invg_days_after%TYPE;
5981: l_comments pn_var_templates_all.comments%TYPE;
5982: l_auto_var_rent_id pn_var_rents_all.var_rent_id%TYPE;

Line 5979: l_invg_day_of_month pn_var_templates_all.invg_day_of_month%TYPE;

5975: l_reptg_day_of_month pn_var_templates_all.reptg_day_of_month%TYPE;
5976: l_reptg_days_after pn_var_templates_all.reptg_days_after%TYPE;
5977: l_invg_freq_code pn_var_templates_all.invg_freq_code%TYPE;
5978: l_invg_spread_code pn_var_templates_all.invg_spread_code%TYPE;
5979: l_invg_day_of_month pn_var_templates_all.invg_day_of_month%TYPE;
5980: l_invg_days_after pn_var_templates_all.invg_days_after%TYPE;
5981: l_comments pn_var_templates_all.comments%TYPE;
5982: l_auto_var_rent_id pn_var_rents_all.var_rent_id%TYPE;
5983: l_auto_var_rent_num pn_system_setup_options.auto_var_rent_num_gen%TYPE;

Line 5980: l_invg_days_after pn_var_templates_all.invg_days_after%TYPE;

5976: l_reptg_days_after pn_var_templates_all.reptg_days_after%TYPE;
5977: l_invg_freq_code pn_var_templates_all.invg_freq_code%TYPE;
5978: l_invg_spread_code pn_var_templates_all.invg_spread_code%TYPE;
5979: l_invg_day_of_month pn_var_templates_all.invg_day_of_month%TYPE;
5980: l_invg_days_after pn_var_templates_all.invg_days_after%TYPE;
5981: l_comments pn_var_templates_all.comments%TYPE;
5982: l_auto_var_rent_id pn_var_rents_all.var_rent_id%TYPE;
5983: l_auto_var_rent_num pn_system_setup_options.auto_var_rent_num_gen%TYPE;
5984:

Line 5981: l_comments pn_var_templates_all.comments%TYPE;

5977: l_invg_freq_code pn_var_templates_all.invg_freq_code%TYPE;
5978: l_invg_spread_code pn_var_templates_all.invg_spread_code%TYPE;
5979: l_invg_day_of_month pn_var_templates_all.invg_day_of_month%TYPE;
5980: l_invg_days_after pn_var_templates_all.invg_days_after%TYPE;
5981: l_comments pn_var_templates_all.comments%TYPE;
5982: l_auto_var_rent_id pn_var_rents_all.var_rent_id%TYPE;
5983: l_auto_var_rent_num pn_system_setup_options.auto_var_rent_num_gen%TYPE;
5984:
5985: l_proration_days NUMBER;

Line 7726: l_purpose_code pn_var_templates_all.purpose_code%TYPE;

7722: l_ret_status VARCHAR2 (1);
7723: l_return_msg VARCHAR2 (2000);
7724: l_lease_commencement_date pn_lease_details_all.lease_commencement_date%TYPE;
7725: l_lease_termination_date pn_lease_details_all.lease_termination_date%TYPE;
7726: l_purpose_code pn_var_templates_all.purpose_code%TYPE;
7727: l_type_code pn_var_templates_all.type_code%TYPE;
7728: l_cumulative_vol pn_var_templates_all.cumulative_vol%TYPE;
7729: l_invoice_on pn_var_templates_all.invoice_on%TYPE;
7730: l_negative_rent pn_var_templates_all.negative_rent%TYPE;

Line 7727: l_type_code pn_var_templates_all.type_code%TYPE;

7723: l_return_msg VARCHAR2 (2000);
7724: l_lease_commencement_date pn_lease_details_all.lease_commencement_date%TYPE;
7725: l_lease_termination_date pn_lease_details_all.lease_termination_date%TYPE;
7726: l_purpose_code pn_var_templates_all.purpose_code%TYPE;
7727: l_type_code pn_var_templates_all.type_code%TYPE;
7728: l_cumulative_vol pn_var_templates_all.cumulative_vol%TYPE;
7729: l_invoice_on pn_var_templates_all.invoice_on%TYPE;
7730: l_negative_rent pn_var_templates_all.negative_rent%TYPE;
7731: l_term_template_id pn_var_templates_all.term_template_id%TYPE;

Line 7728: l_cumulative_vol pn_var_templates_all.cumulative_vol%TYPE;

7724: l_lease_commencement_date pn_lease_details_all.lease_commencement_date%TYPE;
7725: l_lease_termination_date pn_lease_details_all.lease_termination_date%TYPE;
7726: l_purpose_code pn_var_templates_all.purpose_code%TYPE;
7727: l_type_code pn_var_templates_all.type_code%TYPE;
7728: l_cumulative_vol pn_var_templates_all.cumulative_vol%TYPE;
7729: l_invoice_on pn_var_templates_all.invoice_on%TYPE;
7730: l_negative_rent pn_var_templates_all.negative_rent%TYPE;
7731: l_term_template_id pn_var_templates_all.term_template_id%TYPE;
7732: l_abatement_amount pn_var_templates_all.abatement_amount%TYPE;

Line 7729: l_invoice_on pn_var_templates_all.invoice_on%TYPE;

7725: l_lease_termination_date pn_lease_details_all.lease_termination_date%TYPE;
7726: l_purpose_code pn_var_templates_all.purpose_code%TYPE;
7727: l_type_code pn_var_templates_all.type_code%TYPE;
7728: l_cumulative_vol pn_var_templates_all.cumulative_vol%TYPE;
7729: l_invoice_on pn_var_templates_all.invoice_on%TYPE;
7730: l_negative_rent pn_var_templates_all.negative_rent%TYPE;
7731: l_term_template_id pn_var_templates_all.term_template_id%TYPE;
7732: l_abatement_amount pn_var_templates_all.abatement_amount%TYPE;
7733: l_proration_rule pn_var_templates_all.proration_rule%TYPE;

Line 7730: l_negative_rent pn_var_templates_all.negative_rent%TYPE;

7726: l_purpose_code pn_var_templates_all.purpose_code%TYPE;
7727: l_type_code pn_var_templates_all.type_code%TYPE;
7728: l_cumulative_vol pn_var_templates_all.cumulative_vol%TYPE;
7729: l_invoice_on pn_var_templates_all.invoice_on%TYPE;
7730: l_negative_rent pn_var_templates_all.negative_rent%TYPE;
7731: l_term_template_id pn_var_templates_all.term_template_id%TYPE;
7732: l_abatement_amount pn_var_templates_all.abatement_amount%TYPE;
7733: l_proration_rule pn_var_templates_all.proration_rule%TYPE;
7734: l_vrg_reptg_freq_code pn_var_templates_all.vrg_reptg_freq_code%TYPE;

Line 7731: l_term_template_id pn_var_templates_all.term_template_id%TYPE;

7727: l_type_code pn_var_templates_all.type_code%TYPE;
7728: l_cumulative_vol pn_var_templates_all.cumulative_vol%TYPE;
7729: l_invoice_on pn_var_templates_all.invoice_on%TYPE;
7730: l_negative_rent pn_var_templates_all.negative_rent%TYPE;
7731: l_term_template_id pn_var_templates_all.term_template_id%TYPE;
7732: l_abatement_amount pn_var_templates_all.abatement_amount%TYPE;
7733: l_proration_rule pn_var_templates_all.proration_rule%TYPE;
7734: l_vrg_reptg_freq_code pn_var_templates_all.vrg_reptg_freq_code%TYPE;
7735: l_period_freq_code pn_var_templates_all.period_freq_code%TYPE;

Line 7732: l_abatement_amount pn_var_templates_all.abatement_amount%TYPE;

7728: l_cumulative_vol pn_var_templates_all.cumulative_vol%TYPE;
7729: l_invoice_on pn_var_templates_all.invoice_on%TYPE;
7730: l_negative_rent pn_var_templates_all.negative_rent%TYPE;
7731: l_term_template_id pn_var_templates_all.term_template_id%TYPE;
7732: l_abatement_amount pn_var_templates_all.abatement_amount%TYPE;
7733: l_proration_rule pn_var_templates_all.proration_rule%TYPE;
7734: l_vrg_reptg_freq_code pn_var_templates_all.vrg_reptg_freq_code%TYPE;
7735: l_period_freq_code pn_var_templates_all.period_freq_code%TYPE;
7736: l_use_gl_calendar pn_var_templates_all.use_gl_calendar%TYPE;

Line 7733: l_proration_rule pn_var_templates_all.proration_rule%TYPE;

7729: l_invoice_on pn_var_templates_all.invoice_on%TYPE;
7730: l_negative_rent pn_var_templates_all.negative_rent%TYPE;
7731: l_term_template_id pn_var_templates_all.term_template_id%TYPE;
7732: l_abatement_amount pn_var_templates_all.abatement_amount%TYPE;
7733: l_proration_rule pn_var_templates_all.proration_rule%TYPE;
7734: l_vrg_reptg_freq_code pn_var_templates_all.vrg_reptg_freq_code%TYPE;
7735: l_period_freq_code pn_var_templates_all.period_freq_code%TYPE;
7736: l_use_gl_calendar pn_var_templates_all.use_gl_calendar%TYPE;
7737: l_year_start_date pn_var_templates_all.year_start_date%TYPE := TO_DATE ('01-01-2000'

Line 7734: l_vrg_reptg_freq_code pn_var_templates_all.vrg_reptg_freq_code%TYPE;

7730: l_negative_rent pn_var_templates_all.negative_rent%TYPE;
7731: l_term_template_id pn_var_templates_all.term_template_id%TYPE;
7732: l_abatement_amount pn_var_templates_all.abatement_amount%TYPE;
7733: l_proration_rule pn_var_templates_all.proration_rule%TYPE;
7734: l_vrg_reptg_freq_code pn_var_templates_all.vrg_reptg_freq_code%TYPE;
7735: l_period_freq_code pn_var_templates_all.period_freq_code%TYPE;
7736: l_use_gl_calendar pn_var_templates_all.use_gl_calendar%TYPE;
7737: l_year_start_date pn_var_templates_all.year_start_date%TYPE := TO_DATE ('01-01-2000'
7738: , 'DD-MM-RRRR'

Line 7735: l_period_freq_code pn_var_templates_all.period_freq_code%TYPE;

7731: l_term_template_id pn_var_templates_all.term_template_id%TYPE;
7732: l_abatement_amount pn_var_templates_all.abatement_amount%TYPE;
7733: l_proration_rule pn_var_templates_all.proration_rule%TYPE;
7734: l_vrg_reptg_freq_code pn_var_templates_all.vrg_reptg_freq_code%TYPE;
7735: l_period_freq_code pn_var_templates_all.period_freq_code%TYPE;
7736: l_use_gl_calendar pn_var_templates_all.use_gl_calendar%TYPE;
7737: l_year_start_date pn_var_templates_all.year_start_date%TYPE := TO_DATE ('01-01-2000'
7738: , 'DD-MM-RRRR'
7739: );

Line 7736: l_use_gl_calendar pn_var_templates_all.use_gl_calendar%TYPE;

7732: l_abatement_amount pn_var_templates_all.abatement_amount%TYPE;
7733: l_proration_rule pn_var_templates_all.proration_rule%TYPE;
7734: l_vrg_reptg_freq_code pn_var_templates_all.vrg_reptg_freq_code%TYPE;
7735: l_period_freq_code pn_var_templates_all.period_freq_code%TYPE;
7736: l_use_gl_calendar pn_var_templates_all.use_gl_calendar%TYPE;
7737: l_year_start_date pn_var_templates_all.year_start_date%TYPE := TO_DATE ('01-01-2000'
7738: , 'DD-MM-RRRR'
7739: );
7740: l_gl_period_set_name pn_var_templates_all.gl_period_set_name%TYPE;

Line 7737: l_year_start_date pn_var_templates_all.year_start_date%TYPE := TO_DATE ('01-01-2000'

7733: l_proration_rule pn_var_templates_all.proration_rule%TYPE;
7734: l_vrg_reptg_freq_code pn_var_templates_all.vrg_reptg_freq_code%TYPE;
7735: l_period_freq_code pn_var_templates_all.period_freq_code%TYPE;
7736: l_use_gl_calendar pn_var_templates_all.use_gl_calendar%TYPE;
7737: l_year_start_date pn_var_templates_all.year_start_date%TYPE := TO_DATE ('01-01-2000'
7738: , 'DD-MM-RRRR'
7739: );
7740: l_gl_period_set_name pn_var_templates_all.gl_period_set_name%TYPE;
7741: l_period_type pn_var_templates_all.period_type%TYPE;

Line 7740: l_gl_period_set_name pn_var_templates_all.gl_period_set_name%TYPE;

7736: l_use_gl_calendar pn_var_templates_all.use_gl_calendar%TYPE;
7737: l_year_start_date pn_var_templates_all.year_start_date%TYPE := TO_DATE ('01-01-2000'
7738: , 'DD-MM-RRRR'
7739: );
7740: l_gl_period_set_name pn_var_templates_all.gl_period_set_name%TYPE;
7741: l_period_type pn_var_templates_all.period_type%TYPE;
7742: l_reptg_freq_code pn_var_templates_all.reptg_freq_code%TYPE;
7743: l_reptg_day_of_month pn_var_templates_all.reptg_day_of_month%TYPE;
7744: l_reptg_days_after pn_var_templates_all.reptg_days_after%TYPE;

Line 7741: l_period_type pn_var_templates_all.period_type%TYPE;

7737: l_year_start_date pn_var_templates_all.year_start_date%TYPE := TO_DATE ('01-01-2000'
7738: , 'DD-MM-RRRR'
7739: );
7740: l_gl_period_set_name pn_var_templates_all.gl_period_set_name%TYPE;
7741: l_period_type pn_var_templates_all.period_type%TYPE;
7742: l_reptg_freq_code pn_var_templates_all.reptg_freq_code%TYPE;
7743: l_reptg_day_of_month pn_var_templates_all.reptg_day_of_month%TYPE;
7744: l_reptg_days_after pn_var_templates_all.reptg_days_after%TYPE;
7745: l_invg_freq_code pn_var_templates_all.invg_freq_code%TYPE;

Line 7742: l_reptg_freq_code pn_var_templates_all.reptg_freq_code%TYPE;

7738: , 'DD-MM-RRRR'
7739: );
7740: l_gl_period_set_name pn_var_templates_all.gl_period_set_name%TYPE;
7741: l_period_type pn_var_templates_all.period_type%TYPE;
7742: l_reptg_freq_code pn_var_templates_all.reptg_freq_code%TYPE;
7743: l_reptg_day_of_month pn_var_templates_all.reptg_day_of_month%TYPE;
7744: l_reptg_days_after pn_var_templates_all.reptg_days_after%TYPE;
7745: l_invg_freq_code pn_var_templates_all.invg_freq_code%TYPE;
7746: l_invg_spread_code pn_var_templates_all.invg_spread_code%TYPE;

Line 7743: l_reptg_day_of_month pn_var_templates_all.reptg_day_of_month%TYPE;

7739: );
7740: l_gl_period_set_name pn_var_templates_all.gl_period_set_name%TYPE;
7741: l_period_type pn_var_templates_all.period_type%TYPE;
7742: l_reptg_freq_code pn_var_templates_all.reptg_freq_code%TYPE;
7743: l_reptg_day_of_month pn_var_templates_all.reptg_day_of_month%TYPE;
7744: l_reptg_days_after pn_var_templates_all.reptg_days_after%TYPE;
7745: l_invg_freq_code pn_var_templates_all.invg_freq_code%TYPE;
7746: l_invg_spread_code pn_var_templates_all.invg_spread_code%TYPE;
7747: l_invg_day_of_month pn_var_templates_all.invg_day_of_month%TYPE;

Line 7744: l_reptg_days_after pn_var_templates_all.reptg_days_after%TYPE;

7740: l_gl_period_set_name pn_var_templates_all.gl_period_set_name%TYPE;
7741: l_period_type pn_var_templates_all.period_type%TYPE;
7742: l_reptg_freq_code pn_var_templates_all.reptg_freq_code%TYPE;
7743: l_reptg_day_of_month pn_var_templates_all.reptg_day_of_month%TYPE;
7744: l_reptg_days_after pn_var_templates_all.reptg_days_after%TYPE;
7745: l_invg_freq_code pn_var_templates_all.invg_freq_code%TYPE;
7746: l_invg_spread_code pn_var_templates_all.invg_spread_code%TYPE;
7747: l_invg_day_of_month pn_var_templates_all.invg_day_of_month%TYPE;
7748: l_invg_days_after pn_var_templates_all.invg_days_after%TYPE;

Line 7745: l_invg_freq_code pn_var_templates_all.invg_freq_code%TYPE;

7741: l_period_type pn_var_templates_all.period_type%TYPE;
7742: l_reptg_freq_code pn_var_templates_all.reptg_freq_code%TYPE;
7743: l_reptg_day_of_month pn_var_templates_all.reptg_day_of_month%TYPE;
7744: l_reptg_days_after pn_var_templates_all.reptg_days_after%TYPE;
7745: l_invg_freq_code pn_var_templates_all.invg_freq_code%TYPE;
7746: l_invg_spread_code pn_var_templates_all.invg_spread_code%TYPE;
7747: l_invg_day_of_month pn_var_templates_all.invg_day_of_month%TYPE;
7748: l_invg_days_after pn_var_templates_all.invg_days_after%TYPE;
7749: l_comments pn_var_templates_all.comments%TYPE;

Line 7746: l_invg_spread_code pn_var_templates_all.invg_spread_code%TYPE;

7742: l_reptg_freq_code pn_var_templates_all.reptg_freq_code%TYPE;
7743: l_reptg_day_of_month pn_var_templates_all.reptg_day_of_month%TYPE;
7744: l_reptg_days_after pn_var_templates_all.reptg_days_after%TYPE;
7745: l_invg_freq_code pn_var_templates_all.invg_freq_code%TYPE;
7746: l_invg_spread_code pn_var_templates_all.invg_spread_code%TYPE;
7747: l_invg_day_of_month pn_var_templates_all.invg_day_of_month%TYPE;
7748: l_invg_days_after pn_var_templates_all.invg_days_after%TYPE;
7749: l_comments pn_var_templates_all.comments%TYPE;
7750: BEGIN

Line 7747: l_invg_day_of_month pn_var_templates_all.invg_day_of_month%TYPE;

7743: l_reptg_day_of_month pn_var_templates_all.reptg_day_of_month%TYPE;
7744: l_reptg_days_after pn_var_templates_all.reptg_days_after%TYPE;
7745: l_invg_freq_code pn_var_templates_all.invg_freq_code%TYPE;
7746: l_invg_spread_code pn_var_templates_all.invg_spread_code%TYPE;
7747: l_invg_day_of_month pn_var_templates_all.invg_day_of_month%TYPE;
7748: l_invg_days_after pn_var_templates_all.invg_days_after%TYPE;
7749: l_comments pn_var_templates_all.comments%TYPE;
7750: BEGIN
7751: -----------------------------------------

Line 7748: l_invg_days_after pn_var_templates_all.invg_days_after%TYPE;

7744: l_reptg_days_after pn_var_templates_all.reptg_days_after%TYPE;
7745: l_invg_freq_code pn_var_templates_all.invg_freq_code%TYPE;
7746: l_invg_spread_code pn_var_templates_all.invg_spread_code%TYPE;
7747: l_invg_day_of_month pn_var_templates_all.invg_day_of_month%TYPE;
7748: l_invg_days_after pn_var_templates_all.invg_days_after%TYPE;
7749: l_comments pn_var_templates_all.comments%TYPE;
7750: BEGIN
7751: -----------------------------------------
7752: --Agreement Template validation

Line 7749: l_comments pn_var_templates_all.comments%TYPE;

7745: l_invg_freq_code pn_var_templates_all.invg_freq_code%TYPE;
7746: l_invg_spread_code pn_var_templates_all.invg_spread_code%TYPE;
7747: l_invg_day_of_month pn_var_templates_all.invg_day_of_month%TYPE;
7748: l_invg_days_after pn_var_templates_all.invg_days_after%TYPE;
7749: l_comments pn_var_templates_all.comments%TYPE;
7750: BEGIN
7751: -----------------------------------------
7752: --Agreement Template validation
7753: -----------------------------------------