DBA Data[Home] [Help]

APPS.OKL_REPORT_GENERATOR_PVT dependencies on OKL_STREAMS_SEC_PVT

Line 3351: OKL_STREAMS_SEC_PVT.SET_REPO_STREAMS;

3347: l_trace_time := SYSDATE;
3348:
3349: -- For secondary rep txn, set the security policy for streams. MG Uptake
3350: IF g_representation_type = 'SECONDARY' THEN
3351: OKL_STREAMS_SEC_PVT.SET_REPO_STREAMS;
3352: END IF;
3353: -- Now, calculate the Opening Balance on the p_start_date
3354: FOR t_rec IN strm_bal_csr(
3355: p_date => p_start_date

Line 3392: OKL_STREAMS_SEC_PVT.RESET_REPO_STREAMS;

3388: END LOOP;
3389:
3390: -- For secondary rep txn, reset the security policy for streams. MG Uptake
3391: IF g_representation_type = 'SECONDARY' THEN
3392: OKL_STREAMS_SEC_PVT.RESET_REPO_STREAMS;
3393: END IF;
3394:
3395: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
3396: 'Closing Balance - Time Take' || ( SYSDATE - l_trace_time ) * 86400 || ' Seconds' );

Line 3429: OKL_STREAMS_SEC_PVT.RESET_REPO_STREAMS;

3425: CLOSE strm_bal_csr;
3426: END IF;
3427: -- If any exception was thrown, then reset the reporting streams - MG uptake
3428: IF g_representation_type = 'SECONDARY' THEN
3429: OKL_STREAMS_SEC_PVT.RESET_REPO_STREAMS;
3430: END IF;
3431: x_return_status := okl_api.g_ret_sts_error;
3432: END process_strm_bal_details;
3433:

Line 6470: OKL_STREAMS_SEC_PVT.SET_REPO_STREAMS;

6466: 'Begin: ' || l_api_name ||'(+)' );
6467:
6468: -- For secondary rep txn, set the security policy for streams. MG Uptake
6469: IF g_representation_type = 'SECONDARY' THEN
6470: OKL_STREAMS_SEC_PVT.SET_REPO_STREAMS;
6471: END IF;
6472:
6473: -- Start the stop watch
6474: l_trace_time := SYSDATE;

Line 7054: OKL_STREAMS_SEC_PVT.RESET_REPO_STREAMS;

7050: END LOOP; --End loop of get_contracts_csr
7051:
7052: -- For secondary rep txn, reset the security policy for streams. MG Uptake
7053: IF g_representation_type = 'SECONDARY' THEN
7054: OKL_STREAMS_SEC_PVT.RESET_REPO_STREAMS;
7055: END IF;
7056:
7057: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
7058: ' Inserting records in okl_g_reports_gt table for expected sum of stream elements amount');

Line 7320: OKL_STREAMS_SEC_PVT.RESET_REPO_STREAMS;

7316: CLOSE GET_CONTRACTS_CSR;
7317: END IF;
7318: -- If any exception was thrwon before resetting reporting streams, then do that
7319: IF g_representation_type = 'SECONDARY' THEN
7320: OKL_STREAMS_SEC_PVT.RESET_REPO_STREAMS;
7321: END IF;
7322:
7323: x_return_status := okl_api.g_ret_sts_error;
7324: END POPULATE_STRM_TO_TRX_DATA;