APPS.PMI_SALES_PKG dependencies on PMI_GL_CALENDAR_V

Line 476: p_From_period IN pmi_gl_calendar_v.period_name%TYPE,

472:
473: FUNCTION PMISA_VALIDATE_DATE(p_Sales_Company IN sy_orgn_mst.co_code%TYPE,
474: p_From_year IN number,
475: p_To_year IN number,
476: p_From_period IN pmi_gl_calendar_v.period_name%TYPE,
477: p_To_period IN pmi_gl_calendar_v.period_name%TYPE,
478: p_actual_date IN DATE
479: )
480: RETURN NUMBER IS

Line 477: p_To_period IN pmi_gl_calendar_v.period_name%TYPE,

473: FUNCTION PMISA_VALIDATE_DATE(p_Sales_Company IN sy_orgn_mst.co_code%TYPE,
474: p_From_year IN number,
475: p_To_year IN number,
476: p_From_period IN pmi_gl_calendar_v.period_name%TYPE,
477: p_To_period IN pmi_gl_calendar_v.period_name%TYPE,
478: p_actual_date IN DATE
479: )
480: RETURN NUMBER IS
481: BEGIN

Line 503: from pmi_gl_calendar_v

499: pv_pmisa_vd_from_period := p_From_period;
500: pv_pmisa_vd_to_period := p_To_period;
501: pv_pmisa_vd_Company := p_sales_company;
502: select start_date into pv_pmisa_vd_start_date
503: from pmi_gl_calendar_v
504: where period_year=p_from_year and period_name=p_from_period and co_code=p_sales_company;
505: select end_date into pv_pmisa_vd_end_date
506: from pmi_gl_calendar_v
507: where period_year=p_to_year and period_name=p_to_period and co_code=p_sales_company;

Line 506: from pmi_gl_calendar_v

502: select start_date into pv_pmisa_vd_start_date
503: from pmi_gl_calendar_v
504: where period_year=p_from_year and period_name=p_from_period and co_code=p_sales_company;
505: select end_date into pv_pmisa_vd_end_date
506: from pmi_gl_calendar_v
507: where period_year=p_to_year and period_name=p_to_period and co_code=p_sales_company;
508: IF (trunc(p_actual_date) between pv_pmisa_vd_start_date and pv_pmisa_vd_end_date) THEN
509: return 1;
510: ELSE