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_VARIABLE_INTEREST_PVT dependencies on OKC_P_UTIL

Line 6377: g_vir_tbl(g_vir_tbl_counter).id := okc_p_util.raw_to_number(sys_guid());

6373: print_debug ('l_derived_flag : '|| l_derived_flag);
6374:
6375: IF ((g_request_id > 0) AND (l_derived_flag = 'Y'))THEN
6376: g_vir_tbl_counter := nvl(g_vir_tbl_counter,0) + 1;
6377: g_vir_tbl(g_vir_tbl_counter).id := okc_p_util.raw_to_number(sys_guid());
6378: g_vir_tbl(g_vir_tbl_counter).khr_id := p_contract_id;
6379: IF (G_CALC_METHOD_CODE = 'DAILY_INTEREST') THEN
6380: g_vir_tbl(g_vir_tbl_counter).source_table := 'OKL_STRM_ELEMENTS_B';
6381: ELSIF (G_CALC_METHOD_CODE = 'REAMORT') THEN

Line 8222: g_vpb_tbl(g_vpb_tbl_counter).id := okc_p_util.raw_to_number(sys_guid());

8218: EXIT WHEN l_rebook_csr%NOTFOUND;
8219: g_vpb_tbl_counter := g_vpb_tbl_counter + 1;
8220: g_vpb_tbl(g_vpb_tbl_counter).source_id := l_source_id;
8221: g_vpb_tbl(g_vpb_tbl_counter).source_table := l_source_table;
8222: g_vpb_tbl(g_vpb_tbl_counter).id := okc_p_util.raw_to_number(sys_guid());
8223: g_vpb_tbl(g_vpb_tbl_counter).khr_id := p_khr_id;
8224: g_vpb_tbl(g_vpb_tbl_counter).int_cal_process := 'VARIABLE_INTEREST';
8225: g_vpb_tbl(g_vpb_tbl_counter).OBJECT_VERSION_NUMBER := 1.0;
8226: g_vpb_tbl(g_vpb_tbl_counter).org_id := g_authoring_org_id;

Line 8270: g_vpb_tbl(g_vpb_tbl_counter).id := okc_p_util.raw_to_number(sys_guid());

8266: EXIT WHEN l_daily_int_strm_csr%NOTFOUND;
8267: g_vpb_tbl_counter := g_vpb_tbl_counter + 1;
8268: g_vpb_tbl(g_vpb_tbl_counter).source_id := l_source_id;
8269: g_vpb_tbl(g_vpb_tbl_counter).source_table := l_source_table;
8270: g_vpb_tbl(g_vpb_tbl_counter).id := okc_p_util.raw_to_number(sys_guid());
8271: g_vpb_tbl(g_vpb_tbl_counter).khr_id := p_khr_id;
8272: g_vpb_tbl(g_vpb_tbl_counter).int_cal_process := 'VARIABLE_INTEREST';
8273: g_vpb_tbl(g_vpb_tbl_counter).OBJECT_VERSION_NUMBER := 1.0;
8274: g_vpb_tbl(g_vpb_tbl_counter).org_id := g_authoring_org_id;

Line 8317: g_vpb_tbl(g_vpb_tbl_counter).id := okc_p_util.raw_to_number(sys_guid());

8313: EXIT WHEN l_rcpt_app_csr%NOTFOUND;
8314: g_vpb_tbl_counter := g_vpb_tbl_counter + 1;
8315: g_vpb_tbl(g_vpb_tbl_counter).source_id := l_source_id;
8316: g_vpb_tbl(g_vpb_tbl_counter).source_table := l_source_table;
8317: g_vpb_tbl(g_vpb_tbl_counter).id := okc_p_util.raw_to_number(sys_guid());
8318: g_vpb_tbl(g_vpb_tbl_counter).khr_id := p_khr_id;
8319: g_vpb_tbl(g_vpb_tbl_counter).int_cal_process := 'VARIABLE_INTEREST';
8320: g_vpb_tbl(g_vpb_tbl_counter).OBJECT_VERSION_NUMBER := 1.0;
8321: g_vpb_tbl(g_vpb_tbl_counter).org_id := g_authoring_org_id;

Line 8361: g_vpb_tbl(g_vpb_tbl_counter).id := okc_p_util.raw_to_number(sys_guid());

8357: EXIT WHEN l_partial_term_csr%NOTFOUND;
8358: g_vpb_tbl_counter := g_vpb_tbl_counter + 1;
8359: g_vpb_tbl(g_vpb_tbl_counter).source_id := l_source_id;
8360: g_vpb_tbl(g_vpb_tbl_counter).source_table := l_source_table;
8361: g_vpb_tbl(g_vpb_tbl_counter).id := okc_p_util.raw_to_number(sys_guid());
8362: g_vpb_tbl(g_vpb_tbl_counter).khr_id := p_khr_id;
8363: g_vpb_tbl(g_vpb_tbl_counter).int_cal_process := 'VARIABLE_INTEREST';
8364: g_vpb_tbl(g_vpb_tbl_counter).OBJECT_VERSION_NUMBER := 1.0;
8365: g_vpb_tbl(g_vpb_tbl_counter).org_id := g_authoring_org_id;

Line 8408: g_vpb_tbl(g_vpb_tbl_counter).id := okc_p_util.raw_to_number(sys_guid());

8404: EXIT WHEN l_rcpt_app_csr%NOTFOUND;
8405: g_vpb_tbl_counter := g_vpb_tbl_counter + 1;
8406: g_vpb_tbl(g_vpb_tbl_counter).source_id := l_source_id;
8407: g_vpb_tbl(g_vpb_tbl_counter).source_table := l_source_table;
8408: g_vpb_tbl(g_vpb_tbl_counter).id := okc_p_util.raw_to_number(sys_guid());
8409: g_vpb_tbl(g_vpb_tbl_counter).khr_id := p_khr_id;
8410: g_vpb_tbl(g_vpb_tbl_counter).int_cal_process := 'VARIABLE_INTEREST';
8411: g_vpb_tbl(g_vpb_tbl_counter).OBJECT_VERSION_NUMBER := 1.0;
8412: g_vpb_tbl(g_vpb_tbl_counter).org_id := g_authoring_org_id;

Line 8452: g_vpb_tbl(g_vpb_tbl_counter).id := okc_p_util.raw_to_number(sys_guid());

8448: EXIT WHEN l_partial_term_csr%NOTFOUND;
8449: g_vpb_tbl_counter := g_vpb_tbl_counter + 1;
8450: g_vpb_tbl(g_vpb_tbl_counter).source_id := l_source_id;
8451: g_vpb_tbl(g_vpb_tbl_counter).source_table := l_source_table;
8452: g_vpb_tbl(g_vpb_tbl_counter).id := okc_p_util.raw_to_number(sys_guid());
8453: g_vpb_tbl(g_vpb_tbl_counter).khr_id := p_khr_id;
8454: g_vpb_tbl(g_vpb_tbl_counter).int_cal_process := 'VARIABLE_INTEREST';
8455: g_vpb_tbl(g_vpb_tbl_counter).OBJECT_VERSION_NUMBER := 1.0;
8456: g_vpb_tbl(g_vpb_tbl_counter).org_id := g_authoring_org_id;

Line 8496: g_vpb_tbl(g_vpb_tbl_counter).id := okc_p_util.raw_to_number(sys_guid());

8492: EXIT WHEN l_prin_catch_strm_csr%NOTFOUND;
8493: g_vpb_tbl_counter := g_vpb_tbl_counter + 1;
8494: g_vpb_tbl(g_vpb_tbl_counter).source_id := l_source_id;
8495: g_vpb_tbl(g_vpb_tbl_counter).source_table := l_source_table;
8496: g_vpb_tbl(g_vpb_tbl_counter).id := okc_p_util.raw_to_number(sys_guid());
8497: g_vpb_tbl(g_vpb_tbl_counter).khr_id := p_khr_id;
8498: g_vpb_tbl(g_vpb_tbl_counter).int_cal_process := 'VARIABLE_INTEREST';
8499: g_vpb_tbl(g_vpb_tbl_counter).OBJECT_VERSION_NUMBER := 1.0;
8500: g_vpb_tbl(g_vpb_tbl_counter).org_id := g_authoring_org_id;

Line 8543: g_vpb_tbl(g_vpb_tbl_counter).id := okc_p_util.raw_to_number(sys_guid());

8539: EXIT WHEN l_borrow_payment_csr%NOTFOUND;
8540: g_vpb_tbl_counter := g_vpb_tbl_counter + 1;
8541: g_vpb_tbl(g_vpb_tbl_counter).source_id := l_source_id;
8542: g_vpb_tbl(g_vpb_tbl_counter).source_table := l_source_table;
8543: g_vpb_tbl(g_vpb_tbl_counter).id := okc_p_util.raw_to_number(sys_guid());
8544: g_vpb_tbl(g_vpb_tbl_counter).khr_id := p_khr_id;
8545: g_vpb_tbl(g_vpb_tbl_counter).int_cal_process := 'VARIABLE_INTEREST';
8546: g_vpb_tbl(g_vpb_tbl_counter).OBJECT_VERSION_NUMBER := 1.0;
8547: g_vpb_tbl(g_vpb_tbl_counter).org_id := g_authoring_org_id;

Line 8587: g_vpb_tbl(g_vpb_tbl_counter).id := okc_p_util.raw_to_number(sys_guid());

8583: EXIT WHEN l_daily_int_strm_csr%NOTFOUND;
8584: g_vpb_tbl_counter := g_vpb_tbl_counter + 1;
8585: g_vpb_tbl(g_vpb_tbl_counter).source_id := l_source_id;
8586: g_vpb_tbl(g_vpb_tbl_counter).source_table := l_source_table;
8587: g_vpb_tbl(g_vpb_tbl_counter).id := okc_p_util.raw_to_number(sys_guid());
8588: g_vpb_tbl(g_vpb_tbl_counter).khr_id := p_khr_id;
8589: g_vpb_tbl(g_vpb_tbl_counter).int_cal_process := 'VARIABLE_INTEREST';
8590: g_vpb_tbl(g_vpb_tbl_counter).OBJECT_VERSION_NUMBER := 1.0;
8591: g_vpb_tbl(g_vpb_tbl_counter).org_id := g_authoring_org_id;

Line 8633: g_vpb_tbl(g_vpb_tbl_counter).id := okc_p_util.raw_to_number(sys_guid());

8629: EXIT WHEN l_borrow_payment_csr%NOTFOUND;
8630: g_vpb_tbl_counter := g_vpb_tbl_counter + 1;
8631: g_vpb_tbl(g_vpb_tbl_counter).source_id := l_source_id;
8632: g_vpb_tbl(g_vpb_tbl_counter).source_table := l_source_table;
8633: g_vpb_tbl(g_vpb_tbl_counter).id := okc_p_util.raw_to_number(sys_guid());
8634: g_vpb_tbl(g_vpb_tbl_counter).khr_id := p_khr_id;
8635: g_vpb_tbl(g_vpb_tbl_counter).int_cal_process := 'VARIABLE_INTEREST';
8636: g_vpb_tbl(g_vpb_tbl_counter).OBJECT_VERSION_NUMBER := 1.0;
8637: g_vpb_tbl(g_vpb_tbl_counter).org_id := g_authoring_org_id;

Line 8677: g_vpb_tbl(g_vpb_tbl_counter).id := okc_p_util.raw_to_number(sys_guid());

8673: EXIT WHEN l_rcpt_app_csr%NOTFOUND;
8674: g_vpb_tbl_counter := g_vpb_tbl_counter + 1;
8675: g_vpb_tbl(g_vpb_tbl_counter).source_id := l_source_id;
8676: g_vpb_tbl(g_vpb_tbl_counter).source_table := l_source_table;
8677: g_vpb_tbl(g_vpb_tbl_counter).id := okc_p_util.raw_to_number(sys_guid());
8678: g_vpb_tbl(g_vpb_tbl_counter).khr_id := p_khr_id;
8679: g_vpb_tbl(g_vpb_tbl_counter).int_cal_process := 'VARIABLE_INTEREST';
8680: g_vpb_tbl(g_vpb_tbl_counter).OBJECT_VERSION_NUMBER := 1.0;
8681: g_vpb_tbl(g_vpb_tbl_counter).org_id := g_authoring_org_id;

Line 11116: g_vir_tbl(g_vir_tbl_counter).id := okc_p_util.raw_to_number(sys_guid());

11112: FROM dual;
11113:
11114: g_vir_tbl.delete;
11115: g_vir_tbl_counter := g_vir_tbl_counter + 1;
11116: g_vir_tbl(g_vir_tbl_counter).id := okc_p_util.raw_to_number(sys_guid());
11117: g_vir_tbl(g_vir_tbl_counter).khr_id := p_khr_id;
11118: g_vir_tbl(g_vir_tbl_counter).source_table := 'OKL_VAR_INT_PROCESS_B';
11119: g_vir_tbl(g_vir_tbl_counter).source_id := x_vipv_rec.id;
11120: g_vir_tbl(g_vir_tbl_counter).interest_rate := l_interest_rate_tbl(l_interest_rate_tbl.first).rate;