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 GL_PERIODS

Line 68: l_Period_Name Gl_Periods.Period_Name%TYPE;

64: PROCEDURE Get_Journal_Approver(p_Request_Id IN NUMBER) IS
65: l_Request_Id NUMBER := p_Request_Id;
66: l_Je_Header_Id NUMBER;
67: l_Batch_Name Gl_Je_Batches.NAME%TYPE;
68: l_Period_Name Gl_Periods.Period_Name%TYPE;
69: l_Approver VARCHAR2(100);
70: l_Approval_Status VARCHAR2(1);
71: l_Approver_Name VARCHAR2(100);
72: l_Step VARCHAR2(100);

Line 370: ' ,gl_periods gp' ||

366: ',jeh.default_effective_date ' ||
367: ' FROM gl_je_headers jeh' ||
368: ' ,gl_je_lines jel' ||
369: ' ,gl_code_combinations gcc' ||
370: ' ,gl_periods gp' ||
371: ' ,gl_ledgers led' ||
372: ' ,ja_cn_ledger_le_bsv_gt bsv' ||
373: ' WHERE jeh.je_header_id = jel.je_header_id' ||
374: ' AND jeh.status = ''P''' ||

Line 384: ' FROM gl_periods' ||

380: ' AND bsv.legal_entity_id = ' ||
381: l_Legal_Entity_Id ||
382: ' AND gp.start_date BETWEEN' ||
383: ' (SELECT start_date' ||
384: ' FROM gl_periods' ||
385: ' WHERE period_name =''' ||
386: l_Start_Period || '''' ||
387: ' AND period_set_name = led.period_set_name)' ||
388: ' AND (SELECT start_date' ||

Line 389: ' FROM gl_periods' ||

385: ' WHERE period_name =''' ||
386: l_Start_Period || '''' ||
387: ' AND period_set_name = led.period_set_name)' ||
388: ' AND (SELECT start_date' ||
389: ' FROM gl_periods' ||
390: ' WHERE period_name =''' ||
391: l_End_Period || '''' ||
392: ' AND period_set_name = led.period_set_name)' ||
393: ' AND gp.period_set_name = led.period_set_name' ||

Line 692: FROM Gl_Periods Gp, Gl_Ledgers Led

688: l_ledger_id := p_ledger_id;
689: --get the first period of current led
690: SELECT Gp.Period_Name
691: INTO p_Start_Period_Name
692: FROM Gl_Periods Gp, Gl_Ledgers Led
693: WHERE Led.Ledger_Id = l_Ledger_Id
694: AND Led.Period_Set_Name = Gp.Period_Set_Name
695: AND Led.Accounted_Period_Type = Gp.Period_Type
696: AND Gp.Start_Date IN

Line 698: FROM Gl_Periods Gp

694: AND Led.Period_Set_Name = Gp.Period_Set_Name
695: AND Led.Accounted_Period_Type = Gp.Period_Type
696: AND Gp.Start_Date IN
697: (SELECT MIN(Start_Date)
698: FROM Gl_Periods Gp
699: WHERE Led.Period_Set_Name = Gp.Period_Set_Name
700: AND Led.Accounted_Period_Type = Gp.Period_Type);
701:
702: -- if parameter period is null then pick up last open period as end period

Line 706: FROM Gl_Periods Gp, Gl_Ledgers Led

702: -- if parameter period is null then pick up last open period as end period
703: IF l_Period_Name IS NULL THEN
704: SELECT Gp.Period_Name
705: INTO p_End_Period_Name
706: FROM Gl_Periods Gp, Gl_Ledgers Led
707: WHERE Led.Ledger_Id = l_Ledger_Id
708: AND Led.Period_Set_Name = Gp.Period_Set_Name
709: AND Led.Accounted_Period_Type = Gp.Period_Type
710: AND Gp.Start_Date IN

Line 712: FROM Gl_Periods Gp

708: AND Led.Period_Set_Name = Gp.Period_Set_Name
709: AND Led.Accounted_Period_Type = Gp.Period_Type
710: AND Gp.Start_Date IN
711: (SELECT MAX(Start_Date)
712: FROM Gl_Periods Gp
713: WHERE Led.Period_Set_Name = Gp.Period_Set_Name
714: AND Led.Accounted_Period_Type = Gp.Period_Type);
715: ELSE
716: p_End_Period_Name := l_Period_Name;

Line 1036: l_Period_Name Gl_Periods.Period_Name%TYPE;

1032: p_Request_Id IN NUMBER,
1033: p_ledger_id in number,
1034: P_legal_entity_id in number) IS
1035: l_Request_Id NUMBER;
1036: l_Period_Name Gl_Periods.Period_Name%TYPE;
1037: l_Je_Header_Id NUMBER;
1038: l_Journal_Number NUMBER;
1039: l_Je_Appending_Id NUMBER;
1040: l_Line_Num_m NUMBER;

Line 1524: l_Till_Period_Name Gl_Periods.Period_Name%TYPE;

1520: l_Status VARCHAR2(100);
1521: l_Dev_Phase VARCHAR2(100);
1522: l_Dev_Status VARCHAR2(100);
1523: l_Message VARCHAR2(100);
1524: l_Till_Period_Name Gl_Periods.Period_Name%TYPE;
1525: l_Period_Name Gl_Periods.Period_Name%TYPE;
1526: l_Start_Period_Name Gl_Periods.Period_Name%TYPE;
1527: l_End_Period_Name Gl_Periods.Period_Name%TYPE;
1528: l_Conc_Succ BOOLEAN;

Line 1525: l_Period_Name Gl_Periods.Period_Name%TYPE;

1521: l_Dev_Phase VARCHAR2(100);
1522: l_Dev_Status VARCHAR2(100);
1523: l_Message VARCHAR2(100);
1524: l_Till_Period_Name Gl_Periods.Period_Name%TYPE;
1525: l_Period_Name Gl_Periods.Period_Name%TYPE;
1526: l_Start_Period_Name Gl_Periods.Period_Name%TYPE;
1527: l_End_Period_Name Gl_Periods.Period_Name%TYPE;
1528: l_Conc_Succ BOOLEAN;
1529: l_Request_Id NUMBER;

Line 1526: l_Start_Period_Name Gl_Periods.Period_Name%TYPE;

1522: l_Dev_Status VARCHAR2(100);
1523: l_Message VARCHAR2(100);
1524: l_Till_Period_Name Gl_Periods.Period_Name%TYPE;
1525: l_Period_Name Gl_Periods.Period_Name%TYPE;
1526: l_Start_Period_Name Gl_Periods.Period_Name%TYPE;
1527: l_End_Period_Name Gl_Periods.Period_Name%TYPE;
1528: l_Conc_Succ BOOLEAN;
1529: l_Request_Id NUMBER;
1530: l_Chart_Of_Account_Id NUMBER;

Line 1527: l_End_Period_Name Gl_Periods.Period_Name%TYPE;

1523: l_Message VARCHAR2(100);
1524: l_Till_Period_Name Gl_Periods.Period_Name%TYPE;
1525: l_Period_Name Gl_Periods.Period_Name%TYPE;
1526: l_Start_Period_Name Gl_Periods.Period_Name%TYPE;
1527: l_End_Period_Name Gl_Periods.Period_Name%TYPE;
1528: l_Conc_Succ BOOLEAN;
1529: l_Request_Id NUMBER;
1530: l_Chart_Of_Account_Id NUMBER;
1531: l_Ledger_Id NUMBER;

Line 1549: FROM Gl_Periods Gp, Gl_Ledgers Led

1545: WHERE Chart_Of_Accounts_Id = l_Chart_Of_Accounts_Id;
1546:
1547: CURSOR c_Period_Name IS
1548: SELECT Gp.Period_Name
1549: FROM Gl_Periods Gp, Gl_Ledgers Led
1550: WHERE Led.Ledger_Id = l_Ledger_Id
1551: AND Led.Period_Set_Name = Gp.Period_Set_Name
1552: AND Led.Accounted_Period_Type = Gp.Period_Type
1553: AND Gp.Start_Date BETWEEN

Line 1555: FROM Gl_Periods Gp

1551: AND Led.Period_Set_Name = Gp.Period_Set_Name
1552: AND Led.Accounted_Period_Type = Gp.Period_Type
1553: AND Gp.Start_Date BETWEEN
1554: (SELECT Start_Date
1555: FROM Gl_Periods Gp
1556: WHERE Led.Period_Set_Name = Gp.Period_Set_Name
1557: AND Led.Accounted_Period_Type = Gp.Period_Type
1558: AND Gp.Period_Name = l_Start_Period_Name)
1559: AND (SELECT Start_Date

Line 1560: FROM Gl_Periods Gp

1556: WHERE Led.Period_Set_Name = Gp.Period_Set_Name
1557: AND Led.Accounted_Period_Type = Gp.Period_Type
1558: AND Gp.Period_Name = l_Start_Period_Name)
1559: AND (SELECT Start_Date
1560: FROM Gl_Periods Gp
1561: WHERE Led.Period_Set_Name = Gp.Period_Set_Name
1562: AND Led.Accounted_Period_Type = Gp.Period_Type
1563: AND Gp.Period_Name = l_End_Period_Name)
1564: ORDER BY Gp.Start_Date;