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.OKL_GENERATE_ACCRUALS_PVT dependencies on OKL_SYS_ACCT_OPTS

Line 16: G_SOB_ID_REP OKL_SYS_ACCT_OPTS.set_of_books_id%TYPE;

12: G_TRY_ID OKL_TRX_TYPES_V.id%TYPE;
13: G_PERIOD_NAME_REP VARCHAR2(2000);
14: G_PERIOD_START_DATE_REP DATE;
15: G_PERIOD_END_DATE_REP DATE;
16: G_SOB_ID_REP OKL_SYS_ACCT_OPTS.set_of_books_id%TYPE;
17: G_SOB_NAME_REP VARCHAR2(2000);
18: G_ORG_ID NUMBER;
19: G_ORG_NAME VARCHAR2(2000);
20: G_ACCRUAL_REVERSAL_DAYS OKL_SYS_ACCT_OPTS.accrual_reversal_days%TYPE;

Line 20: G_ACCRUAL_REVERSAL_DAYS OKL_SYS_ACCT_OPTS.accrual_reversal_days%TYPE;

16: G_SOB_ID_REP OKL_SYS_ACCT_OPTS.set_of_books_id%TYPE;
17: G_SOB_NAME_REP VARCHAR2(2000);
18: G_ORG_ID NUMBER;
19: G_ORG_NAME VARCHAR2(2000);
20: G_ACCRUAL_REVERSAL_DAYS OKL_SYS_ACCT_OPTS.accrual_reversal_days%TYPE;
21: G_FUNC_CURRENCY_CODE_REP OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
22: G_ACCRUAL_DATE DATE;
23:
24: TYPE trx_rec_type IS RECORD (

Line 39: FROM OKL_SYS_ACCT_OPTS;

35:
36: -- Cursor to select the number of days for a reverse transaction
37: CURSOR sty_select_basis_csr IS
38: SELECT validate_khr_start_date
39: FROM OKL_SYS_ACCT_OPTS;
40:
41: --Added by dpsingh for SLA Uptake (Bug 5707866)
42: -- Cursor to select accrual reversal date for an accrual transaction
43: CURSOR get_accrual_reversal_date(p_ledger_id NUMBER,p_accrual_date Date) IS

Line 410: from okl_sys_acct_opts;

406:
407: -- bug 7577628
408: cursor get_sec_rep_method IS
409: select secondary_rep_method
410: from okl_sys_acct_opts;
411:
412: l_sec_rep_method okl_sys_acct_opts.secondary_rep_method%TYPE := null;
413:
414: --Bug 4740605.Added TRUNC

Line 412: l_sec_rep_method okl_sys_acct_opts.secondary_rep_method%TYPE := null;

408: cursor get_sec_rep_method IS
409: select secondary_rep_method
410: from okl_sys_acct_opts;
411:
412: l_sec_rep_method okl_sys_acct_opts.secondary_rep_method%TYPE := null;
413:
414: --Bug 4740605.Added TRUNC
415: CURSOR check_streams_accrual_csr(p_chr_id NUMBER, p_accrue_till_date DATE,
416: p_reporting_pdt_id NUMBER) IS -- MGAAP

Line 1274: x_sob_id OUT NOCOPY OKL_SYS_ACCT_OPTS.set_of_books_id%TYPE,

1270: x_try_id OUT NOCOPY OKL_TRX_TYPES_V.id%TYPE,
1271: x_period_name OUT NOCOPY VARCHAR2,
1272: x_period_start_date OUT NOCOPY DATE,
1273: x_period_end_date OUT NOCOPY DATE,
1274: x_sob_id OUT NOCOPY OKL_SYS_ACCT_OPTS.set_of_books_id%TYPE,
1275: x_sob_name OUT NOCOPY VARCHAR2,
1276: x_org_id OUT NOCOPY OKL_SYS_ACCT_OPTS.org_id%TYPE,
1277: x_org_name OUT NOCOPY VARCHAR2,
1278: x_accrual_reversal_days OUT NOCOPY NUMBER,

Line 1276: x_org_id OUT NOCOPY OKL_SYS_ACCT_OPTS.org_id%TYPE,

1272: x_period_start_date OUT NOCOPY DATE,
1273: x_period_end_date OUT NOCOPY DATE,
1274: x_sob_id OUT NOCOPY OKL_SYS_ACCT_OPTS.set_of_books_id%TYPE,
1275: x_sob_name OUT NOCOPY VARCHAR2,
1276: x_org_id OUT NOCOPY OKL_SYS_ACCT_OPTS.org_id%TYPE,
1277: x_org_name OUT NOCOPY VARCHAR2,
1278: x_accrual_reversal_days OUT NOCOPY NUMBER,
1279: x_func_currency_code OUT NOCOPY OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE,
1280: x_return_status OUT NOCOPY VARCHAR2

Line 1287: l_sob_id OKL_SYS_ACCT_OPTS.set_of_books_id%TYPE;

1283: l_period_name VARCHAR2(2000);
1284: l_period_start_date DATE;
1285: l_period_end_date DATE;
1286: l_period_status VARCHAR2(2000);
1287: l_sob_id OKL_SYS_ACCT_OPTS.set_of_books_id%TYPE;
1288: l_sob_name VARCHAR2(2000);
1289: l_try_id OKL_TRX_TYPES_V.id%TYPE;
1290: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
1291: l_org_id OKL_SYS_ACCT_OPTS.org_id%TYPE;

Line 1291: l_org_id OKL_SYS_ACCT_OPTS.org_id%TYPE;

1287: l_sob_id OKL_SYS_ACCT_OPTS.set_of_books_id%TYPE;
1288: l_sob_name VARCHAR2(2000);
1289: l_try_id OKL_TRX_TYPES_V.id%TYPE;
1290: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
1291: l_org_id OKL_SYS_ACCT_OPTS.org_id%TYPE;
1292: l_org_name VARCHAR2(2000);
1293: l_accrual_reversal_days NUMBER;
1294:
1295: -- Cursor to select the transaction type id for the accrual transaction

Line 1305: FROM OKL_SYS_ACCT_OPTS;

1301:
1302: -- Cursor to select the number of days for a reverse transaction
1303: CURSOR accrual_reversal_days_csr IS
1304: SELECT accrual_reversal_days
1305: FROM OKL_SYS_ACCT_OPTS;
1306:
1307: -- cursor to get org name
1308: CURSOR org_name_csr(p_org_id NUMBER) IS
1309: SELECT name

Line 2356: l_org_id OKL_SYS_ACCT_OPTS.org_id%TYPE;

2352: l_counter1 NUMBER := 1;
2353: l_counter2 NUMBER := 1;
2354: l_rule_result VARCHAR2(1);
2355: l_sob_name VARCHAR2(2000);
2356: l_org_id OKL_SYS_ACCT_OPTS.org_id%TYPE;
2357: l_org_name VARCHAR2(2000);
2358: l_accrual_reversal_days NUMBER;
2359:
2360:

Line 6101: l_sob_id OKL_SYS_ACCT_OPTS.set_of_books_id%TYPE;

6097: l_khr_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
6098: l_currency_conv_type OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_TYPE%TYPE;
6099: l_currency_conv_rate OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_RATE%TYPE;
6100: l_currency_conv_date OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_DATE%TYPE;
6101: l_sob_id OKL_SYS_ACCT_OPTS.set_of_books_id%TYPE;
6102: --Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED
6103: l_tsu_code_ent OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'PROCESSED';
6104: l_tcn_type OKL_TRX_CONTRACTS.TCN_TYPE%TYPE := 'ACL';
6105: l_batch_name OKL_TRX_CONTRACTS.DESCRIPTION%TYPE := p_process_accrual_rec.batch_name;

Line 6292: from okl_sys_acct_opts;

6288:
6289: -- bug 7577628
6290: cursor get_sec_rep_method is
6291: select secondary_rep_method
6292: from okl_sys_acct_opts;
6293:
6294: l_sec_rep_method okl_sys_acct_opts.secondary_rep_method%TYPE := null;
6295:
6296: --Bug# 13815781

Line 6294: l_sec_rep_method okl_sys_acct_opts.secondary_rep_method%TYPE := null;

6290: cursor get_sec_rep_method is
6291: select secondary_rep_method
6292: from okl_sys_acct_opts;
6293:
6294: l_sec_rep_method okl_sys_acct_opts.secondary_rep_method%TYPE := null;
6295:
6296: --Bug# 13815781
6297: CURSOR last_accrual_date_csr(p_contract_id NUMBER) IS
6298: SELECT MAX(sel.stream_element_date)

Line 9964: l_accrual_reversal_days OKL_SYS_ACCT_OPTS.accrual_reversal_days%TYPE;

9960: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;
9961: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;
9962: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;
9963: l_try_id OKL_TRX_TYPES_V.id%TYPE;
9964: l_accrual_reversal_days OKL_SYS_ACCT_OPTS.accrual_reversal_days%TYPE;
9965: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
9966: l_khr_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
9967: l_currency_conv_type OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_TYPE%TYPE;
9968: l_currency_conv_rate OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_RATE%TYPE;

Line 9970: l_sob_id OKL_SYS_ACCT_OPTS.set_of_books_id%TYPE;

9966: l_khr_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
9967: l_currency_conv_type OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_TYPE%TYPE;
9968: l_currency_conv_rate OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_RATE%TYPE;
9969: l_currency_conv_date OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_DATE%TYPE;
9970: l_sob_id OKL_SYS_ACCT_OPTS.set_of_books_id%TYPE;
9971: l_reverse_date_to DATE;
9972: l_sob_name VARCHAR2(2000);
9973: l_api_version CONSTANT NUMBER := 1.0;
9974: p_api_version CONSTANT NUMBER := 1.0;

Line 10631: l_accrual_reversal_days OKL_SYS_ACCT_OPTS.accrual_reversal_days%TYPE;

10627: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;
10628: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;
10629: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;
10630: l_try_id OKL_TRX_TYPES_V.id%TYPE;
10631: l_accrual_reversal_days OKL_SYS_ACCT_OPTS.accrual_reversal_days%TYPE;
10632: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
10633: l_khr_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
10634: l_currency_conv_type OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_TYPE%TYPE;
10635: l_currency_conv_rate OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_RATE%TYPE;

Line 10637: l_sob_id OKL_SYS_ACCT_OPTS.set_of_books_id%TYPE;

10633: l_khr_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
10634: l_currency_conv_type OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_TYPE%TYPE;
10635: l_currency_conv_rate OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_RATE%TYPE;
10636: l_currency_conv_date OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_DATE%TYPE;
10637: l_sob_id OKL_SYS_ACCT_OPTS.set_of_books_id%TYPE;
10638: l_try_name OKL_TRX_TYPES_V.NAME%TYPE := 'Accrual';
10639: --Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED
10640: l_tsu_code_ent OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'PROCESSED';
10641: l_tcn_type OKL_TRX_CONTRACTS.TCN_TYPE%TYPE := 'ACL';

Line 11023: l_accrual_reversal_days OKL_SYS_ACCT_OPTS.accrual_reversal_days%TYPE;

11019: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;
11020: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;
11021: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;
11022: l_try_id OKL_TRX_TYPES_V.id%TYPE;
11023: l_accrual_reversal_days OKL_SYS_ACCT_OPTS.accrual_reversal_days%TYPE;
11024: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
11025: l_khr_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
11026: l_currency_conv_type OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_TYPE%TYPE;
11027: l_currency_conv_rate OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_RATE%TYPE;

Line 11029: l_sob_id OKL_SYS_ACCT_OPTS.set_of_books_id%TYPE;

11025: l_khr_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
11026: l_currency_conv_type OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_TYPE%TYPE;
11027: l_currency_conv_rate OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_RATE%TYPE;
11028: l_currency_conv_date OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_DATE%TYPE;
11029: l_sob_id OKL_SYS_ACCT_OPTS.set_of_books_id%TYPE;
11030: l_source_trx_type OKL_TRX_CONTRACTS.SOURCE_TRX_TYPE%TYPE;
11031: l_source_trx_id OKL_TRX_CONTRACTS.SOURCE_TRX_ID%TYPE;
11032: l_try_name OKL_TRX_TYPES_V.NAME%TYPE := 'Accrual';
11033: l_reverse_date_to DATE;