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 635: l_period_from GL_PERIODS.period_name%TYPE := P_START_PERIOD;

631:
632: l_le_id NUMBER := P_LE_ID;
633: l_coa_id NUMBER := P_COA_ID;
634: l_ledger_id NUMBER := P_LEDGER_ID;
635: l_period_from GL_PERIODS.period_name%TYPE := P_START_PERIOD;
636: l_period_to GL_PERIODS.period_name%TYPE := P_END_PERIOD;
637: l_source gl_je_sources_tl.je_source_name%TYPE :=P_SOURCE;
638: l_journal_ctg gl_je_categories_tl.user_je_category_name%TYPE :=P_JOURNAL_CTG;
639: l_le_name VARCHAR2(240);

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

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

Line 658: l_period_name gl_periods.period_name%TYPE;

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

Line 659: l_period_year gl_periods.period_year%TYPE;

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

Line 660: l_period_num gl_periods.period_num%TYPE;

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

Line 698: FROM gl_periods gp, GL_LEDGERS ledger

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

Line 704: FROM GL_PERIODS GP

700: AND ledger.period_set_name = gp.PERIOD_SET_NAME
701: AND ledger.accounted_period_type = gp.period_type
702: AND gp.start_date between
703: (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_from) --using parameter P_START_PERIOD
708: and (SELECT start_date

Line 709: 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_from) --using parameter P_START_PERIOD
708: and (SELECT start_date
709: FROM GL_PERIODS GP
710: WHERE ledger.PERIOD_SET_NAME = GP.PERIOD_SET_NAME
711: AND ledger.ACCOUNTED_PERIOD_TYPE = GP.PERIOD_TYPE
712: AND GP.period_name = l_period_to) --using parameter P_END_PERIOD
713: ORDER BY gp.start_date

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

1321: l_coa_id NUMBER := P_COA_ID;
1322: l_le_id NUMBER := P_LE_ID;
1323: l_le_name VARCHAR2(240);
1324: l_ledger_id NUMBER := P_LEDGER_ID;
1325: l_period_from gl_periods.period_name%TYPE := P_START_PERIOD;
1326: l_period_to gl_periods.period_name%TYPE := P_END_PERIOD;
1327: l_com_seg VARCHAR2(25) := P_COM_SEG; --Added for CNAO Enhancement
1328: l_ledger_name VARCHAR2(30);
1329: --l_com_segment VARCHAR2(150) := P_COM_SEGMENT;

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

1322: l_le_id NUMBER := P_LE_ID;
1323: l_le_name VARCHAR2(240);
1324: l_ledger_id NUMBER := P_LEDGER_ID;
1325: l_period_from gl_periods.period_name%TYPE := P_START_PERIOD;
1326: l_period_to gl_periods.period_name%TYPE := P_END_PERIOD;
1327: l_com_seg VARCHAR2(25) := P_COM_SEG; --Added for CNAO Enhancement
1328: l_ledger_name VARCHAR2(30);
1329: --l_com_segment VARCHAR2(150) := P_COM_SEGMENT;
1330: --l_status FUN_TRX_HEADERS.STATUS%TYPE := P_STATUS;

Line 1343: l_period_name gl_periods.period_name%TYPE;

1339: l_xml_root XMLTYPE;
1340:
1341: l_dff_check varchar2(1); --result of DFF Assignment check
1342: --l_source_meaning varchar2(150); --meaning of GL journal OR InterCom Transaction
1343: l_period_name gl_periods.period_name%TYPE;
1344: l_period_year gl_periods.period_year%TYPE;
1345: l_period_num gl_periods.period_num%TYPE;
1346: l_ccid GL_CODE_COMBINATIONS.Code_Combination_Id%TYPE;
1347: l_account VARCHAR2(2000); --account's flexfield

Line 1344: l_period_year gl_periods.period_year%TYPE;

1340:
1341: l_dff_check varchar2(1); --result of DFF Assignment check
1342: --l_source_meaning varchar2(150); --meaning of GL journal OR InterCom Transaction
1343: l_period_name gl_periods.period_name%TYPE;
1344: l_period_year gl_periods.period_year%TYPE;
1345: l_period_num gl_periods.period_num%TYPE;
1346: l_ccid GL_CODE_COMBINATIONS.Code_Combination_Id%TYPE;
1347: l_account VARCHAR2(2000); --account's flexfield
1348: l_account_desc VARCHAR2(4000); --account's description

Line 1345: l_period_num gl_periods.period_num%TYPE;

1341: l_dff_check varchar2(1); --result of DFF Assignment check
1342: --l_source_meaning varchar2(150); --meaning of GL journal OR InterCom Transaction
1343: l_period_name gl_periods.period_name%TYPE;
1344: l_period_year gl_periods.period_year%TYPE;
1345: l_period_num gl_periods.period_num%TYPE;
1346: l_ccid GL_CODE_COMBINATIONS.Code_Combination_Id%TYPE;
1347: l_account VARCHAR2(2000); --account's flexfield
1348: l_account_desc VARCHAR2(4000); --account's description
1349: l_cash_related_item varchar2(150); --cash related item of a line

Line 1416: FROM gl_periods gp, GL_LEDGERS ledger

1412: , gp.period_year
1413: , gp.period_num
1414: , gp.start_date
1415: , gp.end_date
1416: FROM gl_periods gp, GL_LEDGERS ledger
1417: WHERE ledger.ledger_id = l_ledger_id --using variable l_ledger_id
1418: AND ledger.period_set_name = GP.PERIOD_SET_NAME
1419: AND ledger.accounted_period_type = gp.period_type
1420: AND gp.start_date between

Line 1422: FROM GL_PERIODS GP

1418: AND ledger.period_set_name = GP.PERIOD_SET_NAME
1419: AND ledger.accounted_period_type = gp.period_type
1420: AND gp.start_date between
1421: (SELECT start_date
1422: FROM GL_PERIODS GP
1423: WHERE ledger.PERIOD_SET_NAME = GP.PERIOD_SET_NAME
1424: AND ledger.ACCOUNTED_PERIOD_TYPE = GP.PERIOD_TYPE
1425: AND gp.period_name = l_period_from) --using parameter P_START_PERIOD
1426: and (SELECT start_date

Line 1427: FROM GL_PERIODS GP

1423: WHERE ledger.PERIOD_SET_NAME = GP.PERIOD_SET_NAME
1424: AND ledger.ACCOUNTED_PERIOD_TYPE = GP.PERIOD_TYPE
1425: AND gp.period_name = l_period_from) --using parameter P_START_PERIOD
1426: and (SELECT start_date
1427: FROM GL_PERIODS GP
1428: WHERE ledger.PERIOD_SET_NAME = GP.PERIOD_SET_NAME
1429: AND ledger.ACCOUNTED_PERIOD_TYPE = GP.PERIOD_TYPE
1430: AND gp.period_name = l_period_to) --using parameter P_END_PERIOD
1431: ORDER BY gp.start_date