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.XLA_AC_BALANCES_PKG dependencies on GL_PERIOD_STATUSES

Line 117: p_period_name gl_period_statuses.period_name%TYPE

113: RETURN TRUE;
114: END call_purge_interface_recs;
115:
116: FUNCTION get_period_year(
117: p_period_name gl_period_statuses.period_name%TYPE
118: )
119: RETURN VARCHAR2 AS
120: ------------------------------------------------------------------
121: --Created by : veramach, Oracle India

Line 133: cp_period_name gl_period_statuses.period_name%TYPE

129: --Change History:
130: --Who When What
131: -------------------------------------------------------------------
132: CURSOR c_get_period(
133: cp_period_name gl_period_statuses.period_name%TYPE
134: ) IS
135: SELECT gps.period_year
136: FROM gl_period_statuses gps,
137: xla_ac_balances_int bal

Line 136: FROM gl_period_statuses gps,

132: CURSOR c_get_period(
133: cp_period_name gl_period_statuses.period_name%TYPE
134: ) IS
135: SELECT gps.period_year
136: FROM gl_period_statuses gps,
137: xla_ac_balances_int bal
138: WHERE gps.ledger_id = bal.ledger_id
139: -- AND gps.application_id = bal.application_id
140: AND gps.application_id = 101 --bug 11811413

Line 144: l_period_year gl_period_statuses.period_year%TYPE;

140: AND gps.application_id = 101 --bug 11811413
141: AND gps.adjustment_period_flag = 'N'
142: AND gps.period_name = cp_period_name;
143:
144: l_period_year gl_period_statuses.period_year%TYPE;
145: BEGIN
146: OPEN c_get_period(p_period_name);
147: FETCH c_get_period INTO l_period_year;
148: CLOSE c_get_period;

Line 157: l_period_year gl_period_statuses.period_year%TYPE;

153: PROCEDURE insert_balances_rec(
154: p_ac_balance_int_rec xla_ac_balances%ROWTYPE
155: ) IS
156: l_log_module VARCHAR2(240);
157: l_period_year gl_period_statuses.period_year%TYPE;
158: l_row_count NUMBER;
159: BEGIN
160: IF g_log_enabled THEN
161: l_log_module := c_default_module || '.insert';

Line 252: l_period_year gl_period_statuses.period_year%TYPE;

248: PROCEDURE update_balances_rec(
249: p_ac_balance_int_rec xla_ac_balances%ROWTYPE
250: ) IS
251: l_log_module VARCHAR2(240);
252: l_period_year gl_period_statuses.period_year%TYPE;
253: l_row_count NUMBER;
254: BEGIN
255: IF g_log_enabled THEN
256: l_log_module := c_default_module || '.update_balances_rec';

Line 312: l_period_year gl_period_statuses.period_year%TYPE;

308: PROCEDURE delete_balances_rec(
309: p_ac_balance_int_rec xla_ac_balances%ROWTYPE
310: ) IS
311: l_log_module VARCHAR2(240);
312: l_period_year gl_period_statuses.period_year%TYPE;
313: l_row_count NUMBER;
314: BEGIN
315: IF g_log_enabled THEN
316: l_log_module := c_default_module || '.delete_balances_rec';

Line 416: gl_period_statuses fut_period_statuses,

412: FROM xla_ac_balances xab,
413: gl_ledgers ledger,
414: gl_periods fut_periods,
415: gl_period_types period_types,
416: gl_period_statuses fut_period_statuses,
417: gl_period_sets period_sets
418: WHERE ledger.accounted_period_type = period_types.period_type
419: AND period_types.period_type = fut_periods.period_type
420: AND fut_period_statuses.ledger_id = ledger.ledger_id

Line 472: cp_application_id gl_period_statuses.application_id%TYPE,

468:
469: -- Get current period end date
470: CURSOR c_current_period_end_date(
471: cp_ledger_id gl_ledgers.ledger_id%TYPE,
472: cp_application_id gl_period_statuses.application_id%TYPE,
473: cp_period_name gl_periods.period_name%TYPE,
474: cp_period_year gl_periods.period_year%TYPE
475: ) IS
476: SELECT periods.end_date

Line 480: gl_period_statuses period_statuses,

476: SELECT periods.end_date
477: FROM gl_ledgers ledger,
478: gl_periods periods,
479: gl_period_types period_types,
480: gl_period_statuses period_statuses,
481: gl_period_sets period_sets
482: WHERE ledger.accounted_period_type = period_types.period_type
483: AND period_types.period_type = periods.period_type
484: AND period_statuses.ledger_id = ledger.ledger_id

Line 521: gl_period_statuses period_statuses,

517: FROM xla_ac_balances xab,
518: gl_ledgers ledger,
519: gl_periods periods,
520: gl_period_types period_types,
521: gl_period_statuses period_statuses,
522: gl_period_sets period_sets
523: WHERE ledger.accounted_period_type = period_types.period_type
524: AND period_types.period_type = periods.period_type
525: AND period_statuses.ledger_id = ledger.ledger_id

Line 571: gl_period_statuses fut_period_statuses,

567: fut_periods.period_num
568: FROM gl_ledgers ledger,
569: gl_periods fut_periods,
570: gl_period_types period_types,
571: gl_period_statuses fut_period_statuses,
572: gl_period_sets period_sets
573: WHERE ledger.accounted_period_type = period_types.period_type
574: AND period_types.period_type = fut_periods.period_type
575: AND fut_period_statuses.ledger_id = ledger.ledger_id

Line 625: gl_period_statuses fut_period_statuses,

621: fut_periods.period_num
622: FROM gl_ledgers ledger,
623: gl_periods fut_periods,
624: gl_period_types period_types,
625: gl_period_statuses fut_period_statuses,
626: gl_period_sets period_sets,
627: gl_periods ref_period
628: WHERE ledger.accounted_period_type = period_types.period_type
629: AND period_types.period_type = fut_periods.period_type

Line 661: gl_period_statuses fut_period_statuses,

657: fut_periods.period_num
658: FROM gl_ledgers ledger,
659: gl_periods fut_periods,
660: gl_period_types period_types,
661: gl_period_statuses fut_period_statuses,
662: gl_period_sets period_sets,
663: gl_periods ref_period
664: WHERE ledger.accounted_period_type = period_types.period_type
665: AND period_types.period_type = fut_periods.period_type

Line 712: gl_period_statuses fut_period_statuses,

708: FROM xla_ac_balances xab,
709: gl_ledgers ledger,
710: gl_periods fut_periods,
711: gl_period_types period_types,
712: gl_period_statuses fut_period_statuses,
713: gl_period_sets period_sets
714: WHERE ledger.accounted_period_type = period_types.period_type
715: AND period_types.period_type = fut_periods.period_type
716: AND fut_period_statuses.ledger_id = ledger.ledger_id

Line 1696: ,p_period_name gl_period_statuses.period_name%TYPE) IS

1692: --=============================================================================
1693: CURSOR c_is_valid_period
1694: (p_app_id xla_ac_balances_int.application_id%TYPE
1695: ,p_ledger_id xla_ac_balances_int.ledger_id%TYPE
1696: ,p_period_name gl_period_statuses.period_name%TYPE) IS
1697: select 1
1698: from gl_period_statuses
1699: where application_id =101 --bug 11811413
1700: and ledger_id = p_ledger_id

Line 1698: from gl_period_statuses

1694: (p_app_id xla_ac_balances_int.application_id%TYPE
1695: ,p_ledger_id xla_ac_balances_int.ledger_id%TYPE
1696: ,p_period_name gl_period_statuses.period_name%TYPE) IS
1697: select 1
1698: from gl_period_statuses
1699: where application_id =101 --bug 11811413
1700: and ledger_id = p_ledger_id
1701: and period_name=p_period_name
1702: AND closing_status IN ('O','C');