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_ITEMIZATION_INTERFACE dependencies on JA_CN_JOURNAL_LINES

Line 14: --| and make the data enable to import to table ja_cn_journal_lines. |

10: --| |
11: --| DESCRIPTION |
12: --| This package is used to import the legacy data user input in |
13: --| interface table. It will validate the journal lines user input |
14: --| and make the data enable to import to table ja_cn_journal_lines. |
15: --| After import these data, call CNAO post program. |
16: --| |
17: --| |
18: --| PROCEDURE LIST |

Line 715: -- code combination id can't be null in table ja_cn_journal_lines.

711: -- FUNCTION NAME:
712: -- Code_Combination_Validation Public
713: --
714: -- DESCRIPTION:
715: -- code combination id can't be null in table ja_cn_journal_lines.
716: -- user can input it in two ways, directly the code combination id
717: -- and the segment combination. So the correctness and the consistency
718: -- of the two ways should be validated.
719: --

Line 1391: --find unpost data in table ja_cn_journal_lines.

1387:
1388: v_code NUMBER;
1389: v_errm VARCHAR2(64);
1390:
1391: --find unpost data in table ja_cn_journal_lines.
1392: CURSOR c_Journal IS
1393: SELECT distinct Je_Header_Id
1394: FROM ja_cn_journal_lines
1395: WHERE period_name=p_Period_Name

Line 1394: FROM ja_cn_journal_lines

1390:
1391: --find unpost data in table ja_cn_journal_lines.
1392: CURSOR c_Journal IS
1393: SELECT distinct Je_Header_Id
1394: FROM ja_cn_journal_lines
1395: WHERE period_name=p_Period_Name
1396: AND status = 'U'
1397: order by Je_Header_Id;
1398:

Line 1402: FROM Ja_Cn_Journal_Lines Jl

1398:
1399: -- for the l_Je_Header_Id, the journal number is created.
1400: CURSOR c_Journal_Appending IS
1401: SELECT DISTINCT Je_Header_Id, Journal_Number
1402: FROM Ja_Cn_Journal_Lines Jl
1403: WHERE Je_Header_Id = l_Je_Header_Id
1404: AND Journal_Number IS NOT NULL
1405: AND Company_Segment IN
1406: (SELECT bsv.bal_seg_value

Line 1435: UPDATE Ja_Cn_Journal_Lines jop

1431: INTO l_Je_Appending_Id, l_Journal_Number;
1432:
1433: IF c_Journal_Appending%FOUND THEN
1434: CLOSE c_Journal_Appending;
1435: UPDATE Ja_Cn_Journal_Lines jop
1436: SET Journal_Number = l_Journal_Number
1437: WHERE Je_Header_Id = l_Je_Header_Id
1438: AND Journal_Number IS NULL
1439: AND Company_Segment IN

Line 1455: UPDATE Ja_Cn_Journal_Lines

1451: p_ledger_id=>l_ledger_id,
1452: p_Period_Name => l_Period_Name);
1453:
1454: IF Nvl(l_Journal_Number, 0) > 0 THEN
1455: UPDATE Ja_Cn_Journal_Lines
1456: SET Journal_Number = l_Journal_Number
1457: WHERE Je_Header_Id = l_Je_Header_Id
1458: AND Company_Segment IN
1459: (SELECT bsv.bal_seg_value

Line 1724: -- table ja_cn_journal_lines. At last post journals to ja_cn_account_balances.

1720: --
1721: -- DESCRIPTION:
1722: -- This procedure is the main program of itemization interface program.
1723: -- It will process the data in interface table and import them into
1724: -- table ja_cn_journal_lines. At last post journals to ja_cn_account_balances.
1725: --
1726: --
1727: -- PARAMETERS:
1728: -- P_LEDGER_ID ledger id

Line 1901: -- table ja_cn_journal_lines. At last post journals to ja_cn_account_balances.

1897: --
1898: -- DESCRIPTION:
1899: -- This procedure is the main program of itemization interface program.
1900: -- It will process the data in interface table and import them into
1901: -- table ja_cn_journal_lines. At last post journals to ja_cn_account_balances.
1902: --
1903: --
1904: -- PARAMETERS:
1905: -- P_LEDGER_ID ledger id

Line 1961: l_third_party_number ja_cn_journal_lines.third_party_number%type;

1957: l_Conc_Succ BOOLEAN;
1958: l_Post_Fail EXCEPTION;
1959: -- l_Phase_Code Fnd_Lookup_Values.Lookup_Code%TYPE;
1960: -- l_Status_Code Fnd_Lookup_Values.Lookup_Code%TYPE;
1961: l_third_party_number ja_cn_journal_lines.third_party_number%type;
1962: l_third_party_id ja_cn_journal_lines.third_party_id%type;
1963: l_third_party_type ja_cn_journal_lines.third_party_type%type;
1964: l_project_number ja_cn_journal_lines.project_number%type;
1965: l_project_id ja_cn_journal_lines.project_id%type;

Line 1962: l_third_party_id ja_cn_journal_lines.third_party_id%type;

1958: l_Post_Fail EXCEPTION;
1959: -- l_Phase_Code Fnd_Lookup_Values.Lookup_Code%TYPE;
1960: -- l_Status_Code Fnd_Lookup_Values.Lookup_Code%TYPE;
1961: l_third_party_number ja_cn_journal_lines.third_party_number%type;
1962: l_third_party_id ja_cn_journal_lines.third_party_id%type;
1963: l_third_party_type ja_cn_journal_lines.third_party_type%type;
1964: l_project_number ja_cn_journal_lines.project_number%type;
1965: l_project_id ja_cn_journal_lines.project_id%type;
1966: l_project_source ja_cn_journal_lines.project_source%type;

Line 1963: l_third_party_type ja_cn_journal_lines.third_party_type%type;

1959: -- l_Phase_Code Fnd_Lookup_Values.Lookup_Code%TYPE;
1960: -- l_Status_Code Fnd_Lookup_Values.Lookup_Code%TYPE;
1961: l_third_party_number ja_cn_journal_lines.third_party_number%type;
1962: l_third_party_id ja_cn_journal_lines.third_party_id%type;
1963: l_third_party_type ja_cn_journal_lines.third_party_type%type;
1964: l_project_number ja_cn_journal_lines.project_number%type;
1965: l_project_id ja_cn_journal_lines.project_id%type;
1966: l_project_source ja_cn_journal_lines.project_source%type;
1967:

Line 1964: l_project_number ja_cn_journal_lines.project_number%type;

1960: -- l_Status_Code Fnd_Lookup_Values.Lookup_Code%TYPE;
1961: l_third_party_number ja_cn_journal_lines.third_party_number%type;
1962: l_third_party_id ja_cn_journal_lines.third_party_id%type;
1963: l_third_party_type ja_cn_journal_lines.third_party_type%type;
1964: l_project_number ja_cn_journal_lines.project_number%type;
1965: l_project_id ja_cn_journal_lines.project_id%type;
1966: l_project_source ja_cn_journal_lines.project_source%type;
1967:
1968: l_PERSONNEL_id ja_cn_journal_lines.personnel_id%type;

Line 1965: l_project_id ja_cn_journal_lines.project_id%type;

1961: l_third_party_number ja_cn_journal_lines.third_party_number%type;
1962: l_third_party_id ja_cn_journal_lines.third_party_id%type;
1963: l_third_party_type ja_cn_journal_lines.third_party_type%type;
1964: l_project_number ja_cn_journal_lines.project_number%type;
1965: l_project_id ja_cn_journal_lines.project_id%type;
1966: l_project_source ja_cn_journal_lines.project_source%type;
1967:
1968: l_PERSONNEL_id ja_cn_journal_lines.personnel_id%type;
1969: l_PERSONNEL_NUMBER ja_cn_journal_lines.PERSONNEL_NUMBER%type;

Line 1966: l_project_source ja_cn_journal_lines.project_source%type;

1962: l_third_party_id ja_cn_journal_lines.third_party_id%type;
1963: l_third_party_type ja_cn_journal_lines.third_party_type%type;
1964: l_project_number ja_cn_journal_lines.project_number%type;
1965: l_project_id ja_cn_journal_lines.project_id%type;
1966: l_project_source ja_cn_journal_lines.project_source%type;
1967:
1968: l_PERSONNEL_id ja_cn_journal_lines.personnel_id%type;
1969: l_PERSONNEL_NUMBER ja_cn_journal_lines.PERSONNEL_NUMBER%type;
1970:

Line 1968: l_PERSONNEL_id ja_cn_journal_lines.personnel_id%type;

1964: l_project_number ja_cn_journal_lines.project_number%type;
1965: l_project_id ja_cn_journal_lines.project_id%type;
1966: l_project_source ja_cn_journal_lines.project_source%type;
1967:
1968: l_PERSONNEL_id ja_cn_journal_lines.personnel_id%type;
1969: l_PERSONNEL_NUMBER ja_cn_journal_lines.PERSONNEL_NUMBER%type;
1970:
1971: l_creator ja_cn_journal_lines.journal_creator%type;
1972: l_creator_id ja_cn_journal_lines.journal_creator%type;

Line 1969: l_PERSONNEL_NUMBER ja_cn_journal_lines.PERSONNEL_NUMBER%type;

1965: l_project_id ja_cn_journal_lines.project_id%type;
1966: l_project_source ja_cn_journal_lines.project_source%type;
1967:
1968: l_PERSONNEL_id ja_cn_journal_lines.personnel_id%type;
1969: l_PERSONNEL_NUMBER ja_cn_journal_lines.PERSONNEL_NUMBER%type;
1970:
1971: l_creator ja_cn_journal_lines.journal_creator%type;
1972: l_creator_id ja_cn_journal_lines.journal_creator%type;
1973: l_APPROVER ja_cn_journal_lines.journal_APPROVER%type;

Line 1971: l_creator ja_cn_journal_lines.journal_creator%type;

1967:
1968: l_PERSONNEL_id ja_cn_journal_lines.personnel_id%type;
1969: l_PERSONNEL_NUMBER ja_cn_journal_lines.PERSONNEL_NUMBER%type;
1970:
1971: l_creator ja_cn_journal_lines.journal_creator%type;
1972: l_creator_id ja_cn_journal_lines.journal_creator%type;
1973: l_APPROVER ja_cn_journal_lines.journal_APPROVER%type;
1974: l_APPROVER_id ja_cn_journal_lines.journal_creator%type;
1975: l_POSTER ja_cn_journal_lines.journal_POSTER%type;

Line 1972: l_creator_id ja_cn_journal_lines.journal_creator%type;

1968: l_PERSONNEL_id ja_cn_journal_lines.personnel_id%type;
1969: l_PERSONNEL_NUMBER ja_cn_journal_lines.PERSONNEL_NUMBER%type;
1970:
1971: l_creator ja_cn_journal_lines.journal_creator%type;
1972: l_creator_id ja_cn_journal_lines.journal_creator%type;
1973: l_APPROVER ja_cn_journal_lines.journal_APPROVER%type;
1974: l_APPROVER_id ja_cn_journal_lines.journal_creator%type;
1975: l_POSTER ja_cn_journal_lines.journal_POSTER%type;
1976: l_POSTER_id ja_cn_journal_lines.journal_creator%type;

Line 1973: l_APPROVER ja_cn_journal_lines.journal_APPROVER%type;

1969: l_PERSONNEL_NUMBER ja_cn_journal_lines.PERSONNEL_NUMBER%type;
1970:
1971: l_creator ja_cn_journal_lines.journal_creator%type;
1972: l_creator_id ja_cn_journal_lines.journal_creator%type;
1973: l_APPROVER ja_cn_journal_lines.journal_APPROVER%type;
1974: l_APPROVER_id ja_cn_journal_lines.journal_creator%type;
1975: l_POSTER ja_cn_journal_lines.journal_POSTER%type;
1976: l_POSTER_id ja_cn_journal_lines.journal_creator%type;
1977:

Line 1974: l_APPROVER_id ja_cn_journal_lines.journal_creator%type;

1970:
1971: l_creator ja_cn_journal_lines.journal_creator%type;
1972: l_creator_id ja_cn_journal_lines.journal_creator%type;
1973: l_APPROVER ja_cn_journal_lines.journal_APPROVER%type;
1974: l_APPROVER_id ja_cn_journal_lines.journal_creator%type;
1975: l_POSTER ja_cn_journal_lines.journal_POSTER%type;
1976: l_POSTER_id ja_cn_journal_lines.journal_creator%type;
1977:
1978: L_EFFECTIVE_DATE DATE;

Line 1975: l_POSTER ja_cn_journal_lines.journal_POSTER%type;

1971: l_creator ja_cn_journal_lines.journal_creator%type;
1972: l_creator_id ja_cn_journal_lines.journal_creator%type;
1973: l_APPROVER ja_cn_journal_lines.journal_APPROVER%type;
1974: l_APPROVER_id ja_cn_journal_lines.journal_creator%type;
1975: l_POSTER ja_cn_journal_lines.journal_POSTER%type;
1976: l_POSTER_id ja_cn_journal_lines.journal_creator%type;
1977:
1978: L_EFFECTIVE_DATE DATE;
1979: L_START_DATE DATE;

Line 1976: l_POSTER_id ja_cn_journal_lines.journal_creator%type;

1972: l_creator_id ja_cn_journal_lines.journal_creator%type;
1973: l_APPROVER ja_cn_journal_lines.journal_APPROVER%type;
1974: l_APPROVER_id ja_cn_journal_lines.journal_creator%type;
1975: l_POSTER ja_cn_journal_lines.journal_POSTER%type;
1976: l_POSTER_id ja_cn_journal_lines.journal_creator%type;
1977:
1978: L_EFFECTIVE_DATE DATE;
1979: L_START_DATE DATE;
1980: L_END_DATA DATE;

Line 1985: from ja_cn_journal_lines

1981:
1982:
1983: cursor c_journal_group is
1984: select distinct je_header_id
1985: from ja_cn_journal_lines
1986: where status='U';
1987:
1988: CURSOR c_Period_Name IS
1989: SELECT Gp.Period_Name

Line 2009: from ja_cn_journal_lines

2005: ORDER BY Gp.Start_Date;
2006:
2007: cursor c_third_party is
2008: select third_party_number,third_party_type
2009: from ja_cn_journal_lines
2010: where status='U'
2011: and third_party_number is not null
2012: for update;
2013:

Line 2016: from ja_cn_journal_lines

2012: for update;
2013:
2014: cursor c_project is
2015: select project_number,project_source
2016: from ja_cn_journal_lines
2017: where status='U'
2018: and project_number is not null
2019: for update;
2020:

Line 2023: from ja_cn_journal_lines

2019: for update;
2020:
2021: cursor c_PERSONNEL is
2022: select PERSONNEL_ID, DEFAULT_EFFECTIVE_DATE
2023: from ja_cn_journal_lines
2024: where status='U'
2025: and PERSONNEL_ID is not null;
2026:
2027: cursor c_creator is

Line 2029: from ja_cn_journal_lines

2025: and PERSONNEL_ID is not null;
2026:
2027: cursor c_creator is
2028: select journal_creator, DEFAULT_EFFECTIVE_DATE
2029: from ja_cn_journal_lines
2030: where status='U'
2031: and journal_creator is not null;
2032:
2033: cursor c_approver is

Line 2035: from ja_cn_journal_lines

2031: and journal_creator is not null;
2032:
2033: cursor c_approver is
2034: select journal_approver, DEFAULT_EFFECTIVE_DATE
2035: from ja_cn_journal_lines
2036: where status='U'
2037: and journal_approver is not null;
2038:
2039: cursor c_poster is

Line 2041: from ja_cn_journal_lines

2037: and journal_approver is not null;
2038:
2039: cursor c_poster is
2040: select journal_poster, DEFAULT_EFFECTIVE_DATE
2041: from ja_cn_journal_lines
2042: where status='U'
2043: and journal_poster is not null;
2044:
2045: BEGIN

Line 2227: --ja_cn_journal_lines will be set journal group provisionally.

2223: L_PERIOD_TO) ;
2224:
2225: --after validation the data is prepared. for example the ccid, company segment
2226: --account segment is prepared. for the je_header_id column in table
2227: --ja_cn_journal_lines will be set journal group provisionally.
2228: --import the data which status is 'S' to table ja_cn_journal_lines.
2229:
2230:
2231: l_sql:='insert into ja_cn_journal_lines

Line 2228: --import the data which status is 'S' to table ja_cn_journal_lines.

2224:
2225: --after validation the data is prepared. for example the ccid, company segment
2226: --account segment is prepared. for the je_header_id column in table
2227: --ja_cn_journal_lines will be set journal group provisionally.
2228: --import the data which status is 'S' to table ja_cn_journal_lines.
2229:
2230:
2231: l_sql:='insert into ja_cn_journal_lines
2232: (je_header_id,

Line 2231: l_sql:='insert into ja_cn_journal_lines

2227: --ja_cn_journal_lines will be set journal group provisionally.
2228: --import the data which status is 'S' to table ja_cn_journal_lines.
2229:
2230:
2231: l_sql:='insert into ja_cn_journal_lines
2232: (je_header_id,
2233: SET_OF_BOOKS_ID,
2234: legal_entity_id,
2235: JOURNAL_NUMBER,

Line 2325: update ja_cn_journal_lines

2321: from Per_All_People_f
2322: where person_id = l_PERSONNEL_id
2323: AND EFFECTIVE_START_DATE<=L_EFFECTIVE_DATE
2324: AND EFFECTIVE_END_DATE>=L_EFFECTIVE_DATE;
2325: update ja_cn_journal_lines
2326: set personnel_number = l_PERSONNEL_NUMBER
2327: where personnel_id = l_PERSONNEL_id ;
2328:
2329: end loop;

Line 2343: update ja_cn_journal_lines

2339: where person_id = to_number(l_creator_id)
2340: AND EFFECTIVE_START_DATE<=L_EFFECTIVE_DATE
2341: AND EFFECTIVE_END_DATE>=L_EFFECTIVE_DATE;
2342:
2343: update ja_cn_journal_lines
2344: set journal_creator = l_creator
2345: where journal_creator = l_creator_id;
2346:
2347: end loop;

Line 2361: update ja_cn_journal_lines

2357: where person_id = to_number(l_approver_id )
2358: AND EFFECTIVE_START_DATE<=L_EFFECTIVE_DATE
2359: AND EFFECTIVE_END_DATE>=L_EFFECTIVE_DATE;
2360:
2361: update ja_cn_journal_lines
2362: set journal_approver = l_approver
2363: where journal_approver = l_APPROVER_id;
2364: end loop;
2365: close c_approver;

Line 2378: update ja_cn_journal_lines

2374: where person_id = to_number(l_poster_id)
2375: AND EFFECTIVE_START_DATE<=L_EFFECTIVE_DATE
2376: AND EFFECTIVE_END_DATE>=L_EFFECTIVE_DATE;
2377:
2378: update ja_cn_journal_lines
2379: set journal_poster = l_poster
2380: where journal_poster = l_poster_id;
2381: end loop;
2382: close c_poster;

Line 2390: update ja_cn_journal_lines

2386: loop
2387: fetch c_journal_group into l_journal_group;
2388: exit when c_journal_group%notfound;
2389: SELECT ja_cn_item_interface_s.NEXTVAL into l_header_id FROM Dual;
2390: update ja_cn_journal_lines
2391: set je_header_id = l_header_id
2392: where status = 'U'
2393: and je_header_id = l_journal_group;
2394: end loop;

Line 2414: update ja_cn_journal_lines

2410: into l_third_party_id
2411: from ap_suppliers
2412: where Segment1 =l_THIRD_PARTY_NUMBER;
2413: end if;
2414: update ja_cn_journal_lines
2415: set third_party_id=l_third_party_id
2416: where current of c_third_party;
2417: end loop;
2418: close c_third_party;

Line 2447: update ja_cn_journal_lines

2443: where chart_of_accounts_id=l_coa
2444: and history_coa_segment is not null) )
2445: AND flex_value = l_PROJECT_NUMBER ;
2446: end if;
2447: update ja_cn_journal_lines
2448: set project_id=l_project_id
2449: where current of c_project;
2450: end loop;
2451: close c_project;

Line 2453: --generate journal number for each line in table ja_cn_journal_lines.

2449: where current of c_project;
2450: end loop;
2451: close c_project;
2452:
2453: --generate journal number for each line in table ja_cn_journal_lines.
2454: OPEN c_Period_Name;
2455: LOOP
2456: FETCH c_Period_Name
2457: INTO l_Period_Name;