APPS.CSP_AUTO_ASLMSL_PVT dependencies on FND_PROFILE

Line 17: G_PRODUCT_ORGANIZATION NUMBER := Fnd_Profile.Value('ASO_PRODUCT_ORGANIZATION_ID');

13:
14: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
15: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
16: G_TOP_NODE_ID NUMBER := 0;
17: G_PRODUCT_ORGANIZATION NUMBER := Fnd_Profile.Value('ASO_PRODUCT_ORGANIZATION_ID');
18: G_USAGE_DATA NUMBER;
19: G_FORECAST_DATA NUMBER;
20: G_TOP_NODE_USAGE_DATA NUMBER;
21: G_ORG_USAGE_DATA NUMBER;

Line 1090: --G_LAST_RUN_DATE := fnd_profile.Value('CSP_USAGE_RUN_DATE');

1086: --
1087: -- API body
1088: --
1089:
1090: --G_LAST_RUN_DATE := fnd_profile.Value('CSP_USAGE_RUN_DATE');
1091: Begin
1092: select PROFILE_OPTION_VALUE
1093: into G_LAST_RUN_DATE
1094: from fnd_profile_option_values

Line 1094: from fnd_profile_option_values

1090: --G_LAST_RUN_DATE := fnd_profile.Value('CSP_USAGE_RUN_DATE');
1091: Begin
1092: select PROFILE_OPTION_VALUE
1093: into G_LAST_RUN_DATE
1094: from fnd_profile_option_values
1095: where APPLICATION_ID = 523
1096: and PROFILE_OPTION_ID in
1097: (select profile_option_id
1098: from fnd_profile_options

Line 1098: from fnd_profile_options

1094: from fnd_profile_option_values
1095: where APPLICATION_ID = 523
1096: and PROFILE_OPTION_ID in
1097: (select profile_option_id
1098: from fnd_profile_options
1099: where profile_option_name = ('CSP_USAGE_RUN_DATE'));
1100: Exception
1101: When others then
1102: G_LAST_RUN_DATE := NULL;

Line 1143: if not fnd_profile.save('CSP_USAGE_RUN_DATE',trunc(sysdate) -1,'SITE') Then

1139: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1140: End If;
1141: -- Re-establish Savepoint
1142: SAVEPOINT CREATE_USAGE_PVT;
1143: if not fnd_profile.save('CSP_USAGE_RUN_DATE',trunc(sysdate) -1,'SITE') Then
1144: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1145: End If;
1146: COMMIT;
1147: -- Re-establish Savepoint