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

Line 240: -- JA_CN_JOURNAL_LINES to ja_cn_cfs_activities_all for the SLA transaction

236: --
237: -- DESCRIPTION:
238: --
239: -- This procedure is used to migrate the header id and line number from
240: -- JA_CN_JOURNAL_LINES to ja_cn_cfs_activities_all for the SLA transaction
241: -- type.
242: --
243: --
244: -- PARAMETERS:

Line 293: FROM JA_CN_JOURNAL_LINES jcjl,

289: BEGIN
290: UPDATE ja_cn_cfs_activities_all jcca
291: SET jcca.je_header_id =
292: (SELECT DISTINCT jcjl.je_header_id
293: FROM JA_CN_JOURNAL_LINES jcjl,
294: Gl_Je_Headers Jeh,
295: Xla_Ae_Lines Ael,
296: Gl_Import_References Gir
297: WHERE Jeh.Je_Header_Id = jcjl.je_header_id

Line 309: FROM JA_CN_JOURNAL_LINES jcjl,

305: AND jcjl.ledger_id = pn_ledger_id
306: AND jcjl.period_name = pv_period_name),
307: jcca.je_line_num =
308: (SELECT DISTINCT jcjl.Je_Line_Num
309: FROM JA_CN_JOURNAL_LINES jcjl,
310: Gl_Je_Headers Jeh,
311: Xla_Ae_Lines Ael,
312: Gl_Import_References Gir
313: WHERE Jeh.Je_Header_Id = jcjl.je_header_id

Line 429: -- in ja_cn_journal_lines.

425: --
426: -- DESCRIPTION:
427: --
428: -- This procedure is used to migrate the Itemazation lines data
429: -- in ja_cn_journal_lines.
430: --
431: --
432: -- PARAMETERS:
433: -- In: pn_chart_account_id Chart of account ID

Line 480: \* lv_update_template_sql VARCHAR2(1000) := 'UPDATE ja_cn_journal_lines jcjl

476: lv_Error_Msg VARCHAR2(4000);
477: lb_Error_Status BOOLEAN;
478: -- lb_need_Update BOOLEAN := TRUE;
479: lv_update_sql VARCHAR2(1000);
480: \* lv_update_template_sql VARCHAR2(1000) := 'UPDATE ja_cn_journal_lines jcjl
481: SET $to_column$ = $from_column$
482: WHERE jcjl.je_header_id = :1
483: AND jcjl.je_line_num = :2
484: AND jcjl.rowid = :3'; -- Chongwu fix bug 12373841*\

Line 486: lv_update_template_sql VARCHAR2(1000) := 'UPDATE ja_cn_journal_lines jcjl

482: WHERE jcjl.je_header_id = :1
483: AND jcjl.je_line_num = :2
484: AND jcjl.rowid = :3'; -- Chongwu fix bug 12373841*\
485:
486: lv_update_template_sql VARCHAR2(1000) := 'UPDATE ja_cn_journal_lines jcjl
487: SET $to_column$ = $from_column$
488: WHERE jcjl.rowid = :1'; -- Chongwu fix bug 12373841
489:
490: CURSOR cur_itemiz_lines IS

Line 499: FROM ja_cn_journal_lines jcjl, per_people_f ppf --choli changed for bug 11774438

495: third_party_type,
496: cost_center,
497: ppf.employee_number, --choli changed for bug 11774438
498: project_number
499: FROM ja_cn_journal_lines jcjl, per_people_f ppf --choli changed for bug 11774438
500: WHERE jcjl.legal_entity_id = pn_legal_entitliy_id
501: AND jcjl.ledger_id = pn_ledger_id
502: AND jcjl.journal_number IS NOT NULL
503: AND jcjl.period_name = pv_period_name

Line 651: -- update JA_CN_JOURNAL_LINES

647: lb_Error_Status := Fnd_Concurrent.Set_Completion_Status(Status => 'WARNING',
648: Message => lv_Error_Msg);
649: --popup error message JA_CN_MISSING_SUBSIDIARY_SETUP
650: ELSE*\
651: -- update JA_CN_JOURNAL_LINES
652: FOR v_line IN cur_itemiz_lines LOOP
653: IF (v_line.third_party_type IS NOT NULL AND
654: v_line.third_party_type = 'C') THEN
655: -- Construct the update sql for Itemazation data migration

Line 771: UPDATE JA_CN_JOURNAL_LINES jc

767: END IF;
768: END LOOP; -- FOR v_line IN cur_balances LOOP
769:
770: -- Update currency_conversion_type
771: UPDATE JA_CN_JOURNAL_LINES jc
772: SET currency_conversion_type =
773: (SELECT DISTINCT NVL(Ael.Currency_Conversion_Type,
774: Jeh.Currency_Conversion_Type) currency_conversion_type
775: FROM Gl_Je_Headers Jeh,

Line 778: JA_CN_JOURNAL_LINES jcjl

774: Jeh.Currency_Conversion_Type) currency_conversion_type
775: FROM Gl_Je_Headers Jeh,
776: Xla_Ae_Lines Ael,
777: Gl_Import_References Gir,
778: JA_CN_JOURNAL_LINES jcjl
779: WHERE Jeh.Je_Header_Id = jcjl.je_header_id
780: AND Gir.Gl_Sl_Link_Id = Ael.Gl_Sl_Link_Id(+)
781: AND Gir.Gl_Sl_Link_Table = Ael.Gl_Sl_Link_Table(+)
782: AND Gir.Je_Line_Num(+) = jcjl.Je_Line_Num

Line 791: -- update JA_CN_JOURNAL_LINES

787: WHERE jc.Ledger_Id = pn_ledger_id
788: AND jc.Legal_Entity_Id = pn_legal_entitliy_id;
789: -- choli fix bug 12349159, move the related setup check into MigrateHisDateDE
790: -- Handle project related update
791: -- update JA_CN_JOURNAL_LINES
792: IF (lb_need_Update) THEN
793: FOR v_line IN cur_itemiz_lines LOOP
794: -- Construct the update sql for Itemazation data migration
795: lv_update_sql := REPLACE(lv_update_template_sql,

Line 897: FROM ja_cn_journal_lines

893: lb_Msg_Tag BOOLEAN := TRUE;
894: lb_need_update BOOLEAN := TRUE;
895: CURSOR cur_periods IS
896: SELECT DISTINCT period_name
897: FROM ja_cn_journal_lines
898: WHERE ledger_id = P_LEDGER_ID
899: AND legal_entity_id = P_LEGAL_ENTITY_ID
900: AND journal_number IS NOT NULL;
901:

Line 965: --Invoke sub program UpdateGLCashlines to update JA_CN_JOURNAL_LINES for itemization items;

961: UpdateGLItemizationlines(P_LEGAL_ENTITY_ID,
962: P_LEDGER_ID,
963: v_line.period_name);
964:
965: --Invoke sub program UpdateGLCashlines to update JA_CN_JOURNAL_LINES for itemization items;
966: IF (ln_Subsidiary_number >= 4) THEN
967: -- Add by Jianchao Chi for bug 11683977
968: UpdateItemizationlines(P_COA_ID,
969: P_LEGAL_ENTITY_ID,

Line 1071: FROM ja_cn_journal_lines

1067:
1068: CURSOR cur_periods IS
1069: -- choli fix bug 12349128
1070: /* SELECT DISTINCT period_name
1071: FROM ja_cn_journal_lines
1072: WHERE ledger_id = P_LEDGER_ID
1073: AND legal_entity_id = P_LEGAL_ENTITY_ID
1074: AND journal_number IS NOT NULL;*/
1075:

Line 1220: FROM ja_cn_journal_lines

1216:
1217: CURSOR cur_periods IS
1218: -- choli fix bug 12349128
1219: /* SELECT DISTINCT period_name
1220: FROM ja_cn_journal_lines
1221: WHERE ledger_id = P_LEDGER_ID
1222: AND legal_entity_id = P_LEGAL_ENTITY_ID
1223: AND journal_number IS NOT NULL;*/
1224:

Line 1443: --Invoke sub program UpdateGLCashlines to update JA_CN_JOURNAL_LINES for itemization items;

1439: UpdateGLItemizationlines(P_LEGAL_ENTITY_ID,
1440: P_LEDGER_ID,
1441: v_line.period_name);
1442:
1443: --Invoke sub program UpdateGLCashlines to update JA_CN_JOURNAL_LINES for itemization items;
1444: IF (ln_Subsidiary_number >= 4) THEN
1445: UpdateItemizationlines(P_COA_ID,
1446: P_LEGAL_ENTITY_ID,
1447: P_LEDGER_ID,

Line 1498: -- in ja_cn_journal_lines.

1494: --
1495: -- DESCRIPTION:
1496: --
1497: -- This procedure is used to migrate the Itemazation lines data
1498: -- in ja_cn_journal_lines.
1499: --
1500: --
1501: -- PARAMETERS:
1502: -- In: pn_chart_account_id Chart of account ID

Line 1544: lv_update_template_sql VARCHAR2(1000) := 'UPDATE ja_cn_journal_lines jcjl

1540: lb_Error_Status BOOLEAN;
1541: -- lb_need_Update BOOLEAN := TRUE;
1542: lv_update_sql VARCHAR2(1000);
1543:
1544: lv_update_template_sql VARCHAR2(1000) := 'UPDATE ja_cn_journal_lines jcjl
1545: SET jcjl.$to_column$ = $from_column$
1546: WHERE jcjl.legal_entity_id = ' || pn_legal_entitliy_id ||'
1547: AND jcjl.ledger_id = ' || pn_ledger_id ||'
1548: AND jcjl.journal_number IS NOT NULL

Line 1639: -- update JA_CN_JOURNAL_LINES, Construct the update sql for Itemazation data migration

1635: FND_FILE.put_line(FND_FILE.log,
1636: lv_procedure_name || 'lv_costcenter_seg = ' ||
1637: lv_costcenter_seg);
1638:
1639: -- update JA_CN_JOURNAL_LINES, Construct the update sql for Itemazation data migration
1640:
1641: -- Update customer
1642: lv_update_sql := REPLACE(lv_update_template_sql,
1643: '$to_column$',

Line 1731: UPDATE JA_CN_JOURNAL_LINES jc

1727:
1728:
1729:
1730: -- Update currency_conversion_type
1731: UPDATE JA_CN_JOURNAL_LINES jc
1732: SET currency_conversion_type =
1733: (SELECT DISTINCT NVL(Ael.Currency_Conversion_Type,
1734: Jeh.Currency_Conversion_Type) currency_conversion_type
1735: FROM Gl_Je_Headers Jeh,

Line 1738: JA_CN_JOURNAL_LINES jcjl

1734: Jeh.Currency_Conversion_Type) currency_conversion_type
1735: FROM Gl_Je_Headers Jeh,
1736: Xla_Ae_Lines Ael,
1737: Gl_Import_References Gir,
1738: JA_CN_JOURNAL_LINES jcjl
1739: WHERE Jeh.Je_Header_Id = jcjl.je_header_id
1740: AND Gir.Gl_Sl_Link_Id = Ael.Gl_Sl_Link_Id(+)
1741: AND Gir.Gl_Sl_Link_Table = Ael.Gl_Sl_Link_Table(+)
1742: AND Gir.Je_Line_Num(+) = jcjl.Je_Line_Num

Line 1753: -- update JA_CN_JOURNAL_LINES

1749: AND jc.period_name = pv_period_name
1750: AND jc.currency_conversion_type IS NULL;
1751: -- choli fix bug 12349159, move the related setup check into MigrateHisDateDE
1752: -- Handle project related update
1753: -- update JA_CN_JOURNAL_LINES
1754: IF (lb_need_Update) THEN
1755:
1756: -- Update project
1757: lv_update_sql := REPLACE(lv_update_template_sql,