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 365: x_gl_date gl_period_statuses.start_date%type,

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

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

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

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

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

Line 385: l_period gl_period_statuses.period_name%TYPE;

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

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

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

Line 387: l_gl_date gl_period_statuses.start_date%type;

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

Line 513: FROM gl_period_statuses

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

Line 557: FROM gl_period_statuses

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

Line 606: FROM gl_period_statuses

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

Line 673: FROM gl_period_statuses

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

Line 725: FROM gl_period_statuses

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

Line 776: FROM gl_period_statuses

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

Line 843: FROM gl_period_statuses

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