APPS.XLA_BALANCES_PKG dependencies on FND_REQUEST

Line 589: AND fnd.request_id(+) = xbs.request_id

585: AND xbs.effective_period_num = p_source_effective_period_num
586: AND xbs.balance_status_code IN ( p_balance_status_code_not_sel
587: ,p_balance_status_code_selected
588: )
589: AND fnd.request_id(+) = xbs.request_id
590: --pick up records being handled by this request
591: --or by any another request which is not running
592: AND ( NVL(xbs.request_id, -1) = NVL(l_req_id, -1)
593: OR NVL(fnd.status_code,'N') <> 'R'

Line 7748: l_result := fnd_request.set_mode(TRUE);

7744:
7745: END IF;
7746:
7747: --batch execution
7748: l_result := fnd_request.set_mode(TRUE);
7749: l_req_id := fnd_request.submit_request
7750: ( application => 'XLA'
7751: ,program => 'XLABABUP'
7752: ,description => NULL

Line 7749: l_req_id := fnd_request.submit_request

7745: END IF;
7746:
7747: --batch execution
7748: l_result := fnd_request.set_mode(TRUE);
7749: l_req_id := fnd_request.submit_request
7750: ( application => 'XLA'
7751: ,program => 'XLABABUP'
7752: ,description => NULL
7753: ,argument1 => TO_CHAR(p_application_id)

Line 8699: AND fnd.request_id(+) = xbs.request_id

8695: AND xbs.balance_source_code = xbt.balance_source_code
8696: AND xbs.effective_period_num >= NVL( l_starting_eff_period_num
8697: ,xbs.effective_period_num
8698: )
8699: AND fnd.request_id(+) = xbs.request_id
8700: AND ( xbs.balance_status_code = 'A'
8701: OR ( xbs.balance_status_code IN ('R', 'B', 'Q', 'C')
8702: AND nvl(fnd.status_code,'N') <> 'R'
8703: )

Line 8907: AND fnd.request_id(+) = xbs.request_id

8903: )
8904: AND xbs.effective_period_num >= NVL( l_starting_eff_period_num
8905: ,xbs.effective_period_num
8906: )
8907: AND fnd.request_id(+) = xbs.request_id
8908: AND ( xbs.balance_status_code = 'A'
8909: OR ( xbs.balance_status_code IN ('R', 'B', 'Q', 'C')
8910: AND NVL(fnd.status_code,'N') <> 'R'
8911: )

Line 9180: l_req_id := fnd_request.submit_request

9176: ,p_msg => 'BEGIN ' || l_log_module
9177: ,p_level => C_LEVEL_PROCEDURE);
9178: END IF;
9179:
9180: l_req_id := fnd_request.submit_request
9181: ( application => 'XLA'
9182: ,program => 'XLABAREC'
9183: ,description => 'Balance Recreation'
9184: ,argument1 => p_application_id

Line 9443: AND fnd.request_id(+) = xbs.request_id

9439: WHERE xbt.chart_of_accounts_id = p_chart_of_accounts_id
9440: )
9441: AND xbs.balance_source_code = 'C'
9442: AND xbs.balance_status_code IN ('A', 'S')
9443: AND fnd.request_id(+) = xbs.request_id
9444: AND NVL(fnd.status_code,'N') <> 'R'
9445: UNION
9446: SELECT xbs.ROWID
9447: FROM xla_balance_statuses xbs

Line 9894: l_return_value := fnd_request.set_mode(TRUE);

9890: ,p_level => C_LEVEL_PROCEDURE);
9891: END IF;
9892:
9893: --batch execution
9894: l_return_value := fnd_request.set_mode(TRUE);
9895: l_req_id := fnd_request.submit_request
9896: ( application => 'XLA'
9897: ,program => 'XLABAOPE'
9898: ,description => 'Balance Period Opening'

Line 9895: l_req_id := fnd_request.submit_request

9891: END IF;
9892:
9893: --batch execution
9894: l_return_value := fnd_request.set_mode(TRUE);
9895: l_req_id := fnd_request.submit_request
9896: ( application => 'XLA'
9897: ,program => 'XLABAOPE'
9898: ,description => 'Balance Period Opening'
9899: ,argument1 => p_ledger_id

Line 10543: l_request_id := fnd_request.submit_request

10539: ,p_level => C_LEVEL_STATEMENT
10540: ,p_module => l_log_module);
10541: END IF;
10542:
10543: l_request_id := fnd_request.submit_request
10544: ( application => 'XLA'
10545: ,program => 'XLABAOPE'
10546: ,description => 'Open Period Balances'
10547: ,argument1 => l_ledger_id