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_BALANCES_PKG dependencies on XLA_BALANCE_STATUSES

Line 343: FROM xla_balance_statuses xbs

339: ,cp_request_id INTEGER
340: )
341: IS
342: SELECT xbs.code_combination_id
343: FROM xla_balance_statuses xbs
344: WHERE xbs.application_id = cp_application_id
345: AND xbs.ledger_id = cp_ledger_id
346: AND xbs.balance_status_code = cp_balance_status_code
347: AND xbs.balance_source_code = cp_balance_source_code

Line 541: ,p_msg => 'trying to lock xla_balance_statuses'

537: ,p_level => C_LEVEL_STATEMENT
538: );
539: trace
540: (p_module => l_log_module
541: ,p_msg => 'trying to lock xla_balance_statuses'
542: ,p_level => C_LEVEL_STATEMENT
543: );
544: END IF;
545: LOCK TABLE xla_balance_statuses IN EXCLUSIVE MODE NOWAIT;

Line 545: LOCK TABLE xla_balance_statuses IN EXCLUSIVE MODE NOWAIT;

541: ,p_msg => 'trying to lock xla_balance_statuses'
542: ,p_level => C_LEVEL_STATEMENT
543: );
544: END IF;
545: LOCK TABLE xla_balance_statuses IN EXCLUSIVE MODE NOWAIT;
546:
547: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
548: trace
549: (p_module => l_log_module

Line 568: UPDATE xla_balance_statuses xbsext

564:
565: END IF;
566:
567: l_date := SYSDATE;
568: UPDATE xla_balance_statuses xbsext
569: SET xbsext.balance_status_code = p_balance_status_code_selected
570: ,xbsext.last_update_date = l_date
571: ,xbsext.last_updated_by = l_user_id
572: ,xbsext.last_update_login = l_login_id

Line 579: FROM xla_balance_statuses xbs

575: ,xbsext.program_id = l_prog_id
576: ,xbsext.request_id = NVL(l_req_id, -1)
577: WHERE xbsext.ROWID IN
578: (SELECT xbs.ROWID
579: FROM xla_balance_statuses xbs
580: ,fnd_concurrent_requests fnd
581: WHERE xbs.application_id = p_application_id
582: AND xbs.ledger_id = p_ledger_id
583: AND xbs.balance_source_code = NVL( p_balance_source_code

Line 600: FROM xla_balance_statuses xbs

596: --handle the case where the procedure is invoked
597: --outside a concurrent request
598: UNION
599: SELECT xbs.ROWID
600: FROM xla_balance_statuses xbs
601: WHERE xbs.application_id = p_application_id
602: AND xbs.ledger_id = p_ledger_id
603: AND xbs.balance_source_code = NVL( p_balance_source_code
604: ,xbs.balance_source_code

Line 620: || ' xla_balance_statuses updated to '

616: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
617: trace
618: (p_module => l_log_module
619: ,p_msg => l_row_count
620: || ' xla_balance_statuses updated to '
621: || p_balance_status_code_selected
622: ,p_level => C_LEVEL_STATEMENT
623: );
624: END IF;

Line 647: ,p_msg => 'trying to lock xla_balance_statuses'

643: ,p_level => C_LEVEL_STATEMENT
644: );
645: trace
646: (p_module => l_log_module
647: ,p_msg => 'trying to lock xla_balance_statuses'
648: ,p_level => C_LEVEL_STATEMENT
649: );
650: END IF;
651: LOCK TABLE xla_balance_statuses IN EXCLUSIVE MODE NOWAIT;

Line 651: LOCK TABLE xla_balance_statuses IN EXCLUSIVE MODE NOWAIT;

647: ,p_msg => 'trying to lock xla_balance_statuses'
648: ,p_level => C_LEVEL_STATEMENT
649: );
650: END IF;
651: LOCK TABLE xla_balance_statuses IN EXCLUSIVE MODE NOWAIT;
652:
653: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
654: trace
655: (p_module => l_log_module

Line 675: --lock xla_balance_statuses and wait if necessary

671: END IF;
672:
673: IF NVL(p_balance_source_code, 'C') = 'C'
674: THEN
675: --lock xla_balance_statuses and wait if necessary
676: OPEN lc_lock_balance_statuses
677: ( cp_application_id => p_application_id
678: ,cp_ledger_id => p_ledger_id
679: ,cp_balance_status_code => p_balance_status_code_selected

Line 800: FROM xla_balance_statuses xbs

796: ,l_prog_appl_id --program_application_id
797: ,l_prog_id --program_id
798: ,NVL(l_req_id, -1) --request_id
799: ,l_dest_effective_period_num
800: FROM xla_balance_statuses xbs
801: ,xla_control_balances xba
802: ,xla_control_balances xbanew
803: WHERE xbs.application_id = p_application_id
804: AND xbs.ledger_id = p_ledger_id

Line 838: --lock xla_balance_statuses and wait if necessary

834: END IF;
835:
836: IF NVL(p_balance_source_code, 'A') = 'A'
837: THEN
838: --lock xla_balance_statuses and wait if necessary
839: OPEN lc_lock_balance_statuses
840: ( cp_application_id => p_application_id
841: ,cp_ledger_id => p_ledger_id
842: ,cp_balance_status_code => p_balance_status_code_selected

Line 937: FROM xla_balance_statuses xbs

933: ,l_prog_appl_id --program_application_id
934: ,l_prog_id --program_id
935: ,NVL(l_req_id, -1) --request_id
936: ,l_dest_effective_period_num
937: FROM xla_balance_statuses xbs
938: ,xla_ac_balances xba
939: ,xla_analytical_hdrs_b xbh
940: WHERE xbs.application_id = p_application_id
941: AND xbs.ledger_id = p_ledger_id

Line 1000: --Update the records in xla_balance_statuses.

996: COMMIT;
997:
998: END LOOP; --until there are no more balances to create in this period
999:
1000: --Update the records in xla_balance_statuses.
1001: l_date := SYSDATE;
1002:
1003: UPDATE xla_balance_statuses xbs
1004: SET xbs.balance_status_code = p_balance_status_code_not_sel

Line 1003: UPDATE xla_balance_statuses xbs

999:
1000: --Update the records in xla_balance_statuses.
1001: l_date := SYSDATE;
1002:
1003: UPDATE xla_balance_statuses xbs
1004: SET xbs.balance_status_code = p_balance_status_code_not_sel
1005: ,xbs.effective_period_num = l_dest_effective_period_num
1006: ,last_update_date = l_date
1007: ,last_updated_by = l_user_id

Line 1028: ' xla_balance_statuses updated to '

1024: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1025: trace
1026: (p_module => l_log_module
1027: ,p_msg => l_row_count ||
1028: ' xla_balance_statuses updated to '
1029: || p_balance_status_code_not_sel
1030: ,p_level => C_LEVEL_STATEMENT
1031: );
1032: END IF;

Line 1132: FROM xla_balance_statuses xbs

1128: END IF;
1129:
1130: SELECT MIN(xbs.effective_period_num)
1131: INTO l_min_bal_effective_period_num
1132: FROM xla_balance_statuses xbs
1133: WHERE xbs.application_id = p_application_id
1134: AND xbs.ledger_id = p_ledger_id
1135: AND xbs.balance_source_code = p_balance_source_code;
1136:

Line 1319: ,xla_balance_statuses xbs

1315: CURSOR c_lock_control_statuses
1316: IS
1317: SELECT 1
1318: FROM xla_bal_ctrl_lines_gt xbct
1319: ,xla_balance_statuses xbs
1320: WHERE xbs.application_id = xbct.application_id
1321: AND xbs.ledger_id = xbct.ledger_id
1322: AND xbs.code_combination_id = xbct.code_combination_id
1323: AND xbs.balance_source_code = 'C'

Line 1330: ,xla_balance_statuses xbs

1326: CURSOR c_lock_analytical_statuses
1327: IS
1328: SELECT /*+ full(xblt) */ 1
1329: FROM xla_bal_anacri_lines_gt xblt
1330: ,xla_balance_statuses xbs
1331: WHERE xbs.application_id = xblt.application_id
1332: AND xbs.ledger_id = xblt.ledger_id
1333: AND xbs.code_combination_id = xblt.code_combination_id
1334: AND xbs.balance_source_code = 'A'

Line 1383: ,p_msg => 'Start inserting in xla_balance_statuses'

1379:
1380: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1381: trace
1382: (p_module => l_log_module
1383: ,p_msg => 'Start inserting in xla_balance_statuses'
1384: ,p_level => C_LEVEL_STATEMENT
1385: );
1386: END IF;
1387:

Line 1388: --Create the missing records in xla_balance_statuses, if any.

1384: ,p_level => C_LEVEL_STATEMENT
1385: );
1386: END IF;
1387:
1388: --Create the missing records in xla_balance_statuses, if any.
1389: INSERT INTO xla_bal_statuses_gt
1390: ( application_id
1391: ,ledger_id
1392: ,code_combination_id

Line 1412: ,xla_balance_statuses xbs

1408: ,'TO BE DETERMINED'
1409: ,'TO BE DETERMINED'
1410: ,'?'
1411: FROM xla_bal_ctrl_lines_gt xbct
1412: ,xla_balance_statuses xbs
1413: WHERE xbs.application_id (+)= xbct.application_id
1414: AND xbs.ledger_id (+)= xbct.ledger_id
1415: AND xbs.code_combination_id (+)= xbct.code_combination_id
1416: AND xbs.balance_source_code (+)= 'C'

Line 1432: ,xla_balance_statuses xbs

1428: ,'TO BE DETERMINED'
1429: ,'TO BE DETERMINED'
1430: ,'?'
1431: FROM xla_bal_anacri_lines_gt xbat
1432: ,xla_balance_statuses xbs
1433: WHERE xbs.application_id (+)= xbat.application_id
1434: AND xbs.ledger_id (+)= xbat.ledger_id
1435: AND xbs.code_combination_id (+)= xbat.code_combination_id
1436: AND xbs.balance_source_code (+)= 'A'

Line 1572: INSERT INTO xla_balance_statuses

1568: END IF;
1569:
1570: END LOOP;
1571:
1572: INSERT INTO xla_balance_statuses
1573: ( application_id
1574: ,ledger_id
1575: ,code_combination_id
1576: ,balance_source_code

Line 1618: ' records inserted in xla_balance_statuses'

1614: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1615: trace
1616: (p_module => l_log_module
1617: ,p_msg => l_row_count ||
1618: ' records inserted in xla_balance_statuses'
1619: ,p_level => C_LEVEL_STATEMENT
1620: );
1621: END IF;
1622:

Line 1626: ,p_msg => ' Start locking xla_balance_statuses'

1622:
1623: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1624: trace
1625: (p_module => l_log_module
1626: ,p_msg => ' Start locking xla_balance_statuses'
1627: ,p_level => C_LEVEL_STATEMENT
1628: );
1629: END IF;
1630:

Line 1631: --Lock the records in xla_balance_statuses.

1627: ,p_level => C_LEVEL_STATEMENT
1628: );
1629: END IF;
1630:
1631: --Lock the records in xla_balance_statuses.
1632:
1633: OPEN c_lock_control_statuses;
1634: CLOSE c_lock_control_statuses;
1635: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 1638: ,p_msg => 'Records in xla_balance_statuses (control) have been locked.'

1634: CLOSE c_lock_control_statuses;
1635: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1636: trace
1637: (p_module => l_log_module
1638: ,p_msg => 'Records in xla_balance_statuses (control) have been locked.'
1639: ,p_level => C_LEVEL_STATEMENT
1640: );
1641: END IF;
1642:

Line 1648: ,p_msg => 'Records in xla_balance_statuses (anacri) have been locked.'

1644: CLOSE c_lock_analytical_statuses;
1645: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1646: trace
1647: (p_module => l_log_module
1648: ,p_msg => 'Records in xla_balance_statuses (anacri) have been locked.'
1649: ,p_level => C_LEVEL_STATEMENT
1650: );
1651: END IF;
1652:

Line 1668: ,p_msg => 'Cannot lock xla_balance_statuses records'

1664: THEN
1665: IF (C_LEVEL_ERROR >= g_log_level) THEN
1666: trace
1667: (p_module => l_log_module
1668: ,p_msg => 'Cannot lock xla_balance_statuses records'
1669: ,p_level => C_LEVEL_ERROR
1670: );
1671: END IF;
1672: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN

Line 3502: FROM xla_balance_statuses xbs

3498: ,l_prog_appl_id
3499: ,l_prog_id
3500: ,NVL(l_req_id, -1)
3501: ,gpsbs.effective_period_num
3502: FROM xla_balance_statuses xbs
3503: ,gl_period_statuses gpsbs
3504: ,xla_control_balances xba
3505: ,gl_period_statuses gpsnew
3506: WHERE xbs.application_id = p_application_id

Line 3661: FROM xla_balance_statuses xbs

3657: ,l_prog_appl_id
3658: ,l_prog_id
3659: ,NVL(l_req_id, -1)
3660: ,gpsbs.effective_period_num
3661: FROM xla_balance_statuses xbs
3662: ,gl_period_statuses gpsbs
3663: ,xla_ac_balances xba
3664: ,gl_period_statuses gpsnew
3665: ,xla_analytical_hdrs_b xbh

Line 6593: FROM xla_balance_statuses xbs

6589: =
6590: (
6591: SELECT xbs.balance_status_code
6592: ,xbs.effective_period_num
6593: FROM xla_balance_statuses xbs
6594: WHERE xbs.application_id = xbct.application_id
6595: AND xbs.ledger_id = xbct.ledger_id
6596: AND xbs.code_combination_id = xbct.code_combination_id
6597: AND xbs.balance_source_code = 'C'

Line 6621: FROM xla_balance_statuses xbs

6617: (
6618: SELECT xbs.balance_status_code
6619: ,xbs.effective_period_num
6620: ,xbs.account_type
6621: FROM xla_balance_statuses xbs
6622: WHERE xbs.application_id = xbat.application_id
6623: AND xbs.ledger_id = xbat.ledger_id
6624: AND xbs.code_combination_id = xbat.code_combination_id
6625: AND xbs.balance_source_code = 'A'

Line 8067: FROM xla_balance_statuses xbs

8063: DELETE
8064: FROM xla_control_balances xcbext
8065: WHERE xcbext.ROWID IN
8066: ( SELECT xcb.ROWID
8067: FROM xla_balance_statuses xbs
8068: ,xla_control_balances xcb
8069: ,gl_period_statuses gps
8070: WHERE xbs.balance_source_code = 'C'
8071: AND xbs.balance_status_code = 'R'

Line 8127: FROM xla_balance_statuses xbs

8123: DELETE
8124: FROM xla_ac_balances xabext
8125: WHERE xabext.ROWID IN
8126: ( SELECT xab.ROWID
8127: FROM xla_balance_statuses xbs
8128: ,xla_ac_balances xab
8129: ,gl_period_statuses gps
8130: WHERE xbs.balance_source_code = 'A'
8131: AND xbs.balance_status_code = 'R'

Line 8176: FROM xla_balance_statuses xbs

8172: ,ael.control_balance_flag
8173: )
8174: WHERE ael.ROWID IN
8175: (SELECT xal.ROWID
8176: FROM xla_balance_statuses xbs
8177: ,xla_ae_headers xah
8178: ,xla_ae_lines xal
8179: ,gl_period_statuses gps
8180: WHERE xbs.balance_status_code = 'R'

Line 8235: FROM xla_balance_statuses xbs

8231: ,ael.analytical_balance_flag
8232: )
8233: WHERE ael.ROWID IN
8234: (SELECT xal.ROWID
8235: FROM xla_balance_statuses xbs
8236: ,xla_ae_headers xah
8237: ,xla_ae_lines xal
8238: ,gl_period_statuses gps
8239: WHERE xbs.balance_status_code = 'R'

Line 8278: UPDATE xla_balance_statuses xbs

8274:
8275: --Phase 2: Balance calculation
8276: LOOP
8277: l_date := SYSDATE;
8278: UPDATE xla_balance_statuses xbs
8279: SET xbs.balance_status_code = 'B'
8280: ,xbs.effective_period_num = (SELECT LEAST( NVL( xbs.recreate_effective_period_num
8281: ,MAX(gps.effective_period_num)
8282: )

Line 8308: ,p_msg => l_row_count || ' xla_balance_statuses updated to B'

8304:
8305: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
8306: trace
8307: ( p_module => l_log_module
8308: ,p_msg => l_row_count || ' xla_balance_statuses updated to B'
8309: ,p_level => C_LEVEL_STATEMENT
8310: );
8311: END IF;
8312:

Line 8337: FROM xla_balance_statuses xbs

8333: SELECT xbs.ledger_id
8334: ,MIN(xbs.recreate_effective_period_num)
8335: INTO l_current_ledger_id
8336: ,l_current_effective_period_num
8337: FROM xla_balance_statuses xbs
8338: WHERE xbs.balance_status_code = 'B'
8339: AND xbs.request_id = NVL(l_req_id, -1)
8340: AND ROWNUM = 1
8341: GROUP BY xbs.ledger_id;

Line 8467: UPDATE xla_balance_statuses xbs

8463:
8464: END LOOP;
8465:
8466: l_date := SYSDATE;
8467: UPDATE xla_balance_statuses xbs
8468: SET xbs.balance_status_code = 'C'
8469: ,last_update_date = l_date
8470: ,last_updated_by = l_user_id
8471: ,last_update_login = l_login_id

Line 8486: || ' xla_balance_statuses updated to C'

8482: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
8483: trace
8484: (p_module => l_log_module
8485: ,p_msg => l_row_count
8486: || ' xla_balance_statuses updated to C'
8487: ,p_level => C_LEVEL_STATEMENT
8488: );
8489: END IF;
8490:

Line 8500: FROM xla_balance_statuses xbs

8496:
8497:
8498: SELECT count(*)
8499: INTO l_warning_count
8500: FROM xla_balance_statuses xbs
8501: WHERE xbs.request_id = NVL(l_req_id, -1)
8502: AND NVL(xbs.warning_flag, 'N') = 'Y';
8503:
8504: IF l_warning_count > 0

Line 8524: UPDATE xla_balance_statuses xbs

8520:
8521: LOOP
8522: l_date := SYSDATE;
8523:
8524: UPDATE xla_balance_statuses xbs
8525: SET xbs.balance_status_code = 'A'
8526: ,last_update_date = l_date
8527: ,last_updated_by = l_user_id
8528: ,last_update_login = l_login_id

Line 8542: , p_msg => l_row_count || ' xla_balance_statuses updated to A'

8538:
8539: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
8540: trace
8541: (p_module => l_log_module
8542: , p_msg => l_row_count || ' xla_balance_statuses updated to A'
8543: ,p_level => C_LEVEL_STATEMENT
8544: );
8545: END IF;
8546:

Line 8566: UPDATE xla_balance_statuses xbs

8562: IF l_return_value
8563: THEN
8564: LOOP
8565: l_date := SYSDATE;
8566: UPDATE xla_balance_statuses xbs
8567: SET xbs.balance_status_code = 'A'
8568: ,last_update_date = l_date
8569: ,last_updated_by = l_user_id
8570: ,last_update_login = l_login_id

Line 8584: ,p_msg => l_row_count || ' xla_balance_statuses updated to A'

8580:
8581: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
8582: trace
8583: ( p_module => l_log_module
8584: ,p_msg => l_row_count || ' xla_balance_statuses updated to A'
8585: ,p_level => C_LEVEL_STATEMENT
8586: );
8587: END IF;
8588:

Line 8759: FROM xla_balance_statuses xbs

8755: SELECT xbs.application_id
8756: ,xbs.ledger_id
8757: ,xbs.code_combination_id
8758: ,xbs.balance_source_code
8759: FROM xla_balance_statuses xbs
8760: ,gl_code_combinations gcc
8761: ,xla_bal_recreate_gt xbt
8762: WHERE gcc.code_combination_id = xbs.code_combination_id
8763: AND xbt.application_id (+)= xbs.application_id

Line 8818: UPDATE xla_balance_statuses xbsext

8814:
8815: --try to bring the balances off line for recreation
8816: LOOP
8817: l_date := SYSDATE;
8818: UPDATE xla_balance_statuses xbsext
8819: SET xbsext.balance_status_code = DECODE( xbsext.balance_status_code
8820: ,'A'
8821: ,'R'
8822: ,xbsext.balance_status_code

Line 8869: ,xla_balance_statuses xbs

8865: ,xbsext.request_id = NVL(l_req_id, -1)
8866: WHERE xbsext.ROWID IN
8867: (SELECT xbs.ROWID
8868: FROM xla_bal_recreate_gt xbt
8869: ,xla_balance_statuses xbs
8870: ,fnd_concurrent_requests fnd
8871: WHERE xbs.application_id = xbt.application_id
8872: AND xbs.ledger_id = xbt.ledger_id
8873: AND xbs.code_combination_id = xbt.code_combination_id

Line 8886: FROM xla_balance_statuses xbs

8882: )
8883: )
8884: UNION
8885: SELECT xbs.ROWID
8886: FROM xla_balance_statuses xbs
8887: WHERE xbs.application_id = NVL( p_application_id
8888: ,xbs.application_id
8889: )
8890: AND xbs.ledger_id = NVL( p_ledger_id

Line 8906: ,p_msg => l_row_count || ' xla_balance_statuses updated to R'

8902:
8903: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
8904: trace
8905: ( p_module => l_log_module
8906: ,p_msg => l_row_count || ' xla_balance_statuses updated to R'
8907: ,p_level => C_LEVEL_STATEMENT
8908: );
8909: END IF;
8910:

Line 8923: ,xla_balance_statuses xbs

8919:
8920: SELECT count(*)
8921: INTO l_count_unavailable
8922: FROM xla_bal_recreate_gt xbt
8923: ,xla_balance_statuses xbs
8924: WHERE xbs.application_id = xbt.application_id
8925: AND xbs.ledger_id = xbt.ledger_id
8926: AND xbs.code_combination_id = xbt.code_combination_id
8927: AND xbs.balance_source_code = xbt.balance_source_code

Line 9025: UPDATE xla_balance_statuses xbsext

9021: --try to bring the balances off line
9022: LOOP
9023: l_date := SYSDATE;
9024:
9025: UPDATE xla_balance_statuses xbsext
9026: SET xbsext.balance_status_code = DECODE( xbsext.balance_status_code
9027: ,'A'
9028: ,'R'
9029: ,xbsext.balance_status_code

Line 9075: FROM xla_balance_statuses xbs

9071: ,xbsext.program_id = l_prog_id
9072: ,xbsext.request_id = l_req_id
9073: WHERE xbsext.ROWID IN
9074: (SELECT xbs.ROWID
9075: FROM xla_balance_statuses xbs
9076: ,fnd_concurrent_requests fnd
9077: WHERE xbs.application_id = NVL( p_application_id
9078: ,xbs.application_id
9079: )

Line 9094: FROM xla_balance_statuses xbs

9090: )
9091: )
9092: UNION
9093: SELECT xbs.ROWID
9094: FROM xla_balance_statuses xbs
9095: WHERE xbs.application_id = NVL( p_application_id
9096: ,xbs.application_id
9097: )
9098: AND xbs.ledger_id = NVL( p_ledger_id

Line 9114: ,p_msg => l_row_count || ' xla_balance_statuses updated to R'

9110:
9111: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
9112: trace
9113: ( p_module => l_log_module
9114: ,p_msg => l_row_count || ' xla_balance_statuses updated to R'
9115: ,p_level => C_LEVEL_STATEMENT
9116: );
9117:
9118: END IF;

Line 9132: FROM xla_balance_statuses xbs

9128:
9129:
9130: SELECT count(*)
9131: INTO l_count_unavailable
9132: FROM xla_balance_statuses xbs
9133: WHERE xbs.application_id = NVL( p_application_id
9134: ,xbs.application_id
9135: )
9136: AND xbs.ledger_id = NVL( p_ledger_id

Line 9598: UPDATE xla_balance_statuses xbsext

9594:
9595: --try to bring the balances off line
9596: LOOP
9597:
9598: UPDATE xla_balance_statuses xbsext
9599: SET xbsext.balance_status_code = 'S'
9600: ,xbsext.last_update_date = l_date
9601: ,xbsext.last_updated_by = l_user_id
9602: ,xbsext.last_update_login = l_login_id

Line 9609: FROM xla_balance_statuses xbs

9605: ,xbsext.program_id = l_prog_id
9606: ,xbsext.request_id = NVL(l_req_id, -1)
9607: WHERE xbsext.ROWID IN
9608: (SELECT xbs.ROWID
9609: FROM xla_balance_statuses xbs
9610: ,fnd_concurrent_requests fnd
9611: WHERE xbs.ledger_id IN
9612: (
9613: SELECT xgl.ledger_id

Line 9629: FROM xla_balance_statuses xbs

9625: AND fnd.request_id(+) = xbs.request_id
9626: AND NVL(fnd.status_code,'N') <> 'R'
9627: UNION
9628: SELECT xbs.ROWID
9629: FROM xla_balance_statuses xbs
9630: WHERE xbs.ledger_id IN
9631: (
9632: SELECT xgl.ledger_id
9633: FROM gl_ledgers xgl

Line 9654: || ' xla_balance_statuses updated to S'

9650: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
9651: trace
9652: (p_module => l_log_module
9653: ,p_msg => l_row_count
9654: || ' xla_balance_statuses updated to S'
9655: ,p_level => C_LEVEL_STATEMENT
9656: );
9657: END IF;
9658:

Line 9669: --lock xla_balance_statuses and wait if necessary

9665: END IF;
9666: END LOOP;
9667:
9668: /*
9669: --lock xla_balance_statuses and wait if necessary
9670: EXECUTE IMMEDIATE
9671: '
9672: SELECT xbs.code_combination_id
9673: FROM xla_balance_statuses xbs

Line 9673: FROM xla_balance_statuses xbs

9669: --lock xla_balance_statuses and wait if necessary
9670: EXECUTE IMMEDIATE
9671: '
9672: SELECT xbs.code_combination_id
9673: FROM xla_balance_statuses xbs
9674: WHERE xbs.ledger_id IN
9675: (
9676: SELECT xgl.ledger_id
9677: FROM gl_ledgers xgl

Line 9697: FROM xla_balance_statuses xbs

9693: */
9694:
9695: SELECT COUNT(*)
9696: INTO l_count_unavailable
9697: FROM xla_balance_statuses xbs
9698: WHERE xbs.balance_status_code <> 'S'
9699: AND ( xbs.application_id
9700: ,xbs.ledger_id
9701: ,xbs.code_combination_id

Line 9777: ,p_msg => l_row_count || ' xla_balance_statuses deleted'

9773:
9774: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
9775: trace
9776: (p_module => l_log_module
9777: ,p_msg => l_row_count || ' xla_balance_statuses deleted'
9778: ,p_level => C_LEVEL_STATEMENT
9779: );
9780: END IF;
9781: IF l_row_count < C_BATCH_COMMIT_SIZE

Line 9790: --delete xla_balance_statuses

9786: COMMIT;
9787: END IF;
9788: END LOOP;
9789:
9790: --delete xla_balance_statuses
9791: LOOP
9792: DELETE
9793: FROM xla_balance_statuses xbs
9794: WHERE xbs.code_combination_id IN

Line 9793: FROM xla_balance_statuses xbs

9789:
9790: --delete xla_balance_statuses
9791: LOOP
9792: DELETE
9793: FROM xla_balance_statuses xbs
9794: WHERE xbs.code_combination_id IN
9795: (
9796: SELECT xbt.code_combination_id
9797: FROM xla_bal_synchronize_gt xbt

Line 9808: ,p_msg => l_row_count || ' xla_balance_statuses deleted'

9804:
9805: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
9806: trace
9807: (p_module => l_log_module
9808: ,p_msg => l_row_count || ' xla_balance_statuses deleted'
9809: ,p_level => C_LEVEL_STATEMENT
9810: );
9811: END IF;
9812: IF l_row_count < C_BATCH_COMMIT_SIZE

Line 9823: FROM xla_balance_statuses xbs

9819: END LOOP;
9820:
9821: SELECT COUNT(*)
9822: INTO l_count_unavailable
9823: FROM xla_balance_statuses xbs
9824: WHERE xbs.balance_source_code = 'C'
9825: AND xbs.code_combination_id IN
9826: (
9827: SELECT xbt.code_combination_id

Line 9837: ,p_msg => 'Not all xla_balance_statuses records available'

9833: THEN
9834: IF (C_LEVEL_ERROR >= g_log_level) THEN
9835: trace
9836: (p_module => l_log_module
9837: ,p_msg => 'Not all xla_balance_statuses records available'
9838: ,p_level => C_LEVEL_ERROR
9839: );
9840: trace
9841: (p_module => l_log_module

Line 10014: from xla_balance_statuses

10010:
10011: p_retcode := 0;
10012:
10013: FOR i in (SELECT DISTINCT application_id
10014: from xla_balance_statuses
10015: where ledger_id = p_ledger_id)
10016: LOOP
10017:
10018: fnd_file.put_line(fnd_file.log,'Opening control account balances for application_id '||i.application_id);