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.JA_CN_GL_INTER_VALID_PKG dependencies on GL_PERIODS

Line 630: l_period_from GL_PERIODS.period_name%TYPE := P_START_PERIOD;

626:
627: l_le_id NUMBER := P_LE_ID;
628: l_coa_id NUMBER := P_COA_ID;
629: l_ledger_id NUMBER := P_LEDGER_ID;
630: l_period_from GL_PERIODS.period_name%TYPE := P_START_PERIOD;
631: l_period_to GL_PERIODS.period_name%TYPE := P_END_PERIOD;
632: l_source gl_je_sources_tl.je_source_name%TYPE :=P_SOURCE;
633: l_journal_ctg gl_je_categories_tl.user_je_category_name%TYPE :=P_JOURNAL_CTG;
634: l_le_name VARCHAR2(240);

Line 631: l_period_to GL_PERIODS.period_name%TYPE := P_END_PERIOD;

627: l_le_id NUMBER := P_LE_ID;
628: l_coa_id NUMBER := P_COA_ID;
629: l_ledger_id NUMBER := P_LEDGER_ID;
630: l_period_from GL_PERIODS.period_name%TYPE := P_START_PERIOD;
631: l_period_to GL_PERIODS.period_name%TYPE := P_END_PERIOD;
632: l_source gl_je_sources_tl.je_source_name%TYPE :=P_SOURCE;
633: l_journal_ctg gl_je_categories_tl.user_je_category_name%TYPE :=P_JOURNAL_CTG;
634: l_le_name VARCHAR2(240);
635: l_status GL_JE_HEADERS.STATUS%TYPE := P_STATUS;

Line 653: l_period_name gl_periods.period_name%TYPE;

649: l_xml_root XMLTYPE;
650:
651: l_dff_check VARCHAR2(1); --result of DFF Assignment check
652: --l_source_meaning varchar2(150); --meaning of GL journal OR InterCom Transaction
653: l_period_name gl_periods.period_name%TYPE;
654: l_period_year gl_periods.period_year%TYPE;
655: l_period_num gl_periods.period_num%TYPE;
656: l_ccid GL_CODE_COMBINATIONS.Code_Combination_Id%TYPE;
657: l_account VARCHAR2(2000); --account's flexfield

Line 654: l_period_year gl_periods.period_year%TYPE;

650:
651: l_dff_check VARCHAR2(1); --result of DFF Assignment check
652: --l_source_meaning varchar2(150); --meaning of GL journal OR InterCom Transaction
653: l_period_name gl_periods.period_name%TYPE;
654: l_period_year gl_periods.period_year%TYPE;
655: l_period_num gl_periods.period_num%TYPE;
656: l_ccid GL_CODE_COMBINATIONS.Code_Combination_Id%TYPE;
657: l_account VARCHAR2(2000); --account's flexfield
658: l_account_desc VARCHAR2(4000);--account's description

Line 655: l_period_num gl_periods.period_num%TYPE;

651: l_dff_check VARCHAR2(1); --result of DFF Assignment check
652: --l_source_meaning varchar2(150); --meaning of GL journal OR InterCom Transaction
653: l_period_name gl_periods.period_name%TYPE;
654: l_period_year gl_periods.period_year%TYPE;
655: l_period_num gl_periods.period_num%TYPE;
656: l_ccid GL_CODE_COMBINATIONS.Code_Combination_Id%TYPE;
657: l_account VARCHAR2(2000); --account's flexfield
658: l_account_desc VARCHAR2(4000);--account's description
659: l_cash_related_item varchar2(150); --cash related item of a line

Line 693: FROM gl_periods gp, GL_LEDGERS ledger

689:
690: --Cursor to get all periods between (P_START_PERIOD, P_END_PERIOD).
691: CURSOR c_period_name IS
692: SELECT gp.period_name, gp.period_year, gp.period_num
693: FROM gl_periods gp, GL_LEDGERS ledger
694: WHERE ledger.ledger_id = l_ledger_id --using variable P_LEDGER_ID
695: AND ledger.period_set_name = gp.PERIOD_SET_NAME
696: AND ledger.accounted_period_type = gp.period_type
697: AND gp.start_date between

Line 699: FROM GL_PERIODS GP

695: AND ledger.period_set_name = gp.PERIOD_SET_NAME
696: AND ledger.accounted_period_type = gp.period_type
697: AND gp.start_date between
698: (SELECT start_date
699: FROM GL_PERIODS GP
700: WHERE ledger.PERIOD_SET_NAME = GP.PERIOD_SET_NAME
701: AND ledger.ACCOUNTED_PERIOD_TYPE = GP.PERIOD_TYPE
702: AND GP.period_name = l_period_from) --using parameter P_START_PERIOD
703: and (SELECT start_date

Line 704: FROM GL_PERIODS GP

700: WHERE ledger.PERIOD_SET_NAME = GP.PERIOD_SET_NAME
701: AND ledger.ACCOUNTED_PERIOD_TYPE = GP.PERIOD_TYPE
702: AND GP.period_name = l_period_from) --using parameter P_START_PERIOD
703: and (SELECT start_date
704: FROM GL_PERIODS GP
705: WHERE ledger.PERIOD_SET_NAME = GP.PERIOD_SET_NAME
706: AND ledger.ACCOUNTED_PERIOD_TYPE = GP.PERIOD_TYPE
707: AND GP.period_name = l_period_to) --using parameter P_END_PERIOD
708: ORDER BY gp.start_date

Line 1288: l_period_from gl_periods.period_name%TYPE := P_START_PERIOD;

1284: l_coa_id NUMBER := P_COA_ID;
1285: l_le_id NUMBER := P_LE_ID;
1286: l_le_name VARCHAR2(240);
1287: l_ledger_id NUMBER := P_LEDGER_ID;
1288: l_period_from gl_periods.period_name%TYPE := P_START_PERIOD;
1289: l_period_to gl_periods.period_name%TYPE := P_END_PERIOD;
1290: l_com_seg VARCHAR2(25) := P_COM_SEG; --Added for CNAO Enhancement
1291: l_ledger_name VARCHAR2(30);
1292: --l_com_segment VARCHAR2(150) := P_COM_SEGMENT;

Line 1289: l_period_to gl_periods.period_name%TYPE := P_END_PERIOD;

1285: l_le_id NUMBER := P_LE_ID;
1286: l_le_name VARCHAR2(240);
1287: l_ledger_id NUMBER := P_LEDGER_ID;
1288: l_period_from gl_periods.period_name%TYPE := P_START_PERIOD;
1289: l_period_to gl_periods.period_name%TYPE := P_END_PERIOD;
1290: l_com_seg VARCHAR2(25) := P_COM_SEG; --Added for CNAO Enhancement
1291: l_ledger_name VARCHAR2(30);
1292: --l_com_segment VARCHAR2(150) := P_COM_SEGMENT;
1293: --l_status FUN_TRX_HEADERS.STATUS%TYPE := P_STATUS;

Line 1306: l_period_name gl_periods.period_name%TYPE;

1302: l_xml_root XMLTYPE;
1303:
1304: l_dff_check varchar2(1); --result of DFF Assignment check
1305: --l_source_meaning varchar2(150); --meaning of GL journal OR InterCom Transaction
1306: l_period_name gl_periods.period_name%TYPE;
1307: l_period_year gl_periods.period_year%TYPE;
1308: l_period_num gl_periods.period_num%TYPE;
1309: l_ccid GL_CODE_COMBINATIONS.Code_Combination_Id%TYPE;
1310: l_account VARCHAR2(2000); --account's flexfield

Line 1307: l_period_year gl_periods.period_year%TYPE;

1303:
1304: l_dff_check varchar2(1); --result of DFF Assignment check
1305: --l_source_meaning varchar2(150); --meaning of GL journal OR InterCom Transaction
1306: l_period_name gl_periods.period_name%TYPE;
1307: l_period_year gl_periods.period_year%TYPE;
1308: l_period_num gl_periods.period_num%TYPE;
1309: l_ccid GL_CODE_COMBINATIONS.Code_Combination_Id%TYPE;
1310: l_account VARCHAR2(2000); --account's flexfield
1311: l_account_desc VARCHAR2(4000); --account's description

Line 1308: l_period_num gl_periods.period_num%TYPE;

1304: l_dff_check varchar2(1); --result of DFF Assignment check
1305: --l_source_meaning varchar2(150); --meaning of GL journal OR InterCom Transaction
1306: l_period_name gl_periods.period_name%TYPE;
1307: l_period_year gl_periods.period_year%TYPE;
1308: l_period_num gl_periods.period_num%TYPE;
1309: l_ccid GL_CODE_COMBINATIONS.Code_Combination_Id%TYPE;
1310: l_account VARCHAR2(2000); --account's flexfield
1311: l_account_desc VARCHAR2(4000); --account's description
1312: l_cash_related_item varchar2(150); --cash related item of a line

Line 1379: FROM gl_periods gp, GL_LEDGERS ledger

1375: , gp.period_year
1376: , gp.period_num
1377: , gp.start_date
1378: , gp.end_date
1379: FROM gl_periods gp, GL_LEDGERS ledger
1380: WHERE ledger.ledger_id = l_ledger_id --using variable l_ledger_id
1381: AND ledger.period_set_name = GP.PERIOD_SET_NAME
1382: AND ledger.accounted_period_type = gp.period_type
1383: AND gp.start_date between

Line 1385: FROM GL_PERIODS GP

1381: AND ledger.period_set_name = GP.PERIOD_SET_NAME
1382: AND ledger.accounted_period_type = gp.period_type
1383: AND gp.start_date between
1384: (SELECT start_date
1385: FROM GL_PERIODS GP
1386: WHERE ledger.PERIOD_SET_NAME = GP.PERIOD_SET_NAME
1387: AND ledger.ACCOUNTED_PERIOD_TYPE = GP.PERIOD_TYPE
1388: AND gp.period_name = l_period_from) --using parameter P_START_PERIOD
1389: and (SELECT start_date

Line 1390: FROM GL_PERIODS GP

1386: WHERE ledger.PERIOD_SET_NAME = GP.PERIOD_SET_NAME
1387: AND ledger.ACCOUNTED_PERIOD_TYPE = GP.PERIOD_TYPE
1388: AND gp.period_name = l_period_from) --using parameter P_START_PERIOD
1389: and (SELECT start_date
1390: FROM GL_PERIODS GP
1391: WHERE ledger.PERIOD_SET_NAME = GP.PERIOD_SET_NAME
1392: AND ledger.ACCOUNTED_PERIOD_TYPE = GP.PERIOD_TYPE
1393: AND gp.period_name = l_period_to) --using parameter P_END_PERIOD
1394: ORDER BY gp.start_date