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.AP_PERIOD_CLOSE_PKG dependencies on AP_ORG_ATTRIBUTES_GT

Line 75: insert into ap_org_attributes_gt

71: --
72: for r_org in c_get_all_orgs
73: loop
74:
75: insert into ap_org_attributes_gt
76: (org_name
77: ,org_id
78: ,recon_accounting_flag
79: ,when_to_account_pmt

Line 99: debug ('populate_orgs: total orgs populated in ap_org_attributes_gt= '||ln_org_cnt);

95: p_process_message := 'AP_INVALID_LEDGER';
96: return;
97: end if;
98:
99: debug ('populate_orgs: total orgs populated in ap_org_attributes_gt= '||ln_org_cnt);
100:
101: p_process_flag := 'SS';
102: p_process_message := null;
103:

Line 191: ,ap_org_attributes_gt org_gtt

187: ,G_SRC_TAB_AP_INV_DISTS_ALL
188: from
189: ap_invoices_all ai
190: ,ap_invoice_distributions_all aid
191: ,ap_org_attributes_gt org_gtt
192: where
193: ai.invoice_id = aid.invoice_id
194: -- bug 7311486 UTR report must run even if dates and period is not specified
195: and ( aid.accounting_date between g_period_start_date and g_period_end_date)

Line 257: ,ap_org_attributes_gt org_gtt

253: ,G_SRC_TAB_AP_INV_DISTS_ALL
254: from
255: ap_invoices_all ai
256: ,ap_invoice_distributions_all aid
257: ,ap_org_attributes_gt org_gtt
258: where
259: ai.invoice_id = aid.invoice_id
260: -- bug 7311486 UTR report must run even if dates and period is not specified
261: -- and ( aid.accounting_date between g_period_start_date and g_period_end_date)

Line 328: ,ap_org_attributes_gt org_gtt

324: ,G_SRC_TAB_AP_SELF_TAX_DIST_ALL
325: from
326: ap_invoices_all ai
327: ,ap_self_assessed_tax_dist_all astd
328: ,ap_org_attributes_gt org_gtt
329: where
330: ai.invoice_id = astd.invoice_id
331: -- bug 7311486 UTR report must run even if dates and period is not specified
332: and (

Line 389: ,ap_org_attributes_gt org_gtt

385: ,G_SRC_TAB_AP_SELF_TAX_DIST_ALL
386: from
387: ap_invoices_all ai
388: ,ap_self_assessed_tax_dist_all astd
389: ,ap_org_attributes_gt org_gtt
390: where
391: ai.invoice_id = astd.invoice_id
392: -- bug 7311486 UTR report must run even if dates and period is not specified
393: and (

Line 451: ,ap_org_attributes_gt org_gtt

447: ,G_SRC_TAB_AP_INV_LINES_ALL
448: from
449: ap_invoices_all ai
450: ,ap_invoice_lines_all ail
451: ,ap_org_attributes_gt org_gtt
452: where
453: ai.invoice_id = ail.invoice_id
454: -- bug 7311486 UTR report must run even if dates and period is not specified
455: and (ail.accounting_date between g_period_start_date and g_period_end_date)

Line 513: ,ap_org_attributes_gt org_gtt

509: ,G_SRC_TAB_AP_INV_LINES_ALL
510: from
511: ap_invoices_all ai
512: ,ap_invoice_lines_all ail
513: ,ap_org_attributes_gt org_gtt
514: where
515: ai.invoice_id = ail.invoice_id
516: -- bug 7311486 UTR report must run even if dates and period is not specified
517: -- and (ail.accounting_date between g_period_start_date and g_period_end_date)

Line 589: ,ap_org_attributes_gt org_gtt

585: ,G_SRC_TYP_UNACCT_PREPAY_HIST
586: ,G_SRC_TAB_AP_PREPAY_HIST
587: from ap_invoices_all ai
588: ,ap_prepay_history_all apph
589: ,ap_org_attributes_gt org_gtt
590: where
591: ai.invoice_id = apph.invoice_id
592: -- bug 7311486 UTR report must run even if dates and period is not specified
593: and ( apph.accounting_date between g_period_start_date and g_period_end_date)

Line 638: ,ap_org_attributes_gt org_gtt

634: ,G_SRC_TYP_UNACCT_PREPAY_HIST
635: ,G_SRC_TAB_AP_PREPAY_HIST
636: from ap_invoices_all ai
637: ,ap_prepay_history_all apph
638: ,ap_org_attributes_gt org_gtt
639: where
640: ai.invoice_id = apph.invoice_id
641: -- bug 7311486 UTR report must run even if dates and period is not specified
642: -- and ( apph.accounting_date between g_period_start_date and g_period_end_date)

Line 711: ap_org_attributes_gt orgs

707: ,G_SRC_TYP_UNACCT_PMT_HISTORY
708: ,G_SRC_TAB_AP_PMT_HISTORY
709: FROM ap_payment_history_all aph,
710: ap_checks_all ac,
711: ap_org_attributes_gt orgs
712: WHERE aph.posted_flag IN ('N','S')
713: AND ac.check_id = aph.check_id
714: -- bug 7311486 UTR report must run even if dates and period is not specified
715: and (

Line 783: ap_org_attributes_gt orgs

779: ,G_SRC_TYP_UNACCT_INV_PMTS
780: ,G_SRC_TAB_AP_INV_PAYMENTS
781: FROM ap_invoice_payments_all aip,
782: ap_checks_All ac,
783: ap_org_attributes_gt orgs
784: WHERE aip.posted_flag IN ('N','S')
785: -- bug 7311486 UTR report must run even if dates and period is not specified
786: and (
787: (g_action <> G_ACTION_UTR and aip.accounting_date between g_period_start_date and g_period_end_date)

Line 816: ap_org_attributes_gt aagt

812: AND EXISTS
813: (SELECT 1
814: FROM xla_events xe,
815: xla_transaction_entities_upg xte,
816: ap_org_attributes_gt aagt
817: WHERE xe.application_id = 200
818: AND xte.application_id = 200
819: AND xe.event_status_code IN ('U', 'I')
820: AND xe.process_status_code IN ('U', 'I')

Line 909: from ap_org_attributes_gt

905: is
906: cursor c_org_name
907: is
908: select org_name
909: from ap_org_attributes_gt
910: where org_id = g_org_id;
911:
912: lv_name varchar2(100);
913:

Line 947: from ap_org_attributes_gt all_orgs

943:
944: cursor c_cnt_org_access
945: is
946: select count(1)
947: from ap_org_attributes_gt all_orgs
948: where org_id not in (select org_id from ap_system_parameters);
949:
950:
951: begin

Line 955: -- we have a all valid orgs in ap_org_attributes_gt. If a particular org_id is present in ap_org_attributes_gt

951: begin
952: --
953: -- Validation: SWEEP can be done only if all operating units defifned under the given ledger are accessible.
954: --
955: -- we have a all valid orgs in ap_org_attributes_gt. If a particular org_id is present in ap_org_attributes_gt
956: -- but not in ap_system_paramter it means we don't have access to that org
957: --
958:
959: ln_cnt := 0;

Line 1002: AND asi.org_id in (select org_id org_id from ap_org_attributes_gt org_gtt)

998: AP_PAYMENT_UTIL_PKG.get_psr_status(IPSR.payment_service_request_id,
999: IPSR.payment_service_request_status) )
1000: NOT IN ('CONFIRMED','CANCELED','QUICKCHECK', 'CANCELLED NO PAYMENTS', 'TERMINATED')
1001: AND aisc.checkrun_id = asi.checkrun_id
1002: AND asi.org_id in (select org_id org_id from ap_org_attributes_gt org_gtt)
1003: AND rownum = 1;
1004:
1005: -- check if any unmatured future payments exists
1006: cursor c_unmat_fut_pmts_exists

Line 1014: and c.org_id in (select org_id org_id from ap_org_attributes_gt org_gtt)

1010: where c.future_pay_due_date is not null
1011: and c.status_lookup_code = 'ISSUED'
1012: and c.future_pay_due_date between g_period_start_date
1013: and g_period_end_date
1014: and c.org_id in (select org_id org_id from ap_org_attributes_gt org_gtt)
1015: and rownum = 1;
1016:
1017: lv_exists varchar2 (1);
1018: