APPS.IGC_CC_PO_INTERFACE_PKG dependencies on GL_PERIODS

Line 632: FROM gl_periods gp, gl_sets_of_books gb

628: /* Removed the hard coded reference to period type of CC Month to fix bug 1427486*/
629: BEGIN
630: SELECT period_name
631: INTO l_po_dist_rec.gl_encumbered_period_name
632: FROM gl_periods gp, gl_sets_of_books gb
633: WHERE gb.set_of_books_id = p_cc_headers_rec.set_of_books_id AND
634: gp.period_set_name = gb.period_set_name AND
635: /* Begin Fix for bug 1569257 */
636: gp.adjustment_period_flag = 'N' AND

Line 804: l_start_date gl_periods.start_date%TYPE;

800: e_line_locations EXCEPTION;
801: e_internal_error EXCEPTION;
802: e_unable_to_open_po EXCEPTION;
803:
804: l_start_date gl_periods.start_date%TYPE;
805: l_end_date gl_periods.end_date%TYPE;
806: l_curr_year_pf_lines NUMBER;
807:
808: /* Start Date and End Date of current fiscal year for set of books

Line 805: l_end_date gl_periods.end_date%TYPE;

801: e_internal_error EXCEPTION;
802: e_unable_to_open_po EXCEPTION;
803:
804: l_start_date gl_periods.start_date%TYPE;
805: l_end_date gl_periods.end_date%TYPE;
806: l_curr_year_pf_lines NUMBER;
807:
808: /* Start Date and End Date of current fiscal year for set of books
809: indicated by p_sob_id */

Line 814: FROM GL_PERIODS GP,

810:
811: CURSOR c_fiscal_year_dates(p_sob_id NUMBER)
812: IS
813: SELECT MIN(start_date) start_date, MAX(end_date) end_date
814: FROM GL_PERIODS GP,
815: GL_SETS_OF_BOOKS GB
816: WHERE
817: GP.period_set_name = GB.period_set_name AND
818: GP.period_type = GB.accounted_period_type AND

Line 1181: l_encumbered_period_name gl_periods.period_name%TYPE;

1177: l_po_lines_rec po_lines_all%ROWTYPE;
1178: l_po_line_locs_rec po_line_locations_all%ROWTYPE;
1179: l_po_dist_rec po_distributions_all%ROWTYPE;
1180:
1181: l_encumbered_period_name gl_periods.period_name%TYPE;
1182:
1183: l_new_account_line BOOLEAN;
1184:
1185: l_new_payment_forecast_line BOOLEAN;

Line 1205: l_start_date gl_periods.start_date%TYPE;

1201: e_line_locations EXCEPTION;
1202: e_internal_error EXCEPTION;
1203:
1204:
1205: l_start_date gl_periods.start_date%TYPE;
1206: l_end_date gl_periods.end_date%TYPE;
1207: l_curr_year_pf_lines NUMBER;
1208:
1209: /* Start Date and End Date of current fiscal year for set of books

Line 1206: l_end_date gl_periods.end_date%TYPE;

1202: e_internal_error EXCEPTION;
1203:
1204:
1205: l_start_date gl_periods.start_date%TYPE;
1206: l_end_date gl_periods.end_date%TYPE;
1207: l_curr_year_pf_lines NUMBER;
1208:
1209: /* Start Date and End Date of current fiscal year for set of books
1210: indicated by p_sob_id */

Line 1215: FROM GL_PERIODS GP,

1211:
1212: CURSOR c_fiscal_year_dates(p_sob_id NUMBER)
1213: IS
1214: SELECT MIN(start_date) start_date, MAX(end_date) end_date
1215: FROM GL_PERIODS GP,
1216: GL_SETS_OF_BOOKS GB
1217: WHERE
1218: GP.period_set_name = GB.period_set_name AND
1219: GP.period_type = GB.accounted_period_type AND