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_ACC_JE_ITEMIZATION_PKG dependencies on JA_CN_JOURNALS_OF_PERIOD

Line 80: FROM Ja_Cn_Journals_Of_Period Jop, Gl_Je_Sources_Tl Gjs

76: l_Statement_Level NUMBER := Fnd_Log.Level_Statement;
77: l_Exception_Level NUMBER := Fnd_Log.Level_Exception;
78: CURSOR c_Journal IS
79: SELECT DISTINCT Jop.Je_Header_Id
80: FROM Ja_Cn_Journals_Of_Period Jop, Gl_Je_Sources_Tl Gjs
81: WHERE Jop.Request_Id = l_Request_Id
82: AND Gjs.Je_Source_Name = Jop.Je_Source
83: AND Gjs.Source_Lang = Userenv('LANG')
84: AND Gjs.LANGUAGE = Userenv('LANG')

Line 267: -- legal entity into table JA_CN_JOURNALS_OF_PERIOD

263: --
264: -- DESCRIPTION:
265: -- This procedure is used to populate journal with period ,journal
266: -- soruce and category, which company segment is possessed by current
267: -- legal entity into table JA_CN_JOURNALS_OF_PERIOD
268: -- PARAMETERS:
269: -- In: p_start_period the start period name from which
270: -- current SOB is start-up
271: -- p_end_period the till period name to which

Line 351: --generate dynamic sql to populate journal into ja_cn_journals_of_period,

347: AND Fifs.Application_Id = Fsav.Application_Id
348: AND Led.Chart_Of_Accounts_Id = Fifs.Id_Flex_Num
349: AND Led.Ledger_Id = l_Ledger_Id;
350:
351: --generate dynamic sql to populate journal into ja_cn_journals_of_period,
352: --which will be itemized.
353: l_Populate_Journal_Sql := 'INSERT INTO ja_cn_journals_of_period' ||
354: '(je_header_id' || ',je_line_num' ||
355: ',period_name' || ',je_category' ||

Line 353: l_Populate_Journal_Sql := 'INSERT INTO ja_cn_journals_of_period' ||

349: AND Led.Ledger_Id = l_Ledger_Id;
350:
351: --generate dynamic sql to populate journal into ja_cn_journals_of_period,
352: --which will be itemized.
353: l_Populate_Journal_Sql := 'INSERT INTO ja_cn_journals_of_period' ||
354: '(je_header_id' || ',je_line_num' ||
355: ',period_name' || ',je_category' ||
356: ',je_source' || ',legal_entity_id' ||
357: ',request_id,effective_date)' ||

Line 358: 'SELECT /+index(jop,ja_cn_journals_of_period_n3)+/ ' ||

354: '(je_header_id' || ',je_line_num' ||
355: ',period_name' || ',je_category' ||
356: ',je_source' || ',legal_entity_id' ||
357: ',request_id,effective_date)' ||
358: 'SELECT /*+index(jop,ja_cn_journals_of_period_n3)+*/ ' ||
359: ' jeh.je_header_id' ||
360: ' ,jel.je_line_num' ||
361: ' ,jeh.period_name' ||
362: ' ,jeh.je_category' ||

Line 979: Ja_Cn_Journals_Of_Period Jop,

975: -- Jeh.Last_Updated_By)
976: FROM Gl_Je_Headers Jeh,
977: Gl_Je_Lines Jel,
978: Ja_Cn_Code_Combination_v Jcc,
979: Ja_Cn_Journals_Of_Period Jop,
980: Gl_Je_Batches Jeb--added by lyb, for bug 6654734
981: WHERE Jeh.Je_Header_Id = Jel.Je_Header_Id
982: AND Jcc.Ledger_Id = Jeh.Ledger_Id
983: AND Jcc.Code_Combination_Id = Jel.Code_Combination_Id

Line 1050: FROM Ja_Cn_Journals_Of_Period

1046:
1047: CURSOR c_Journal IS
1048: SELECT Je_Header_Id
1049: FROM (SELECT DISTINCT Effective_Date, Je_Header_Id
1050: FROM Ja_Cn_Journals_Of_Period
1051: WHERE Request_Id = l_Request_Id
1052: AND Period_Name = l_Period_Name)
1053: ORDER BY Effective_Date ASC, Je_Header_Id ASC;
1054:

Line 1310: l_sql:=l_sql||' Ja_Cn_Journals_Of_Period Jop,';

1306: l_sql:=l_sql||' Gl_Import_References Gir,';
1307: l_sql:=l_sql||' Ja_Cn_Code_Combination_v Jcc,';
1308: l_sql:=l_sql||' xla_ae_line_acs acs,';
1309: l_sql:=l_sql||' ap_suppliers sup,';
1310: l_sql:=l_sql||' Ja_Cn_Journals_Of_Period Jop,';
1311: l_sql:=l_sql||' Hz_Cust_Accounts Cust,';
1312: l_sql:=l_sql||' Hz_Parties Part ';
1313: l_sql:=l_sql||' WHERE Jel.Je_Header_Id = Jeh.Je_Header_Id';
1314: l_sql:=l_sql||' AND Jeb.Je_Batch_Id=jeh.je_batch_id ';

Line 1452: Ja_Cn_Journals_Of_Period Jop

1448: ,Ja_Cn_Code_Combination_v Jcc
1449: ,Ap_Suppliers Sup
1450: ,
1451: -- per_all_people_f per,
1452: Ja_Cn_Journals_Of_Period Jop
1453: ,Hz_Cust_Accounts Cust
1454: ,Hz_Parties Part
1455: WHERE Jel.Je_Header_Id = Jeh.Je_Header_Id
1456: AND Jeb.Je_Batch_Id=jeh.je_batch_id --added by lyb, for bug 6654734

Line 1693: FROM Ja_Cn_Journals_Of_Period

1689: UPDATE Gl_Je_Lines Jel
1690: SET Jel.Global_Attribute2 = 'P'
1691: WHERE Jel.Je_Line_Num IN
1692: (SELECT Je_Line_Num
1693: FROM Ja_Cn_Journals_Of_Period
1694: WHERE Request_Id = l_Request_Id
1695: AND Je_Header_Id = Jel.Je_Header_Id)
1696: AND Jel.Je_Header_Id IN
1697: (SELECT Je_Header_Id

Line 1698: FROM Ja_Cn_Journals_Of_Period

1694: WHERE Request_Id = l_Request_Id
1695: AND Je_Header_Id = Jel.Je_Header_Id)
1696: AND Jel.Je_Header_Id IN
1697: (SELECT Je_Header_Id
1698: FROM Ja_Cn_Journals_Of_Period
1699: WHERE Request_Id = l_Request_Id);
1700:
1701: --transfer itemized data into ja_cn_journal_lines in this session
1702: INSERT INTO Ja_Cn_Journal_Lines

Line 1804: /* DELETE FROM Ja_Cn_Journals_Of_Period

1800: --commit itemized journal lines with journal number and journal line number
1801: COMMIT;
1802:
1803: --Delete temparory data of current session
1804: /* DELETE FROM Ja_Cn_Journals_Of_Period
1805: WHERE Request_Id = l_Request_Id
1806: AND Je_Header_Id > 0;*/
1807:
1808: DELETE FROM Ja_Cn_Journal_Lines_Req

Line 1884: DELETE FROM Ja_Cn_Journals_Of_Period

1880: Message => SQLCODE || ':' ||
1881: SQLERRM);
1882: WHEN OTHERS THEN
1883: ROLLBACK;
1884: DELETE FROM Ja_Cn_Journals_Of_Period
1885: WHERE Request_Id = l_Request_Id
1886: AND Je_Header_Id > 0;
1887:
1888: DELETE FROM Ja_Cn_Journal_Lines_Req