APPS.XLA_BALANCES_PKG dependencies on FND_REQUEST

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

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

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

7847:
7848: END IF;
7849:
7850: --batch execution
7851: l_result := fnd_request.set_mode(TRUE);
7852: l_req_id := fnd_request.submit_request
7853: ( application => 'XLA'
7854: ,program => 'XLABABUP'
7855: ,description => NULL

Line 7852: l_req_id := fnd_request.submit_request

7848: END IF;
7849:
7850: --batch execution
7851: l_result := fnd_request.set_mode(TRUE);
7852: l_req_id := fnd_request.submit_request
7853: ( application => 'XLA'
7854: ,program => 'XLABABUP'
7855: ,description => NULL
7856: ,argument1 => TO_CHAR(p_application_id)

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

8874: AND xbs.balance_source_code = xbt.balance_source_code
8875: AND xbs.effective_period_num >= NVL( l_starting_eff_period_num
8876: ,xbs.effective_period_num
8877: )
8878: AND fnd.request_id(+) = xbs.request_id
8879: AND ( xbs.balance_status_code = 'A'
8880: OR ( xbs.balance_status_code IN ('R', 'B', 'Q', 'C')
8881: AND nvl(fnd.status_code,'N') <> 'R'
8882: )

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

9082: )
9083: AND xbs.effective_period_num >= NVL( l_starting_eff_period_num
9084: ,xbs.effective_period_num
9085: )
9086: AND fnd.request_id(+) = xbs.request_id
9087: AND ( xbs.balance_status_code = 'A'
9088: OR ( xbs.balance_status_code IN ('R', 'B', 'Q', 'C')
9089: AND NVL(fnd.status_code,'N') <> 'R'
9090: )

Line 9359: l_req_id := fnd_request.submit_request

9355: ,p_msg => 'BEGIN ' || l_log_module
9356: ,p_level => C_LEVEL_PROCEDURE);
9357: END IF;
9358:
9359: l_req_id := fnd_request.submit_request
9360: ( application => 'XLA'
9361: ,program => 'XLABAREC'
9362: ,description => 'Balance Recreation'
9363: ,argument1 => p_application_id

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

9621: WHERE xbt.chart_of_accounts_id = p_chart_of_accounts_id
9622: )
9623: AND xbs.balance_source_code = 'C'
9624: AND xbs.balance_status_code IN ('A', 'S')
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

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

10079: ,p_level => C_LEVEL_PROCEDURE);
10080: END IF;
10081:
10082: --batch execution
10083: l_return_value := fnd_request.set_mode(TRUE);
10084: l_req_id := fnd_request.submit_request
10085: ( application => 'XLA'
10086: ,program => 'XLABAOPE'
10087: ,description => 'Balance Period Opening'

Line 10084: l_req_id := fnd_request.submit_request

10080: END IF;
10081:
10082: --batch execution
10083: l_return_value := fnd_request.set_mode(TRUE);
10084: l_req_id := fnd_request.submit_request
10085: ( application => 'XLA'
10086: ,program => 'XLABAOPE'
10087: ,description => 'Balance Period Opening'
10088: ,argument1 => p_ledger_id

Line 10732: l_request_id := fnd_request.submit_request

10728: ,p_level => C_LEVEL_STATEMENT
10729: ,p_module => l_log_module);
10730: END IF;
10731:
10732: l_request_id := fnd_request.submit_request
10733: ( application => 'XLA'
10734: ,program => 'XLABAOPE'
10735: ,description => 'Open Period Balances'
10736: ,argument1 => l_ledger_id