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_CBC_PO_GRP dependencies on FINANCIALS_SYSTEM_PARAMETERS

Line 157: financials_system_parameters b

153: IS
154: CURSOR c_is_cbc_on IS
155: SELECT cbc_po_enable
156: FROM igc_cc_bc_enable a,
157: financials_system_parameters b
158: WHERE a.set_of_books_id = b.set_of_books_id;
159:
160: l_api_version CONSTANT NUMBER := 1.0;
161: l_api_name CONSTANT VARCHAR2(30) := 'IS_CBC_ENABLED';

Line 312: l_sob_id financials_system_parameters.set_of_books_id%TYPE;

308:
309: l_api_version CONSTANT NUMBER := 1.0;
310: l_api_name CONSTANT VARCHAR2(30) := 'CBC_HEADER_VALIDATIONS';
311:
312: l_sob_id financials_system_parameters.set_of_books_id%TYPE;
313: l_document_id NUMBER := to_number(p_document_id);
314: l_max_gl_date po_distributions.gl_encumbered_date%TYPE;
315: l_min_gl_date po_distributions.gl_encumbered_date%TYPE;
316: l_max_fiscal_year gl_periods.period_year%TYPE;

Line 318: l_req_encumbrance_flag financials_system_parameters.req_encumbrance_flag%TYPE;

314: l_max_gl_date po_distributions.gl_encumbered_date%TYPE;
315: l_min_gl_date po_distributions.gl_encumbered_date%TYPE;
316: l_max_fiscal_year gl_periods.period_year%TYPE;
317: l_min_fiscal_year gl_periods.period_year%TYPE;
318: l_req_encumbrance_flag financials_system_parameters.req_encumbrance_flag%TYPE;
319: l_purch_encumbrance_flag financials_system_parameters.purch_encumbrance_flag%TYPE;
320: e_document_not_found EXCEPTION;
321:
322: BEGIN

Line 319: l_purch_encumbrance_flag financials_system_parameters.purch_encumbrance_flag%TYPE;

315: l_min_gl_date po_distributions.gl_encumbered_date%TYPE;
316: l_max_fiscal_year gl_periods.period_year%TYPE;
317: l_min_fiscal_year gl_periods.period_year%TYPE;
318: l_req_encumbrance_flag financials_system_parameters.req_encumbrance_flag%TYPE;
319: l_purch_encumbrance_flag financials_system_parameters.purch_encumbrance_flag%TYPE;
320: e_document_not_found EXCEPTION;
321:
322: BEGIN
323:

Line 348: FROM financials_system_parameters;

344: -- Find the set of books id and encumbrance flags for requisitions and purchasing
345:
346: SELECT set_of_books_id,req_encumbrance_flag,purch_encumbrance_flag
347: INTO l_sob_id,l_req_encumbrance_flag,l_purch_encumbrance_flag
348: FROM financials_system_parameters;
349:
350:
351: IF (p_document_type = 'PO')
352: AND p_document_sub_type IN ('STANDARD','PLANNED')

Line 456: l_sob_id financials_system_parameters.set_of_books_id%TYPE;

452: ,p_cbc_acct_date IN DATE) IS
453:
454: l_api_version CONSTANT NUMBER := 1.0;
455: l_api_name CONSTANT VARCHAR2(30) := 'Valid_CBC_Acct_Date';
456: l_sob_id financials_system_parameters.set_of_books_id%TYPE;
457: l_req_encumbrance_flag financials_system_parameters.req_encumbrance_flag%TYPE;
458: l_purch_encumbrance_flag financials_system_parameters.purch_encumbrance_flag%TYPE;
459: l_fiscal_year NUMBER;
460: l_prev_fiscal_year NUMBER;

Line 457: l_req_encumbrance_flag financials_system_parameters.req_encumbrance_flag%TYPE;

453:
454: l_api_version CONSTANT NUMBER := 1.0;
455: l_api_name CONSTANT VARCHAR2(30) := 'Valid_CBC_Acct_Date';
456: l_sob_id financials_system_parameters.set_of_books_id%TYPE;
457: l_req_encumbrance_flag financials_system_parameters.req_encumbrance_flag%TYPE;
458: l_purch_encumbrance_flag financials_system_parameters.purch_encumbrance_flag%TYPE;
459: l_fiscal_year NUMBER;
460: l_prev_fiscal_year NUMBER;
461: l_dist_max_fiscal_year NUMBER;

Line 458: l_purch_encumbrance_flag financials_system_parameters.purch_encumbrance_flag%TYPE;

454: l_api_version CONSTANT NUMBER := 1.0;
455: l_api_name CONSTANT VARCHAR2(30) := 'Valid_CBC_Acct_Date';
456: l_sob_id financials_system_parameters.set_of_books_id%TYPE;
457: l_req_encumbrance_flag financials_system_parameters.req_encumbrance_flag%TYPE;
458: l_purch_encumbrance_flag financials_system_parameters.purch_encumbrance_flag%TYPE;
459: l_fiscal_year NUMBER;
460: l_prev_fiscal_year NUMBER;
461: l_dist_max_fiscal_year NUMBER;
462: l_dist_min_fiscal_year NUMBER;

Line 538: FROM financials_system_parameters;

534: ,set_of_books_id
535: INTO l_req_encumbrance_flag
536: ,l_purch_encumbrance_flag
537: ,l_sob_id
538: FROM financials_system_parameters;
539:
540: -- Check if we need to perform any validations
541:
542: IF NOT((p_document_type = 'PO'

Line 1106: FROM financials_system_parameters ;

1102: Cursor c_fin_info IS
1103: SELECT req_encumbrance_flag,
1104: purch_encumbrance_flag,
1105: set_of_books_id
1106: FROM financials_system_parameters ;
1107:
1108: -- Added for PRC.FP.J, get the accounting date for the
1109: -- Blanket Agreements for Standard Purchase Orders.
1110: Cursor c_max_bpa_po_date IS

Line 1458: FROM financials_system_parameters ;

1454: Cursor c_fin_info IS
1455: SELECT req_encumbrance_flag,
1456: purch_encumbrance_flag,
1457: set_of_books_id
1458: FROM financials_system_parameters ;
1459:
1460: l_bpa_enc_required_flag VARCHAR2(1);
1461:
1462: BEGIN

Line 1733: l_req_encumbrance_flag financials_system_parameters.req_encumbrance_flag%TYPE;

1729: l_po_gl_fiscal_year Number;
1730: l_rel_gl_fiscal_year Number;
1731: l_req_gl_fiscal_year Number;
1732:
1733: l_req_encumbrance_flag financials_system_parameters.req_encumbrance_flag%TYPE;
1734: l_purch_encumbrance_flag financials_system_parameters.purch_encumbrance_flag%TYPE;
1735: l_passed_validation Boolean;
1736:
1737: l_sob_id financials_system_parameters.set_of_books_id%TYPE;

Line 1734: l_purch_encumbrance_flag financials_system_parameters.purch_encumbrance_flag%TYPE;

1730: l_rel_gl_fiscal_year Number;
1731: l_req_gl_fiscal_year Number;
1732:
1733: l_req_encumbrance_flag financials_system_parameters.req_encumbrance_flag%TYPE;
1734: l_purch_encumbrance_flag financials_system_parameters.purch_encumbrance_flag%TYPE;
1735: l_passed_validation Boolean;
1736:
1737: l_sob_id financials_system_parameters.set_of_books_id%TYPE;
1738:

Line 1737: l_sob_id financials_system_parameters.set_of_books_id%TYPE;

1733: l_req_encumbrance_flag financials_system_parameters.req_encumbrance_flag%TYPE;
1734: l_purch_encumbrance_flag financials_system_parameters.purch_encumbrance_flag%TYPE;
1735: l_passed_validation Boolean;
1736:
1737: l_sob_id financials_system_parameters.set_of_books_id%TYPE;
1738:
1739: Begin
1740:
1741: --Standard Call to check for call compatibility

Line 1775: FROM financials_system_parameters;

1771: END IF;
1772:
1773: SELECT set_of_books_id,req_encumbrance_flag,purch_encumbrance_flag
1774: INTO l_sob_id,l_req_encumbrance_flag,l_purch_encumbrance_flag
1775: FROM financials_system_parameters;
1776:
1777:
1778: --Determine current fiscal year based on sysdate
1779: