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 XLA_PERIOD_CLOSE_EXP_PKG

Line 168: type xla_period_close_header_tab is table of XLA_PERIOD_CLOSE_EXP_PKG.period_close_hdr_date_cur%rowtype;

164: data reported by SLA cursors.
165: For bugs related to events not picked by SLA cursors log a
166: bug against SLA team.
167: */
168: type xla_period_close_header_tab is table of XLA_PERIOD_CLOSE_EXP_PKG.period_close_hdr_date_cur%rowtype;
169: xla_headers_untransfered xla_period_close_header_tab := xla_period_close_header_tab();
170:
171: type xla_period_close_evt_tab is table of XLA_PERIOD_CLOSE_EXP_PKG.period_close_evt_date_cur%rowtype;
172: xla_events_unacct xla_period_close_evt_tab := xla_period_close_evt_tab();

Line 171: type xla_period_close_evt_tab is table of XLA_PERIOD_CLOSE_EXP_PKG.period_close_evt_date_cur%rowtype;

167: */
168: type xla_period_close_header_tab is table of XLA_PERIOD_CLOSE_EXP_PKG.period_close_hdr_date_cur%rowtype;
169: xla_headers_untransfered xla_period_close_header_tab := xla_period_close_header_tab();
170:
171: type xla_period_close_evt_tab is table of XLA_PERIOD_CLOSE_EXP_PKG.period_close_evt_date_cur%rowtype;
172: xla_events_unacct xla_period_close_evt_tab := xla_period_close_evt_tab();
173:
174: l_rowcount NUMBER := NULL; -- bug 9509700
175:

Line 730: OPEN xla_period_close_exp_pkg.period_close_hdr_date_cur(200,g_ledger_id,g_period_start_date,g_period_end_date);

726: * not specifically over a period. Modified the call to SLA cursor to pass
727: * start date and end date instead of passing period name
728: */
729: IF g_action = G_ACTION_PERIOD_CLOSE THEN
730: OPEN xla_period_close_exp_pkg.period_close_hdr_date_cur(200,g_ledger_id,g_period_start_date,g_period_end_date);
731: xla_headers_untransfered.EXTEND();
732: FETCH xla_period_close_exp_pkg.period_close_hdr_date_cur INTO xla_headers_untransfered(1);
733: CLOSE xla_period_close_exp_pkg.period_close_hdr_date_cur;
734: IF xla_headers_untransfered(1).event_id IS NOT NULL THEN

Line 732: FETCH xla_period_close_exp_pkg.period_close_hdr_date_cur INTO xla_headers_untransfered(1);

728: */
729: IF g_action = G_ACTION_PERIOD_CLOSE THEN
730: OPEN xla_period_close_exp_pkg.period_close_hdr_date_cur(200,g_ledger_id,g_period_start_date,g_period_end_date);
731: xla_headers_untransfered.EXTEND();
732: FETCH xla_period_close_exp_pkg.period_close_hdr_date_cur INTO xla_headers_untransfered(1);
733: CLOSE xla_period_close_exp_pkg.period_close_hdr_date_cur;
734: IF xla_headers_untransfered(1).event_id IS NOT NULL THEN
735: RETURN 'Y';
736: END IF;

Line 733: CLOSE xla_period_close_exp_pkg.period_close_hdr_date_cur;

729: IF g_action = G_ACTION_PERIOD_CLOSE THEN
730: OPEN xla_period_close_exp_pkg.period_close_hdr_date_cur(200,g_ledger_id,g_period_start_date,g_period_end_date);
731: xla_headers_untransfered.EXTEND();
732: FETCH xla_period_close_exp_pkg.period_close_hdr_date_cur INTO xla_headers_untransfered(1);
733: CLOSE xla_period_close_exp_pkg.period_close_hdr_date_cur;
734: IF xla_headers_untransfered(1).event_id IS NOT NULL THEN
735: RETURN 'Y';
736: END IF;
737:

Line 738: OPEN xla_period_close_exp_pkg.period_close_evt_date_cur(200,g_ledger_id,g_period_start_date,g_period_end_date);

734: IF xla_headers_untransfered(1).event_id IS NOT NULL THEN
735: RETURN 'Y';
736: END IF;
737:
738: OPEN xla_period_close_exp_pkg.period_close_evt_date_cur(200,g_ledger_id,g_period_start_date,g_period_end_date);
739: xla_events_unacct.EXTEND();
740: FETCH xla_period_close_exp_pkg.period_close_evt_date_cur INTO xla_events_unacct(1);
741: CLOSE xla_period_close_exp_pkg.period_close_evt_date_cur;
742: IF xla_events_unacct(1).event_id IS NOT NULL THEN

Line 740: FETCH xla_period_close_exp_pkg.period_close_evt_date_cur INTO xla_events_unacct(1);

736: END IF;
737:
738: OPEN xla_period_close_exp_pkg.period_close_evt_date_cur(200,g_ledger_id,g_period_start_date,g_period_end_date);
739: xla_events_unacct.EXTEND();
740: FETCH xla_period_close_exp_pkg.period_close_evt_date_cur INTO xla_events_unacct(1);
741: CLOSE xla_period_close_exp_pkg.period_close_evt_date_cur;
742: IF xla_events_unacct(1).event_id IS NOT NULL THEN
743: RETURN 'Y';
744: END IF;

Line 741: CLOSE xla_period_close_exp_pkg.period_close_evt_date_cur;

737:
738: OPEN xla_period_close_exp_pkg.period_close_evt_date_cur(200,g_ledger_id,g_period_start_date,g_period_end_date);
739: xla_events_unacct.EXTEND();
740: FETCH xla_period_close_exp_pkg.period_close_evt_date_cur INTO xla_events_unacct(1);
741: CLOSE xla_period_close_exp_pkg.period_close_evt_date_cur;
742: IF xla_events_unacct(1).event_id IS NOT NULL THEN
743: RETURN 'Y';
744: END IF;
745:

Line 750: OPEN xla_period_close_exp_pkg.period_close_hdr_date_cur(200,g_ledger_id,g_period_start_date,g_period_end_date);

746: ELSE
747:
748: IF g_action = G_ACTION_PCER THEN
749: -- Insert untransferred headers to GT table only if action is PCER
750: OPEN xla_period_close_exp_pkg.period_close_hdr_date_cur(200,g_ledger_id,g_period_start_date,g_period_end_date);
751: FETCH xla_period_close_exp_pkg.period_close_hdr_date_cur
752: BULK COLLECT INTO xla_headers_untransfered;
753: CLOSE xla_period_close_exp_pkg.period_close_hdr_date_cur;
754:

Line 751: FETCH xla_period_close_exp_pkg.period_close_hdr_date_cur

747:
748: IF g_action = G_ACTION_PCER THEN
749: -- Insert untransferred headers to GT table only if action is PCER
750: OPEN xla_period_close_exp_pkg.period_close_hdr_date_cur(200,g_ledger_id,g_period_start_date,g_period_end_date);
751: FETCH xla_period_close_exp_pkg.period_close_hdr_date_cur
752: BULK COLLECT INTO xla_headers_untransfered;
753: CLOSE xla_period_close_exp_pkg.period_close_hdr_date_cur;
754:
755: IF xla_headers_untransfered.COUNT> 0 THEN

Line 753: CLOSE xla_period_close_exp_pkg.period_close_hdr_date_cur;

749: -- Insert untransferred headers to GT table only if action is PCER
750: OPEN xla_period_close_exp_pkg.period_close_hdr_date_cur(200,g_ledger_id,g_period_start_date,g_period_end_date);
751: FETCH xla_period_close_exp_pkg.period_close_hdr_date_cur
752: BULK COLLECT INTO xla_headers_untransfered;
753: CLOSE xla_period_close_exp_pkg.period_close_hdr_date_cur;
754:
755: IF xla_headers_untransfered.COUNT> 0 THEN
756: FOR i IN xla_headers_untransfered.FIRST..xla_headers_untransfered.LAST
757: LOOP

Line 820: OPEN xla_period_close_exp_pkg.period_close_evt_date_cur(200,g_ledger_id,g_period_start_date,g_period_end_date);

816: END LOOP;
817: END IF;
818: END IF;
819:
820: OPEN xla_period_close_exp_pkg.period_close_evt_date_cur(200,g_ledger_id,g_period_start_date,g_period_end_date);
821: FETCH xla_period_close_exp_pkg.period_close_evt_date_cur
822: BULK COLLECT INTO xla_events_unacct;
823: CLOSE xla_period_close_exp_pkg.period_close_evt_date_cur;
824:

Line 821: FETCH xla_period_close_exp_pkg.period_close_evt_date_cur

817: END IF;
818: END IF;
819:
820: OPEN xla_period_close_exp_pkg.period_close_evt_date_cur(200,g_ledger_id,g_period_start_date,g_period_end_date);
821: FETCH xla_period_close_exp_pkg.period_close_evt_date_cur
822: BULK COLLECT INTO xla_events_unacct;
823: CLOSE xla_period_close_exp_pkg.period_close_evt_date_cur;
824:
825: IF xla_events_unacct.COUNT> 0 THEN

Line 823: CLOSE xla_period_close_exp_pkg.period_close_evt_date_cur;

819:
820: OPEN xla_period_close_exp_pkg.period_close_evt_date_cur(200,g_ledger_id,g_period_start_date,g_period_end_date);
821: FETCH xla_period_close_exp_pkg.period_close_evt_date_cur
822: BULK COLLECT INTO xla_events_unacct;
823: CLOSE xla_period_close_exp_pkg.period_close_evt_date_cur;
824:
825: IF xla_events_unacct.COUNT> 0 THEN
826: FOR i IN xla_events_unacct.FIRST..xla_events_unacct.LAST
827: LOOP