APPS.OKL_INSURANCE_POLICIES_PVT dependencies on FND_PROFILE

Line 3387: select mo_global.get_current_org_id() l_fnd_profile

3383:
3384: l_salesP_rec salesP_csr%ROWTYPE;
3385:
3386: Cursor fnd_pro_csr IS
3387: select mo_global.get_current_org_id() l_fnd_profile
3388: from dual;
3389: fnd_pro_rec fnd_pro_csr%ROWTYPE;
3390: counter NUMBER;
3391:

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

3622: OPEN fnd_pro_csr;
3623: FETCH fnd_pro_csr INTO fnd_pro_rec;
3624: IF ( fnd_pro_csr%FOUND ) Then
3625: l_acc_gen_primary_key_tbl(counter).source_table := 'FINANCIALS_SYSTEM_PARAMETERS';
3626: l_acc_gen_primary_key_tbl(counter).primary_key_column := fnd_pro_rec.l_fnd_profile;
3627: counter := counter + 1 ;
3628: End IF;
3629: CLOSE fnd_pro_csr;
3630: OPEN salesP_csr(l_ipyv_rec.KHR_ID);

Line 3996: select mo_global.get_current_org_id() l_fnd_profile

3992:
3993: l_salesP_rec salesP_csr%ROWTYPE;
3994:
3995: Cursor fnd_pro_csr IS
3996: select mo_global.get_current_org_id() l_fnd_profile
3997: from dual;
3998: fnd_pro_rec fnd_pro_csr%ROWTYPE;
3999: counter NUMBER;
4000: --smoduga..Bug 4493213 fix..08-aug-2005..end

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

4256: OPEN fnd_pro_csr;
4257: FETCH fnd_pro_csr INTO fnd_pro_rec;
4258: IF ( fnd_pro_csr%FOUND ) Then
4259: l_acc_gen_primary_key_tbl(counter).source_table := 'FINANCIALS_SYSTEM_PARAMETERS';
4260: l_acc_gen_primary_key_tbl(counter).primary_key_column := fnd_pro_rec.l_fnd_profile;
4261: counter := counter + 1 ;
4262: End IF;
4263: CLOSE fnd_pro_csr;
4264: OPEN salesP_csr(l_ipyv_rec.KHR_ID);

Line 6026: select mo_global.get_current_org_id() l_fnd_profile

6022:
6023: l_salesP_rec salesP_csr%ROWTYPE;
6024:
6025: Cursor fnd_pro_csr IS
6026: select mo_global.get_current_org_id() l_fnd_profile
6027: from dual;
6028: fnd_pro_rec fnd_pro_csr%ROWTYPE;
6029:
6030: -- smoduga added for 3845998

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

6078:
6079:
6080: IF (l_ipyv_rec.CRX_CODE = 'CANCELED_BY_CUSTOMER') THEN
6081: -- GET system profile to check for third party information
6082: ls_check_tpi := fnd_profile.value('OKLINCANCHECKTPI');
6083: IF ((ls_check_tpi IS NULL ) OR (ls_check_tpi = OKC_API.G_MISS_CHAR )) THEN
6084: x_return_status := OKC_API.G_RET_STS_ERROR;
6085: OKC_API.set_message(G_APP_NAME, G_NO_SYSTEM_PROFILE,G_SYS_PROFILE_NAME,'OKL: Cancel policy with proof of third party insurance' );
6086: RAISE OKC_API.G_EXCEPTION_ERROR;

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

6128: OPEN rcvbl_max_billed_date(l_rcvbl_strm_type_id, l_ipyv_rec.khr_id, l_ipyv_rec.kle_id );
6129: FETCH rcvbl_max_billed_date INTO l_last_billed_date;
6130: CLOSE rcvbl_max_billed_date;
6131:
6132: l_check_refund_months:= fnd_profile.value('OKLINMAXNOOFMONTHSREFUND');
6133:
6134: IF MONTHS_BETWEEN (l_ipyv_rec.cancellation_date,l_last_billed_date) < l_check_refund_months THEN --[A]
6135: pay_cust_refund(
6136: p_api_version => l_api_version,

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

6420: OPEN fnd_pro_csr;
6421: FETCH fnd_pro_csr INTO fnd_pro_rec;
6422: IF ( fnd_pro_csr%FOUND ) Then
6423: l_acc_gen_primary_key_tbl(counter).source_table := 'FINANCIALS_SYSTEM_PARAMETERS';
6424: l_acc_gen_primary_key_tbl(counter).primary_key_column := fnd_pro_rec.l_fnd_profile;
6425: counter := counter + 1 ;
6426: End IF;
6427: CLOSE fnd_pro_csr;
6428: