DBA Data[Home] [Help]

APPS.OKL_VARIABLE_INTEREST_PVT dependencies on OKC_P_UTIL

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

4093: print_debug ('l_derived_flag : '|| l_derived_flag);
4094:
4095: IF ((g_request_id > 0) AND (l_derived_flag = 'Y'))THEN
4096: g_vir_tbl_counter := nvl(g_vir_tbl_counter,0) + 1;
4097: g_vir_tbl(g_vir_tbl_counter).id := okc_p_util.raw_to_number(sys_guid());
4098: g_vir_tbl(g_vir_tbl_counter).khr_id := p_contract_id;
4099: g_vir_tbl(g_vir_tbl_counter).kle_id := G_CONTRACT_LINE_ID;
4100: IF (G_CALC_METHOD_CODE = 'DAILY_INTEREST') THEN
4101: g_vir_tbl(g_vir_tbl_counter).source_table := 'OKL_STRM_ELEMENTS_B';

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

5113: EXIT WHEN l_rebook_csr%NOTFOUND;
5114: g_vpb_tbl_counter := g_vpb_tbl_counter + 1;
5115: g_vpb_tbl(g_vpb_tbl_counter).source_id := l_source_id;
5116: g_vpb_tbl(g_vpb_tbl_counter).source_table := l_source_table;
5117: g_vpb_tbl(g_vpb_tbl_counter).id := okc_p_util.raw_to_number(sys_guid());
5118: g_vpb_tbl(g_vpb_tbl_counter).khr_id := p_khr_id;
5119: g_vpb_tbl(g_vpb_tbl_counter).int_cal_process := 'VARIABLE_INTEREST';
5120: g_vpb_tbl(g_vpb_tbl_counter).OBJECT_VERSION_NUMBER := 1.0;
5121: g_vpb_tbl(g_vpb_tbl_counter).org_id := g_authoring_org_id;

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

5161: EXIT WHEN l_daily_int_strm_csr%NOTFOUND;
5162: g_vpb_tbl_counter := g_vpb_tbl_counter + 1;
5163: g_vpb_tbl(g_vpb_tbl_counter).source_id := l_source_id;
5164: g_vpb_tbl(g_vpb_tbl_counter).source_table := l_source_table;
5165: g_vpb_tbl(g_vpb_tbl_counter).id := okc_p_util.raw_to_number(sys_guid());
5166: g_vpb_tbl(g_vpb_tbl_counter).khr_id := p_khr_id;
5167: g_vpb_tbl(g_vpb_tbl_counter).int_cal_process := 'VARIABLE_INTEREST';
5168: g_vpb_tbl(g_vpb_tbl_counter).OBJECT_VERSION_NUMBER := 1.0;
5169: g_vpb_tbl(g_vpb_tbl_counter).org_id := g_authoring_org_id;

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

5208: EXIT WHEN l_rcpt_app_csr%NOTFOUND;
5209: g_vpb_tbl_counter := g_vpb_tbl_counter + 1;
5210: g_vpb_tbl(g_vpb_tbl_counter).source_id := l_source_id;
5211: g_vpb_tbl(g_vpb_tbl_counter).source_table := l_source_table;
5212: g_vpb_tbl(g_vpb_tbl_counter).id := okc_p_util.raw_to_number(sys_guid());
5213: g_vpb_tbl(g_vpb_tbl_counter).khr_id := p_khr_id;
5214: g_vpb_tbl(g_vpb_tbl_counter).int_cal_process := 'VARIABLE_INTEREST';
5215: g_vpb_tbl(g_vpb_tbl_counter).OBJECT_VERSION_NUMBER := 1.0;
5216: g_vpb_tbl(g_vpb_tbl_counter).org_id := g_authoring_org_id;

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

5252: EXIT WHEN l_partial_term_csr%NOTFOUND;
5253: g_vpb_tbl_counter := g_vpb_tbl_counter + 1;
5254: g_vpb_tbl(g_vpb_tbl_counter).source_id := l_source_id;
5255: g_vpb_tbl(g_vpb_tbl_counter).source_table := l_source_table;
5256: g_vpb_tbl(g_vpb_tbl_counter).id := okc_p_util.raw_to_number(sys_guid());
5257: g_vpb_tbl(g_vpb_tbl_counter).khr_id := p_khr_id;
5258: g_vpb_tbl(g_vpb_tbl_counter).int_cal_process := 'VARIABLE_INTEREST';
5259: g_vpb_tbl(g_vpb_tbl_counter).OBJECT_VERSION_NUMBER := 1.0;
5260: g_vpb_tbl(g_vpb_tbl_counter).org_id := g_authoring_org_id;

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

5297: EXIT WHEN l_credit_memo_csr%NOTFOUND;
5298: g_vpb_tbl_counter := g_vpb_tbl_counter + 1;
5299: g_vpb_tbl(g_vpb_tbl_counter).source_id := l_source_id;
5300: g_vpb_tbl(g_vpb_tbl_counter).source_table := l_source_table;
5301: g_vpb_tbl(g_vpb_tbl_counter).id := okc_p_util.raw_to_number(sys_guid());
5302: g_vpb_tbl(g_vpb_tbl_counter).khr_id := p_khr_id;
5303: g_vpb_tbl(g_vpb_tbl_counter).int_cal_process := 'VARIABLE_INTEREST';
5304: g_vpb_tbl(g_vpb_tbl_counter).OBJECT_VERSION_NUMBER := 1.0;
5305: g_vpb_tbl(g_vpb_tbl_counter).org_id := g_authoring_org_id;

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

5341: EXIT WHEN l_adjustment_csr%NOTFOUND;
5342: g_vpb_tbl_counter := g_vpb_tbl_counter + 1;
5343: g_vpb_tbl(g_vpb_tbl_counter).source_id := l_source_id;
5344: g_vpb_tbl(g_vpb_tbl_counter).source_table := l_source_table;
5345: g_vpb_tbl(g_vpb_tbl_counter).id := okc_p_util.raw_to_number(sys_guid());
5346: g_vpb_tbl(g_vpb_tbl_counter).khr_id := p_khr_id;
5347: g_vpb_tbl(g_vpb_tbl_counter).int_cal_process := 'VARIABLE_INTEREST';
5348: g_vpb_tbl(g_vpb_tbl_counter).OBJECT_VERSION_NUMBER := 1.0;
5349: g_vpb_tbl(g_vpb_tbl_counter).org_id := g_authoring_org_id;

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

5390: EXIT WHEN l_rcpt_app_csr%NOTFOUND;
5391: g_vpb_tbl_counter := g_vpb_tbl_counter + 1;
5392: g_vpb_tbl(g_vpb_tbl_counter).source_id := l_source_id;
5393: g_vpb_tbl(g_vpb_tbl_counter).source_table := l_source_table;
5394: g_vpb_tbl(g_vpb_tbl_counter).id := okc_p_util.raw_to_number(sys_guid());
5395: g_vpb_tbl(g_vpb_tbl_counter).khr_id := p_khr_id;
5396: g_vpb_tbl(g_vpb_tbl_counter).int_cal_process := 'VARIABLE_INTEREST';
5397: g_vpb_tbl(g_vpb_tbl_counter).OBJECT_VERSION_NUMBER := 1.0;
5398: g_vpb_tbl(g_vpb_tbl_counter).org_id := g_authoring_org_id;

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

5434: EXIT WHEN l_partial_term_csr%NOTFOUND;
5435: g_vpb_tbl_counter := g_vpb_tbl_counter + 1;
5436: g_vpb_tbl(g_vpb_tbl_counter).source_id := l_source_id;
5437: g_vpb_tbl(g_vpb_tbl_counter).source_table := l_source_table;
5438: g_vpb_tbl(g_vpb_tbl_counter).id := okc_p_util.raw_to_number(sys_guid());
5439: g_vpb_tbl(g_vpb_tbl_counter).khr_id := p_khr_id;
5440: g_vpb_tbl(g_vpb_tbl_counter).int_cal_process := 'VARIABLE_INTEREST';
5441: g_vpb_tbl(g_vpb_tbl_counter).OBJECT_VERSION_NUMBER := 1.0;
5442: g_vpb_tbl(g_vpb_tbl_counter).org_id := g_authoring_org_id;

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

5478: EXIT WHEN l_prin_catch_strm_csr%NOTFOUND;
5479: g_vpb_tbl_counter := g_vpb_tbl_counter + 1;
5480: g_vpb_tbl(g_vpb_tbl_counter).source_id := l_source_id;
5481: g_vpb_tbl(g_vpb_tbl_counter).source_table := l_source_table;
5482: g_vpb_tbl(g_vpb_tbl_counter).id := okc_p_util.raw_to_number(sys_guid());
5483: g_vpb_tbl(g_vpb_tbl_counter).khr_id := p_khr_id;
5484: g_vpb_tbl(g_vpb_tbl_counter).int_cal_process := 'VARIABLE_INTEREST';
5485: g_vpb_tbl(g_vpb_tbl_counter).OBJECT_VERSION_NUMBER := 1.0;
5486: g_vpb_tbl(g_vpb_tbl_counter).org_id := g_authoring_org_id;

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

5523: EXIT WHEN l_credit_memo_csr%NOTFOUND;
5524: g_vpb_tbl_counter := g_vpb_tbl_counter + 1;
5525: g_vpb_tbl(g_vpb_tbl_counter).source_id := l_source_id;
5526: g_vpb_tbl(g_vpb_tbl_counter).source_table := l_source_table;
5527: g_vpb_tbl(g_vpb_tbl_counter).id := okc_p_util.raw_to_number(sys_guid());
5528: g_vpb_tbl(g_vpb_tbl_counter).khr_id := p_khr_id;
5529: g_vpb_tbl(g_vpb_tbl_counter).int_cal_process := 'VARIABLE_INTEREST';
5530: g_vpb_tbl(g_vpb_tbl_counter).OBJECT_VERSION_NUMBER := 1.0;
5531: g_vpb_tbl(g_vpb_tbl_counter).org_id := g_authoring_org_id;

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

5567: EXIT WHEN l_adjustment_csr%NOTFOUND;
5568: g_vpb_tbl_counter := g_vpb_tbl_counter + 1;
5569: g_vpb_tbl(g_vpb_tbl_counter).source_id := l_source_id;
5570: g_vpb_tbl(g_vpb_tbl_counter).source_table := l_source_table;
5571: g_vpb_tbl(g_vpb_tbl_counter).id := okc_p_util.raw_to_number(sys_guid());
5572: g_vpb_tbl(g_vpb_tbl_counter).khr_id := p_khr_id;
5573: g_vpb_tbl(g_vpb_tbl_counter).int_cal_process := 'VARIABLE_INTEREST';
5574: g_vpb_tbl(g_vpb_tbl_counter).OBJECT_VERSION_NUMBER := 1.0;
5575: g_vpb_tbl(g_vpb_tbl_counter).org_id := g_authoring_org_id;

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

5615: EXIT WHEN l_borrow_payment_csr%NOTFOUND;
5616: g_vpb_tbl_counter := g_vpb_tbl_counter + 1;
5617: g_vpb_tbl(g_vpb_tbl_counter).source_id := l_source_id;
5618: g_vpb_tbl(g_vpb_tbl_counter).source_table := l_source_table;
5619: g_vpb_tbl(g_vpb_tbl_counter).id := okc_p_util.raw_to_number(sys_guid());
5620: g_vpb_tbl(g_vpb_tbl_counter).khr_id := p_khr_id;
5621: g_vpb_tbl(g_vpb_tbl_counter).int_cal_process := 'VARIABLE_INTEREST';
5622: g_vpb_tbl(g_vpb_tbl_counter).OBJECT_VERSION_NUMBER := 1.0;
5623: g_vpb_tbl(g_vpb_tbl_counter).org_id := g_authoring_org_id;

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

5659: EXIT WHEN l_daily_int_strm_csr%NOTFOUND;
5660: g_vpb_tbl_counter := g_vpb_tbl_counter + 1;
5661: g_vpb_tbl(g_vpb_tbl_counter).source_id := l_source_id;
5662: g_vpb_tbl(g_vpb_tbl_counter).source_table := l_source_table;
5663: g_vpb_tbl(g_vpb_tbl_counter).id := okc_p_util.raw_to_number(sys_guid());
5664: g_vpb_tbl(g_vpb_tbl_counter).khr_id := p_khr_id;
5665: g_vpb_tbl(g_vpb_tbl_counter).int_cal_process := 'VARIABLE_INTEREST';
5666: g_vpb_tbl(g_vpb_tbl_counter).OBJECT_VERSION_NUMBER := 1.0;
5667: g_vpb_tbl(g_vpb_tbl_counter).org_id := g_authoring_org_id;

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

5705: EXIT WHEN l_borrow_payment_csr%NOTFOUND;
5706: g_vpb_tbl_counter := g_vpb_tbl_counter + 1;
5707: g_vpb_tbl(g_vpb_tbl_counter).source_id := l_source_id;
5708: g_vpb_tbl(g_vpb_tbl_counter).source_table := l_source_table;
5709: g_vpb_tbl(g_vpb_tbl_counter).id := okc_p_util.raw_to_number(sys_guid());
5710: g_vpb_tbl(g_vpb_tbl_counter).khr_id := p_khr_id;
5711: g_vpb_tbl(g_vpb_tbl_counter).int_cal_process := 'VARIABLE_INTEREST';
5712: g_vpb_tbl(g_vpb_tbl_counter).OBJECT_VERSION_NUMBER := 1.0;
5713: g_vpb_tbl(g_vpb_tbl_counter).org_id := g_authoring_org_id;

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

5749: EXIT WHEN l_rcpt_app_csr%NOTFOUND;
5750: g_vpb_tbl_counter := g_vpb_tbl_counter + 1;
5751: g_vpb_tbl(g_vpb_tbl_counter).source_id := l_source_id;
5752: g_vpb_tbl(g_vpb_tbl_counter).source_table := l_source_table;
5753: g_vpb_tbl(g_vpb_tbl_counter).id := okc_p_util.raw_to_number(sys_guid());
5754: g_vpb_tbl(g_vpb_tbl_counter).khr_id := p_khr_id;
5755: g_vpb_tbl(g_vpb_tbl_counter).int_cal_process := 'VARIABLE_INTEREST';
5756: g_vpb_tbl(g_vpb_tbl_counter).OBJECT_VERSION_NUMBER := 1.0;
5757: g_vpb_tbl(g_vpb_tbl_counter).org_id := g_authoring_org_id;

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

5794: EXIT WHEN l_credit_memo_csr%NOTFOUND;
5795: g_vpb_tbl_counter := g_vpb_tbl_counter + 1;
5796: g_vpb_tbl(g_vpb_tbl_counter).source_id := l_source_id;
5797: g_vpb_tbl(g_vpb_tbl_counter).source_table := l_source_table;
5798: g_vpb_tbl(g_vpb_tbl_counter).id := okc_p_util.raw_to_number(sys_guid());
5799: g_vpb_tbl(g_vpb_tbl_counter).khr_id := p_khr_id;
5800: g_vpb_tbl(g_vpb_tbl_counter).int_cal_process := 'VARIABLE_INTEREST';
5801: g_vpb_tbl(g_vpb_tbl_counter).OBJECT_VERSION_NUMBER := 1.0;
5802: g_vpb_tbl(g_vpb_tbl_counter).org_id := g_authoring_org_id;

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

5838: EXIT WHEN l_adjustment_csr%NOTFOUND;
5839: g_vpb_tbl_counter := g_vpb_tbl_counter + 1;
5840: g_vpb_tbl(g_vpb_tbl_counter).source_id := l_source_id;
5841: g_vpb_tbl(g_vpb_tbl_counter).source_table := l_source_table;
5842: g_vpb_tbl(g_vpb_tbl_counter).id := okc_p_util.raw_to_number(sys_guid());
5843: g_vpb_tbl(g_vpb_tbl_counter).khr_id := p_khr_id;
5844: g_vpb_tbl(g_vpb_tbl_counter).int_cal_process := 'VARIABLE_INTEREST';
5845: g_vpb_tbl(g_vpb_tbl_counter).OBJECT_VERSION_NUMBER := 1.0;
5846: g_vpb_tbl(g_vpb_tbl_counter).org_id := g_authoring_org_id;