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_TRX_TYPES_V

Line 12: G_TRY_ID OKL_TRX_TYPES_V.id%TYPE;

8: l_sty_select_basis VARCHAR2(2000);
9: -- Bug 4884618
10:
11: -- MGAAP start 7263041
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;

Line 65: try_id OKL_TRX_TYPES_V.ID%TYPE,

61: currency_conv_type OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_TYPE%TYPE,
62: currency_conv_date OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_DATE%TYPE,
63: currency_conv_rate OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_RATE%TYPE,
64: func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE,
65: try_id OKL_TRX_TYPES_V.ID%TYPE,
66: reverse_date_to DATE,
67: batch_name VARCHAR2(2000),
68: sob_id OKL_TRX_CONTRACTS.SET_OF_BOOKS_ID%TYPE,
69: accrual_date DATE,

Line 460: OKL_TRX_TYPES_V try,

456: --Bug 5036337
457: CURSOR check_actual_trx(p_khr_id NUMBER) IS
458: SELECT TRUNC(MAX(trx.date_transaction_occurred)) last_accrual_date
459: FROM OKL_TRX_CONTRACTS trx,
460: OKL_TRX_TYPES_V try,
461: OKL_TXL_CNTRCT_LNS txl,
462: OKL_STRM_TYPE_V sty
463: WHERE trx.khr_id = p_khr_id
464: AND trx.try_id = try.id

Line 1270: x_try_id OUT NOCOPY OKL_TRX_TYPES_V.id%TYPE,

1266: END GET_ACCOUNT_GEN_DETAILS;
1267:
1268: PROCEDURE GET_COMMON_INFO (p_accrual_date IN DATE,
1269: p_representation_type IN VARCHAR2 DEFAULT 'PRIMARY',
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,

Line 1289: l_try_id OKL_TRX_TYPES_V.id%TYPE;

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;
1292: l_org_name VARCHAR2(2000);
1293: l_accrual_reversal_days NUMBER;

Line 3956: FROM OKL_TRX_CONTRACTS trx, okl_trx_types_v typ

3952:
3953: -- Cursor to select accrual transactions for cancellation using specified tcn_type
3954: CURSOR reverse_trx_csr IS
3955: SELECT trx.id,trx.transaction_date
3956: FROM OKL_TRX_CONTRACTS trx, okl_trx_types_v typ
3957: WHERE trx.khr_id = p_khr_id
3958: AND trx.tsu_code = l_tsu_code_ent
3959: AND trx.tcn_type = NVL(p_tcn_type,trx.tcn_type)
3960: AND trx.try_id = typ.id

Line 6095: l_try_id OKL_TRX_TYPES_V.id%TYPE;

6091: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;
6092: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;
6093: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;
6094: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;
6095: l_try_id OKL_TRX_TYPES_V.id%TYPE;
6096: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%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;

Line 6234: FROM OKL_TRX_CONTRACTS trx, OKL_TRX_TYPES_V try, OKL_TXL_CNTRCT_LNS txl, OKL_STRM_TYPE_V sty

6230: -- cursor to check for accrual trx for a given period for variable rate contracts
6231: -- 12/5/05. Bug 4862620. Check for trx with variable interest income only
6232: CURSOR check_variable_trx(p_khr_id NUMBER, p_date DATE) IS
6233: SELECT 'Y'
6234: FROM OKL_TRX_CONTRACTS trx, OKL_TRX_TYPES_V try, OKL_TXL_CNTRCT_LNS txl, OKL_STRM_TYPE_V sty
6235: WHERE trx.khr_id = p_khr_id
6236: AND trx.try_id = try.id
6237: AND try.name = 'Accrual'
6238: --Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED

Line 6253: OKL_TRX_TYPES_V try,

6249: -- SELECT 'Y'
6250: CURSOR check_actual_trx(p_khr_id NUMBER) IS
6251: SELECT TRUNC(MAX(trx.date_transaction_occurred)) last_accrual_date
6252: FROM OKL_TRX_CONTRACTS trx,
6253: OKL_TRX_TYPES_V try,
6254: OKL_TXL_CNTRCT_LNS txl,
6255: OKL_STRM_TYPE_V sty
6256: WHERE trx.khr_id = p_khr_id
6257: AND trx.try_id = try.id

Line 9963: l_try_id OKL_TRX_TYPES_V.id%TYPE;

9959: l_start_date OKL_K_HEADERS_FULL_V.start_date%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;

Line 10630: l_try_id OKL_TRX_TYPES_V.id%TYPE;

10626: l_start_date OKL_K_HEADERS_FULL_V.start_date%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;

Line 10638: l_try_name OKL_TRX_TYPES_V.NAME%TYPE := 'Accrual';

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';
10642: l_reverse_date_to DATE;

Line 11022: l_try_id OKL_TRX_TYPES_V.id%TYPE;

11018: l_start_date OKL_K_HEADERS_FULL_V.start_date%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;

Line 11032: l_try_name OKL_TRX_TYPES_V.NAME%TYPE := 'Accrual';

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;
11034: l_sob_name VARCHAR2(2000);
11035: l_api_version CONSTANT NUMBER := 1.0;
11036: l_api_name CONSTANT VARCHAR2(30) := 'GENERATE_ACCRUALS';