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.adjustment_period_flag = 'N'

Line 143: l_period_year gl_period_statuses.period_year%TYPE;

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

Line 156: l_period_year gl_period_statuses.period_year%TYPE;

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

Line 251: l_period_year gl_period_statuses.period_year%TYPE;

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

Line 311: l_period_year gl_period_statuses.period_year%TYPE;

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

Line 415: gl_period_statuses fut_period_statuses,

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

Line 470: cp_application_id gl_period_statuses.application_id%TYPE,

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

Line 478: gl_period_statuses period_statuses,

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

Line 518: gl_period_statuses period_statuses,

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

Line 567: gl_period_statuses fut_period_statuses,

563: fut_periods.period_num
564: FROM gl_ledgers ledger,
565: gl_periods fut_periods,
566: gl_period_types period_types,
567: gl_period_statuses fut_period_statuses,
568: gl_period_sets period_sets
569: WHERE ledger.accounted_period_type = period_types.period_type
570: AND period_types.period_type = fut_periods.period_type
571: AND fut_period_statuses.ledger_id = ledger.ledger_id

Line 620: gl_period_statuses fut_period_statuses,

616: fut_periods.period_num
617: FROM gl_ledgers ledger,
618: gl_periods fut_periods,
619: gl_period_types period_types,
620: gl_period_statuses fut_period_statuses,
621: gl_period_sets period_sets,
622: gl_periods ref_period
623: WHERE ledger.accounted_period_type = period_types.period_type
624: AND period_types.period_type = fut_periods.period_type

Line 655: gl_period_statuses fut_period_statuses,

651: fut_periods.period_num
652: FROM gl_ledgers ledger,
653: gl_periods fut_periods,
654: gl_period_types period_types,
655: gl_period_statuses fut_period_statuses,
656: gl_period_sets period_sets,
657: gl_periods ref_period
658: WHERE ledger.accounted_period_type = period_types.period_type
659: AND period_types.period_type = fut_periods.period_type

Line 705: gl_period_statuses fut_period_statuses,

701: FROM xla_ac_balances xab,
702: gl_ledgers ledger,
703: gl_periods fut_periods,
704: gl_period_types period_types,
705: gl_period_statuses fut_period_statuses,
706: gl_period_sets period_sets
707: WHERE ledger.accounted_period_type = period_types.period_type
708: AND period_types.period_type = fut_periods.period_type
709: AND fut_period_statuses.ledger_id = ledger.ledger_id

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

1684: --=============================================================================
1685: CURSOR c_is_valid_period
1686: (p_app_id xla_ac_balances_int.application_id%TYPE
1687: ,p_ledger_id xla_ac_balances_int.ledger_id%TYPE
1688: ,p_period_name gl_period_statuses.period_name%TYPE) IS
1689: select 1
1690: from gl_period_statuses
1691: where application_id =p_app_id
1692: and ledger_id = p_ledger_id

Line 1690: from gl_period_statuses

1686: (p_app_id xla_ac_balances_int.application_id%TYPE
1687: ,p_ledger_id xla_ac_balances_int.ledger_id%TYPE
1688: ,p_period_name gl_period_statuses.period_name%TYPE) IS
1689: select 1
1690: from gl_period_statuses
1691: where application_id =p_app_id
1692: and ledger_id = p_ledger_id
1693: and period_name=p_period_name
1694: AND closing_status IN ('O','C');