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 99: FROM Ja_Cn_Journals_Of_Period Jop, Gl_Je_Sources_Tl Gjs

95: l_Statement_Level NUMBER := Fnd_Log.Level_Statement;
96: l_Exception_Level NUMBER := Fnd_Log.Level_Exception;
97: CURSOR c_Journal IS
98: SELECT DISTINCT Jop.Je_Header_Id
99: FROM Ja_Cn_Journals_Of_Period Jop, Gl_Je_Sources_Tl Gjs
100: WHERE Jop.Request_Id = l_Request_Id
101: AND Gjs.Je_Source_Name = Jop.Je_Source
102: AND Gjs.Source_Lang = Userenv('LANG')
103: AND Gjs.LANGUAGE = Userenv('LANG')

Line 286: -- legal entity into table JA_CN_JOURNALS_OF_PERIOD

282: --
283: -- DESCRIPTION:
284: -- This procedure is used to populate journal with period ,journal
285: -- soruce and category, which company segment is possessed by current
286: -- legal entity into table JA_CN_JOURNALS_OF_PERIOD
287: -- PARAMETERS:
288: -- In: p_start_period the start period name from which
289: -- current SOB is start-up
290: -- p_end_period the till period name to which

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

367: AND Fifs.Application_Id = Fsav.Application_Id
368: AND Led.Chart_Of_Accounts_Id = Fifs.Id_Flex_Num
369: AND Led.Ledger_Id = l_Ledger_Id;
370:
371: --generate dynamic sql to populate journal into ja_cn_journals_of_period,
372: --which will be itemized.
373: l_Populate_Journal_Sql := 'INSERT INTO ja_cn_journals_of_period' ||
374: '(je_header_id' || ',je_line_num' ||
375: ',period_name' || ',je_category' ||

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

369: AND Led.Ledger_Id = l_Ledger_Id;
370:
371: --generate dynamic sql to populate journal into ja_cn_journals_of_period,
372: --which will be itemized.
373: l_Populate_Journal_Sql := 'INSERT INTO ja_cn_journals_of_period' ||
374: '(je_header_id' || ',je_line_num' ||
375: ',period_name' || ',je_category' ||
376: ',je_source' || ',legal_entity_id' ||
377: ',request_id,effective_date)' ||

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

374: '(je_header_id' || ',je_line_num' ||
375: ',period_name' || ',je_category' ||
376: ',je_source' || ',legal_entity_id' ||
377: ',request_id,effective_date)' ||
378: 'SELECT /*+index(jop,ja_cn_journals_of_period_n3)+*/ ' ||
379: ' jeh.je_header_id' ||
380: ' ,jel.je_line_num' ||
381: ' ,jeh.period_name' ||
382: ' ,jeh.je_category' ||

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

1136: l_sql:=l_sql|| l_SM_Query_Header_Sql; -- Added for fetching settlement method
1137: l_sql:=l_sql||' FROM Gl_Je_Headers Jeh,';
1138: l_sql:=l_sql||' Gl_Je_Lines Jel,';
1139: l_sql:=l_sql||' Ja_Cn_Code_Combination_v Jcc,';
1140: l_sql:=l_sql||' Ja_Cn_Journals_Of_Period Jop,';
1141: l_sql:=l_sql||' Gl_Je_Batches Jeb ';
1142: l_sql:=l_sql||' WHERE Jeh.Je_Header_Id = Jel.Je_Header_Id';
1143: l_sql:=l_sql||' AND Jcc.Ledger_Id = Jeh.Ledger_Id';
1144: l_sql:=l_sql||' AND Jcc.Code_Combination_Id = Jel.Code_Combination_Id';

Line 1241: Ja_Cn_Journals_Of_Period Jop,

1237: -- Jeh.Last_Updated_By)
1238: FROM Gl_Je_Headers Jeh,
1239: Gl_Je_Lines Jel,
1240: Ja_Cn_Code_Combination_v Jcc,
1241: Ja_Cn_Journals_Of_Period Jop,
1242: Gl_Je_Batches Jeb--added by lyb, for bug 6654734
1243: WHERE Jeh.Je_Header_Id = Jel.Je_Header_Id
1244: AND Jcc.Ledger_Id = Jeh.Ledger_Id
1245: AND Jcc.Code_Combination_Id = Jel.Code_Combination_Id

Line 1315: FROM Ja_Cn_Journals_Of_Period

1311:
1312: CURSOR c_Journal IS
1313: SELECT Je_Header_Id
1314: FROM (SELECT DISTINCT Effective_Date, Je_Header_Id
1315: FROM Ja_Cn_Journals_Of_Period
1316: WHERE Request_Id = l_Request_Id
1317: AND Period_Name = l_Period_Name)
1318: ORDER BY Effective_Date ASC, Je_Header_Id ASC;
1319:

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

1718: l_sql:=l_sql||' Ja_Cn_Code_Combination_v Jcc,';
1719: --l_sql:=l_sql||' xla_ae_line_acs acs,'; --Deleted by Chaoqun for CNAOV2
1720: l_sql:=l_sql||l_Project_Query_Table_Sql; -- Added by Chaoqun for CNAOV2
1721: l_sql:=l_sql||' ap_suppliers sup,';
1722: l_sql:=l_sql||' Ja_Cn_Journals_Of_Period Jop,';
1723: l_sql:=l_sql||' Hz_Cust_Accounts Cust,';
1724: l_sql:=l_sql||' Hz_Parties Part ';
1725: l_sql:=l_sql||' WHERE Jel.Je_Header_Id = Jeh.Je_Header_Id';
1726: l_sql:=l_sql||' AND Jeb.Je_Batch_Id=jeh.je_batch_id ';

Line 1867: Ja_Cn_Journals_Of_Period Jop

1863: ,Ja_Cn_Code_Combination_v Jcc
1864: ,Ap_Suppliers Sup
1865: ,
1866: -- per_all_people_f per,
1867: Ja_Cn_Journals_Of_Period Jop
1868: ,Hz_Cust_Accounts Cust
1869: ,Hz_Parties Part
1870: WHERE Jel.Je_Header_Id = Jeh.Je_Header_Id
1871: AND Jeb.Je_Batch_Id=jeh.je_batch_id --added by lyb, for bug 6654734

Line 2136: FROM Ja_Cn_Journals_Of_Period

2132: UPDATE Gl_Je_Lines Jel
2133: SET Jel.Global_Attribute7 = 'P' --Updated for CNAOV2 solution by chaoqun on 13-May-2010
2134: WHERE Jel.Je_Line_Num IN
2135: (SELECT Je_Line_Num
2136: FROM Ja_Cn_Journals_Of_Period
2137: WHERE Request_Id = l_Request_Id
2138: AND Je_Header_Id = Jel.Je_Header_Id)
2139: AND Jel.Je_Header_Id IN
2140: (SELECT Je_Header_Id

Line 2141: FROM Ja_Cn_Journals_Of_Period

2137: WHERE Request_Id = l_Request_Id
2138: AND Je_Header_Id = Jel.Je_Header_Id)
2139: AND Jel.Je_Header_Id IN
2140: (SELECT Je_Header_Id
2141: FROM Ja_Cn_Journals_Of_Period
2142: WHERE Request_Id = l_Request_Id);
2143:
2144: --Begin: Chaoqun updated for CNAOV2 on 01-21-2010
2145:

Line 2354: /* DELETE FROM Ja_Cn_Journals_Of_Period

2350: --commit itemized journal lines with journal number and journal line number
2351: COMMIT;
2352:
2353: --Delete temparory data of current session
2354: /* DELETE FROM Ja_Cn_Journals_Of_Period
2355: WHERE Request_Id = l_Request_Id
2356: AND Je_Header_Id > 0;*/
2357:
2358: DELETE FROM Ja_Cn_Journal_Lines_Req

Line 2431: DELETE FROM Ja_Cn_Journals_Of_Period

2427: Message => SQLCODE || ':' ||
2428: SQLERRM);
2429: WHEN OTHERS THEN
2430: ROLLBACK;
2431: DELETE FROM Ja_Cn_Journals_Of_Period
2432: WHERE Request_Id = l_Request_Id
2433: AND Je_Header_Id > 0;
2434:
2435: DELETE FROM Ja_Cn_Journal_Lines_Req