DBA Data[Home] [Help]

APPS.AP_WEB_POLICY_UTILS dependencies on FND_PROFILE

Line 221: nvl(FND_PROFILE.VALUE('AP_WEB_POLICY_GRACE_PERIOD') , '0') < sysdate ) THEN

217: WHERE policy_id = p_policy_id;
218:
219: -- Bug # 7132415
220: IF ( l_sch_end_date IS NOT NULL ) AND ( l_sch_end_date +
221: nvl(FND_PROFILE.VALUE('AP_WEB_POLICY_GRACE_PERIOD') , '0') < sysdate ) THEN
222:
223: l_lookup_code := 'INACTIVE';
224:
225: ELSE

Line 7347: FND_PROFILE.GET('AP_WEB_REPNUM_PREFIX', l_report_prefix);

7343: p_dup_detect_action := NULL;
7344:
7345: l_rule_id := getDuplicateDetectionRule(p_org_id, p_category_code, p_start_date);
7346:
7347: FND_PROFILE.GET('AP_WEB_REPNUM_PREFIX', l_report_prefix);
7348:
7349: IF l_rule_id IS NOT NULL AND l_rule_id <> -1 THEN
7350:
7351: OPEN dup_detect_rule_cur(l_rule_id);