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.XTR_ORACLE_FIN_INTERFACES_P dependencies on XTR_JOURNALS

Line 19: Update XTR_JOURNALS

15: /* Private procedure to update debit journal rows within the given batch id. */
16: /* Updated columns are the transferred date and the link id used by the drilldown */
17: /* feature in GL which XTR does not have currently. */
18:
19: Update XTR_JOURNALS
20: Set TRANSFER_TO_EXTERNAL_GL = trunc(sysdate),
21: gl_sl_link_id = in_gl_link_id,
22: alt_journal_date = in_alt_jrnl_date
23: where batch_id = in_batch_id

Line 42: Update XTR_JOURNALS

38: Begin
39:
40: /* Private procedure to update credit journal rows within the given batch id. */
41:
42: Update XTR_JOURNALS
43: Set TRANSFER_TO_EXTERNAL_GL = trunc(sysdate),
44: gl_sl_link_id = in_gl_link_id,
45: alt_journal_date = in_alt_jrnl_date
46: where batch_id = in_batch_id

Line 197: COMPANY_CODE in (Select distinct company_code from xtr_journals

193: Cursor CHK_ALLOW_UNBAL_JRNL is
194: Select
195: PARAMETER_VALUE_CODE
196: FROM XTR_COMPANY_PARAMETERS WHERE
197: COMPANY_CODE in (Select distinct company_code from xtr_journals
198: where batch_id = in_batch_id)
199: and parameter_code = 'ACCNT_UNBAL';
200:
201: Cursor UPD_CREDIT(l_jrnl_date date) is

Line 202: Select rowid from xtr_journals

198: where batch_id = in_batch_id)
199: and parameter_code = 'ACCNT_UNBAL';
200:
201: Cursor UPD_CREDIT(l_jrnl_date date) is
202: Select rowid from xtr_journals
203: Where batch_id = in_batch_id
204: and journal_date = l_jrnl_date and nvl(accounted_cr,0) <> 0
205: and accounted_cr = (Select min(accounted_cr) from xtr_journals
206: Where batch_id = in_batch_id

Line 205: and accounted_cr = (Select min(accounted_cr) from xtr_journals

201: Cursor UPD_CREDIT(l_jrnl_date date) is
202: Select rowid from xtr_journals
203: Where batch_id = in_batch_id
204: and journal_date = l_jrnl_date and nvl(accounted_cr,0) <> 0
205: and accounted_cr = (Select min(accounted_cr) from xtr_journals
206: Where batch_id = in_batch_id
207: and journal_date = l_jrnl_date and nvl(accounted_cr,0) <> 0 );
208:
209:

Line 211: Select rowid from xtr_journals

207: and journal_date = l_jrnl_date and nvl(accounted_cr,0) <> 0 );
208:
209:
210: Cursor UPD_DEBIT(l_jrnl_date date) is
211: Select rowid from xtr_journals
212: Where batch_id = in_batch_id
213: and journal_date = l_jrnl_date and nvl(accounted_dr,0) <> 0
214: and accounted_dr = (Select min(accounted_dr) from xtr_journals
215: Where batch_id = in_batch_id

Line 214: and accounted_dr = (Select min(accounted_dr) from xtr_journals

210: Cursor UPD_DEBIT(l_jrnl_date date) is
211: Select rowid from xtr_journals
212: Where batch_id = in_batch_id
213: and journal_date = l_jrnl_date and nvl(accounted_dr,0) <> 0
214: and accounted_dr = (Select min(accounted_dr) from xtr_journals
215: Where batch_id = in_batch_id
216: and journal_date = l_jrnl_date and nvl(accounted_dr,0) <> 0 );
217:
218:

Line 222: From XTR_JOURNALS

218:
219: Cursor CHK_DIFF is
220: Select journal_date,
221: sum(nvl(accounted_dr,0)) - sum(nvl(accounted_cr,0)) difference
222: From XTR_JOURNALS
223: Where batch_id = in_batch_id
224: Group By journal_date
225: having sum(nvl(debit_amount,0)) = sum(nvl(credit_amount,0));
226:

Line 234: From XTR_JOURNALS

230: Select null
231: From DUAL
232: Where exists
233: (Select null
234: From XTR_JOURNALS
235: Where batch_id = in_batch_id
236: Group By journal_date
237: Having sum(nvl(accounted_dr,0)) <> sum(nvl(accounted_cr,0)));
238:

Line 254: update xtr_journals set accounted_dr=accounted_dr+.01

250: if (l_diff < 0 ) then
251: Open UPD_DEBIT(l_journaldate);
252: fetch UPD_DEBIT into l_rowid;
253: close UPD_DEBIT;
254: update xtr_journals set accounted_dr=accounted_dr+.01
255: where rowid = l_rowid;
256: commit;
257: else
258: Open UPD_CREDIT(l_journaldate);

Line 261: update xtr_journals set accounted_cr=accounted_cr+.01

257: else
258: Open UPD_CREDIT(l_journaldate);
259: fetch UPD_CREDIT into l_rowid;
260: close UPD_CREDIT;
261: update xtr_journals set accounted_cr=accounted_cr+.01
262: where rowid = l_rowid;
263: commit;
264: end if;
265: end if;

Line 341: | from the XTR_JOURNALS table to the GL_INTERFACE table. |

337: | Transfer_Jnls |
338: | |
339: | DESCRIPTION |
340: | Procedure which will transfer/re-transfer the given batch id |
341: | from the XTR_JOURNALS table to the GL_INTERFACE table. |
342: | |
343: | CALLED BY |
344: | Procedure XTR_JOURNAL_PROCESS_P.Journals. |
345: | |

Line 377: l_gl_link_id XTR_JOURNALS.gl_sl_link_id%TYPE;

373: l_trx_param xtr_company_parameters.parameter_value_code%TYPE;
374: l_source_name gl_je_sources.user_je_source_name%TYPE;
375: l_category_name gl_je_categories.user_je_category_name%TYPE;
376: l_xchange_type gl_daily_conversion_types.user_conversion_type%TYPE;
377: l_gl_link_id XTR_JOURNALS.gl_sl_link_id%TYPE;
378: l_gl_group_id GL_INTERFACE.group_id%TYPE; -- add to record group id when tranfer
379: p_company_code XTR_PARTY_INFO.party_code%TYPE;
380: l_rowid VARCHAR2(30);
381:

Line 421: from XTR_JOURNALS

417: null deal_type,
418: null deal_subtype,
419: null product_type,
420: null portfolio_code
421: from XTR_JOURNALS
422: where batch_id = G_batch_id
423: and (nvl(debit_amount,0) <> 0 or nvl(accounted_dr,0) <> 0)
424: group by batch_id, journal_date, code_combination_id, currency
425: UNION

Line 444: from XTR_JOURNALS

440: null deal_type,
441: null deal_subtype,
442: null product_type,
443: null portfolio_code
444: from XTR_JOURNALS
445: where batch_id = G_batch_id
446: and (nvl(credit_amount,0) <> 0 or nvl(accounted_cr,0) <> 0)
447: group by batch_id, journal_date, code_combination_id, currency;
448: --

Line 468: from XTR_JOURNALS

464: deal_type deal_type,
465: deal_subtype deal_subtype,
466: product_type product_type,
467: portfolio_code portfolio_code
468: from XTR_JOURNALS
469: where batch_id = G_batch_id
470: and (nvl(debit_amount,0) <> 0 or nvl(accounted_dr,0) <> 0 or nvl(credit_amount,0) <> 0 or nvl(accounted_cr,0) <> 0);
471: --
472: JNL_REC JNL_DETAIL%ROWTYPE;

Line 713: -- Update XTR_JOURNALS table. Mark transferred rows.

709: JNL_REC.deal_subtype,
710: JNL_REC.product_type,
711: JNL_REC.portfolio_code);
712:
713: -- Update XTR_JOURNALS table. Mark transferred rows.
714:
715: If l_trx_param = 'DETAIL' then
716: Update XTR_JOURNALS
717: Set TRANSFER_TO_EXTERNAL_GL = trunc(sysdate),

Line 716: Update XTR_JOURNALS

712:
713: -- Update XTR_JOURNALS table. Mark transferred rows.
714:
715: If l_trx_param = 'DETAIL' then
716: Update XTR_JOURNALS
717: Set TRANSFER_TO_EXTERNAL_GL = trunc(sysdate),
718: gl_sl_link_id = l_gl_link_id,
719: alt_journal_date = l_journal_date -- bug 3461138
720: where rowid = JNL_REC.row_id;

Line 745: END LOOP; -- [loop processing of xtr_journals recrods ...]

741: l_journal_date);
742: End If; -- [debit/credit <> 0 ...]
743: End if; -- [l_trx_param ...]
744: End If; -- [l_ok_to_xfer ... after closed period handling check]
745: END LOOP; -- [loop processing of xtr_journals recrods ...]
746:
747: If l_trx_param = 'DETAIL' then
748: Close JNL_DETAIL;
749: Else