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 1093: --G_LAST_RUN_DATE := fnd_profile.Value('CSP_USAGE_RUN_DATE');

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

Line 1097: from fnd_profile_option_values

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

Line 1101: from fnd_profile_options

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

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

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