APPS.OKL_INSURANCE_POLICIES_PVT dependencies on FND_PROFILE

Line 3368: select mo_global.get_current_org_id() l_fnd_profile

3364:
3365: l_salesP_rec salesP_csr%ROWTYPE;
3366:
3367: Cursor fnd_pro_csr IS
3368: select mo_global.get_current_org_id() l_fnd_profile
3369: from dual;
3370: fnd_pro_rec fnd_pro_csr%ROWTYPE;
3371: counter NUMBER;
3372:

Line 3604: l_acc_gen_primary_key_tbl(counter).primary_key_column := fnd_pro_rec.l_fnd_profile;

3600: OPEN fnd_pro_csr;
3601: FETCH fnd_pro_csr INTO fnd_pro_rec;
3602: IF ( fnd_pro_csr%FOUND ) Then
3603: l_acc_gen_primary_key_tbl(counter).source_table := 'FINANCIALS_SYSTEM_PARAMETERS';
3604: l_acc_gen_primary_key_tbl(counter).primary_key_column := fnd_pro_rec.l_fnd_profile;
3605: counter := counter + 1 ;
3606: End IF;
3607: CLOSE fnd_pro_csr;
3608: OPEN salesP_csr(l_ipyv_rec.KHR_ID);

Line 3971: select mo_global.get_current_org_id() l_fnd_profile

3967:
3968: l_salesP_rec salesP_csr%ROWTYPE;
3969:
3970: Cursor fnd_pro_csr IS
3971: select mo_global.get_current_org_id() l_fnd_profile
3972: from dual;
3973: fnd_pro_rec fnd_pro_csr%ROWTYPE;
3974: counter NUMBER;
3975: --smoduga..Bug 4493213 fix..08-aug-2005..end

Line 4232: l_acc_gen_primary_key_tbl(counter).primary_key_column := fnd_pro_rec.l_fnd_profile;

4228: OPEN fnd_pro_csr;
4229: FETCH fnd_pro_csr INTO fnd_pro_rec;
4230: IF ( fnd_pro_csr%FOUND ) Then
4231: l_acc_gen_primary_key_tbl(counter).source_table := 'FINANCIALS_SYSTEM_PARAMETERS';
4232: l_acc_gen_primary_key_tbl(counter).primary_key_column := fnd_pro_rec.l_fnd_profile;
4233: counter := counter + 1 ;
4234: End IF;
4235: CLOSE fnd_pro_csr;
4236: OPEN salesP_csr(l_ipyv_rec.KHR_ID);

Line 6033: select mo_global.get_current_org_id() l_fnd_profile

6029:
6030: l_salesP_rec salesP_csr%ROWTYPE;
6031:
6032: Cursor fnd_pro_csr IS
6033: select mo_global.get_current_org_id() l_fnd_profile
6034: from dual;
6035: fnd_pro_rec fnd_pro_csr%ROWTYPE;
6036:
6037: -- smoduga added for 3845998

Line 6089: ls_check_tpi := fnd_profile.value('OKLINCANCHECKTPI');

6085:
6086:
6087: IF (l_ipyv_rec.CRX_CODE = 'CANCELED_BY_CUSTOMER') THEN
6088: -- GET system profile to check for third party information
6089: ls_check_tpi := fnd_profile.value('OKLINCANCHECKTPI');
6090: IF ((ls_check_tpi IS NULL ) OR (ls_check_tpi = OKC_API.G_MISS_CHAR )) THEN
6091: x_return_status := OKC_API.G_RET_STS_ERROR;
6092: OKC_API.set_message(G_APP_NAME, G_NO_SYSTEM_PROFILE,G_SYS_PROFILE_NAME,'OKL: Cancel policy with proof of third party insurance' );
6093: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 6139: l_check_refund_months:= fnd_profile.value('OKLINMAXNOOFMONTHSREFUND');

6135: OPEN rcvbl_max_billed_date(l_rcvbl_strm_type_id, l_ipyv_rec.khr_id, l_ipyv_rec.kle_id );
6136: FETCH rcvbl_max_billed_date INTO l_last_billed_date;
6137: CLOSE rcvbl_max_billed_date;
6138:
6139: l_check_refund_months:= fnd_profile.value('OKLINMAXNOOFMONTHSREFUND');
6140:
6141: IF MONTHS_BETWEEN (l_ipyv_rec.cancellation_date,l_last_billed_date) < l_check_refund_months THEN --[A]
6142: pay_cust_refund(
6143: p_api_version => l_api_version,

Line 6431: l_acc_gen_primary_key_tbl(counter).primary_key_column := fnd_pro_rec.l_fnd_profile;

6427: OPEN fnd_pro_csr;
6428: FETCH fnd_pro_csr INTO fnd_pro_rec;
6429: IF ( fnd_pro_csr%FOUND ) Then
6430: l_acc_gen_primary_key_tbl(counter).source_table := 'FINANCIALS_SYSTEM_PARAMETERS';
6431: l_acc_gen_primary_key_tbl(counter).primary_key_column := fnd_pro_rec.l_fnd_profile;
6432: counter := counter + 1 ;
6433: End IF;
6434: CLOSE fnd_pro_csr;
6435: