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.IGC_CC_COMMON_UTILS_PVT dependencies on GL_PERIOD_STATUSES

Line 363: x_gl_date gl_period_statuses.start_date%type,

359: END Get_Header_Desc;
360:
361:
362: FUNCTION DATE_IS_VALID(x_form_name VARCHAR2,
363: x_gl_date gl_period_statuses.start_date%type,
364: x_po_header_id po_headers_all.po_header_id%type,
365: x_po_line_id po_lines_all.po_line_id%type,
366: x_line_location_id po_line_locations_all.line_location_id%type,
367: x_po_distribution_id po_distributions_all.po_distribution_id%type,

Line 381: l_fiscal_year_invoice gl_period_statuses.period_year%type; /* fiscal year of invoice */

377: l_CC_CTRL_STATUS igc_cc_headers.CC_CTRL_STATUS%type;
378: l_CC_ENCMBRNC_STATUS igc_cc_headers.CC_ENCMBRNC_STATUS%type;
379: l_CC_APPRVL_STATUS igc_cc_headers.CC_APPRVL_STATUS%type;
380: l_status BOOLEAN; /* holds value whether the CC can be matched or not */
381: l_fiscal_year_invoice gl_period_statuses.period_year%type; /* fiscal year of invoice */
382: l_fiscal_year_pf gl_period_statuses.period_year%type; /* fiscal year of specific Payment Forecast line */
383: l_period gl_period_statuses.period_name%TYPE;
384: l_open_gl_date gl_period_statuses.start_date%type; /* Holds the next open gl date */
385: l_gl_date gl_period_statuses.start_date%type;

Line 382: l_fiscal_year_pf gl_period_statuses.period_year%type; /* fiscal year of specific Payment Forecast line */

378: l_CC_ENCMBRNC_STATUS igc_cc_headers.CC_ENCMBRNC_STATUS%type;
379: l_CC_APPRVL_STATUS igc_cc_headers.CC_APPRVL_STATUS%type;
380: l_status BOOLEAN; /* holds value whether the CC can be matched or not */
381: l_fiscal_year_invoice gl_period_statuses.period_year%type; /* fiscal year of invoice */
382: l_fiscal_year_pf gl_period_statuses.period_year%type; /* fiscal year of specific Payment Forecast line */
383: l_period gl_period_statuses.period_name%TYPE;
384: l_open_gl_date gl_period_statuses.start_date%type; /* Holds the next open gl date */
385: l_gl_date gl_period_statuses.start_date%type;
386: l_cc_det_pf_date igc_cc_det_pf.cc_det_pf_date%type;

Line 383: l_period gl_period_statuses.period_name%TYPE;

379: l_CC_APPRVL_STATUS igc_cc_headers.CC_APPRVL_STATUS%type;
380: l_status BOOLEAN; /* holds value whether the CC can be matched or not */
381: l_fiscal_year_invoice gl_period_statuses.period_year%type; /* fiscal year of invoice */
382: l_fiscal_year_pf gl_period_statuses.period_year%type; /* fiscal year of specific Payment Forecast line */
383: l_period gl_period_statuses.period_name%TYPE;
384: l_open_gl_date gl_period_statuses.start_date%type; /* Holds the next open gl date */
385: l_gl_date gl_period_statuses.start_date%type;
386: l_cc_det_pf_date igc_cc_det_pf.cc_det_pf_date%type;
387: l_shipment_num po_line_locations_all.shipment_num%type;

Line 384: l_open_gl_date gl_period_statuses.start_date%type; /* Holds the next open gl date */

380: l_status BOOLEAN; /* holds value whether the CC can be matched or not */
381: l_fiscal_year_invoice gl_period_statuses.period_year%type; /* fiscal year of invoice */
382: l_fiscal_year_pf gl_period_statuses.period_year%type; /* fiscal year of specific Payment Forecast line */
383: l_period gl_period_statuses.period_name%TYPE;
384: l_open_gl_date gl_period_statuses.start_date%type; /* Holds the next open gl date */
385: l_gl_date gl_period_statuses.start_date%type;
386: l_cc_det_pf_date igc_cc_det_pf.cc_det_pf_date%type;
387: l_shipment_num po_line_locations_all.shipment_num%type;
388: l_line_location_id po_line_locations_all.line_location_id%type;

Line 385: l_gl_date gl_period_statuses.start_date%type;

381: l_fiscal_year_invoice gl_period_statuses.period_year%type; /* fiscal year of invoice */
382: l_fiscal_year_pf gl_period_statuses.period_year%type; /* fiscal year of specific Payment Forecast line */
383: l_period gl_period_statuses.period_name%TYPE;
384: l_open_gl_date gl_period_statuses.start_date%type; /* Holds the next open gl date */
385: l_gl_date gl_period_statuses.start_date%type;
386: l_cc_det_pf_date igc_cc_det_pf.cc_det_pf_date%type;
387: l_shipment_num po_line_locations_all.shipment_num%type;
388: l_line_location_id po_line_locations_all.line_location_id%type;
389:

Line 511: FROM gl_period_statuses

507: /* Get the fiscal year of the invoice */
508: BEGIN
509: SELECT DISTINCT period_year
510: INTO l_fiscal_year_invoice
511: FROM gl_period_statuses
512: WHERE set_of_books_id = (SELECT set_of_books_id
513: FROM AP_SYSTEM_PARAMETERS)
514: AND l_gl_date BETWEEN START_DATE AND END_DATE;
515: EXCEPTION

Line 555: FROM gl_period_statuses

551: /* Get the fiscal year for the Payment Forecast Date */
552: BEGIN
553: SELECT DISTINCT period_year
554: INTO l_fiscal_year_pf
555: FROM gl_period_statuses
556: WHERE set_of_books_id = (SELECT set_of_books_id
557: FROM AP_SYSTEM_PARAMETERS)
558: AND l_CC_DET_PF_DATE BETWEEN START_DATE AND END_DATE;
559: EXCEPTION

Line 604: FROM gl_period_statuses

600: /* Get the fiscal year for the Payment Forecast Date */
601: BEGIN
602: SELECT DISTINCT period_year
603: INTO l_fiscal_year_pf
604: FROM gl_period_statuses
605: WHERE set_of_books_id = (SELECT set_of_books_id
606: FROM AP_SYSTEM_PARAMETERS)
607: AND l_pf_date BETWEEN START_DATE AND END_DATE;
608: EXCEPTION

Line 671: FROM gl_period_statuses

667:
668: BEGIN
669: SELECT DISTINCT period_year
670: INTO l_fiscal_year_pf
671: FROM gl_period_statuses
672: WHERE set_of_books_id = (SELECT set_of_books_id
673: FROM AP_SYSTEM_PARAMETERS)
674: AND l_cc_det_pf_date BETWEEN START_DATE AND END_DATE;
675: EXCEPTION

Line 723: FROM gl_period_statuses

719:
720: BEGIN
721: SELECT DISTINCT period_year
722: INTO l_fiscal_year_pf
723: FROM gl_period_statuses
724: WHERE set_of_books_id = (SELECT set_of_books_id
725: FROM AP_SYSTEM_PARAMETERS)
726: AND l_cc_det_pf_date BETWEEN START_DATE AND END_DATE;
727: EXCEPTION

Line 774: FROM gl_period_statuses

770:
771: BEGIN
772: SELECT DISTINCT period_year
773: INTO l_fiscal_year_pf
774: FROM gl_period_statuses
775: WHERE set_of_books_id = (SELECT set_of_books_id
776: FROM AP_SYSTEM_PARAMETERS)
777: AND l_cc_det_pf_date BETWEEN START_DATE AND END_DATE;
778: EXCEPTION

Line 841: FROM gl_period_statuses

837:
838: BEGIN
839: SELECT DISTINCT period_year
840: INTO l_fiscal_year_pf
841: FROM gl_period_statuses
842: WHERE set_of_books_id = (SELECT set_of_books_id
843: FROM AP_SYSTEM_PARAMETERS)
844: AND l_cc_det_pf_date BETWEEN START_DATE AND END_DATE;
845: EXCEPTION