DBA Data[Home] [Help]

APPS.OKS_OMINT_PUB dependencies on FND_PROFILE

Line 77: l_min_duration := fnd_profile.value('OKS_MINIMUM_SVC_DURATION');

73:
74: x_return_status := OKC_API.G_RET_STS_SUCCESS;
75:
76: -- Profile Check
77: l_min_duration := fnd_profile.value('OKS_MINIMUM_SVC_DURATION');
78: l_min_period := fnd_profile.value('OKS_MINIMUM_SVC_PERIOD');
79: l_min_duration := Round(l_min_duration,0);
80: If l_min_duration Is Null Or l_min_period Is Null Then
81: -- l_min_duration := 60;

Line 78: l_min_period := fnd_profile.value('OKS_MINIMUM_SVC_PERIOD');

74: x_return_status := OKC_API.G_RET_STS_SUCCESS;
75:
76: -- Profile Check
77: l_min_duration := fnd_profile.value('OKS_MINIMUM_SVC_DURATION');
78: l_min_period := fnd_profile.value('OKS_MINIMUM_SVC_PERIOD');
79: l_min_duration := Round(l_min_duration,0);
80: If l_min_duration Is Null Or l_min_period Is Null Then
81: -- l_min_duration := 60;
82: -- l_min_period := 'DAY';

Line 1484: If Fnd_Profile.Value('OKS_CONTRACTS_VALIDATION_SOURCE') = 'IB' OR Fnd_Profile.Value('OKS_CONTRACTS_VALIDATION_SOURCE') Is NULL Then

1480: Fetch l_oline_csr into l_line_rec;
1481: Close l_oline_csr;
1482:
1483: /* Added for Bug#15885433*/
1484: If Fnd_Profile.Value('OKS_CONTRACTS_VALIDATION_SOURCE') = 'IB' OR Fnd_Profile.Value('OKS_CONTRACTS_VALIDATION_SOURCE') Is NULL Then
1485: Okc_context.set_okc_org_context (l_line_rec.org_id, l_line_rec.ship_from_org_id);
1486: Elsif Fnd_Profile.Value('OKS_CONTRACTS_VALIDATION_SOURCE') = 'MO' Then
1487: Okc_context.set_okc_org_context (l_line_rec.org_id, NULL );
1488: Elsif Fnd_Profile.Value('OKS_CONTRACTS_VALIDATION_SOURCE') = 'SO' Then

Line 1486: Elsif Fnd_Profile.Value('OKS_CONTRACTS_VALIDATION_SOURCE') = 'MO' Then

1482:
1483: /* Added for Bug#15885433*/
1484: If Fnd_Profile.Value('OKS_CONTRACTS_VALIDATION_SOURCE') = 'IB' OR Fnd_Profile.Value('OKS_CONTRACTS_VALIDATION_SOURCE') Is NULL Then
1485: Okc_context.set_okc_org_context (l_line_rec.org_id, l_line_rec.ship_from_org_id);
1486: Elsif Fnd_Profile.Value('OKS_CONTRACTS_VALIDATION_SOURCE') = 'MO' Then
1487: Okc_context.set_okc_org_context (l_line_rec.org_id, NULL );
1488: Elsif Fnd_Profile.Value('OKS_CONTRACTS_VALIDATION_SOURCE') = 'SO' Then
1489: l_organization_id := Null;
1490: If l_line_rec.sold_from_org_id Is Not Null Then

Line 1488: Elsif Fnd_Profile.Value('OKS_CONTRACTS_VALIDATION_SOURCE') = 'SO' Then

1484: If Fnd_Profile.Value('OKS_CONTRACTS_VALIDATION_SOURCE') = 'IB' OR Fnd_Profile.Value('OKS_CONTRACTS_VALIDATION_SOURCE') Is NULL Then
1485: Okc_context.set_okc_org_context (l_line_rec.org_id, l_line_rec.ship_from_org_id);
1486: Elsif Fnd_Profile.Value('OKS_CONTRACTS_VALIDATION_SOURCE') = 'MO' Then
1487: Okc_context.set_okc_org_context (l_line_rec.org_id, NULL );
1488: Elsif Fnd_Profile.Value('OKS_CONTRACTS_VALIDATION_SOURCE') = 'SO' Then
1489: l_organization_id := Null;
1490: If l_line_rec.sold_from_org_id Is Not Null Then
1491: Open l_organization_csr(l_line_rec.sold_from_org_id);
1492: Fetch l_organization_csr into l_organization_id;

Line 1498: Elsif Fnd_Profile.Value('OKS_CONTRACTS_VALIDATION_SOURCE') = 'SH' Then

1494: Else
1495: l_organization_id := Null;
1496: End If;
1497: Okc_context.set_okc_org_context (l_line_rec.org_id, l_organization_id);
1498: Elsif Fnd_Profile.Value('OKS_CONTRACTS_VALIDATION_SOURCE') = 'SH' Then
1499: Okc_context.set_okc_org_context (l_line_rec.org_id, l_line_rec.ship_from_org_id);
1500: End If;
1501: /* End of Code Added for Bug#15885433*/
1502: