APPS.AP_WEB_POLICY_UTILS dependencies on AP_POL_SCHEDULE_OPTIONS_S

Line 2312: SELECT ap_pol_schedule_options_s.NEXTVAL

2308: and threshold = 0;
2309:
2310: IF ( l_zero_threshold_count = 0 ) THEN
2311: BEGIN
2312: SELECT ap_pol_schedule_options_s.NEXTVAL
2313: INTO l_schedule_option_rec.schedule_option_id
2314: FROM DUAL;
2315:
2316: INSERT INTO ap_pol_schedule_options

Line 2384: SELECT ap_pol_schedule_options_s.NEXTVAL

2380: and threshold = 0;
2381:
2382: IF ( l_zero_threshold_count = 0 ) THEN
2383: BEGIN
2384: SELECT ap_pol_schedule_options_s.NEXTVAL
2385: INTO l_schedule_option_rec.schedule_option_id
2386: FROM DUAL;
2387:
2388: INSERT INTO ap_pol_schedule_options

Line 4239: AP_POL_SCHEDULE_OPTIONS_S.NEXTVAL AS SCHEDULE_OPTION_ID,

4235: LAST_UPDATE_DATE,
4236: LAST_UPDATED_BY
4237: )
4238: select
4239: AP_POL_SCHEDULE_OPTIONS_S.NEXTVAL AS SCHEDULE_OPTION_ID,
4240: p_to_policy_id AS POLICY_ID,
4241: OPTION_TYPE,
4242: OPTION_CODE,
4243: THRESHOLD,

Line 4526: update AP_POL_SCHEDULE_OPTIONS set STATUS = 'SAVED' where POLICY_ID = p_policy_id and nvl(STATUS, '~') <> 'ACTIVE';

4522: *=======================================================================*/
4523: PROCEDURE status_saved_sched_opts(p_policy_id IN NUMBER) IS
4524: BEGIN
4525: IF p_policy_id IS NOT NULL THEN
4526: update AP_POL_SCHEDULE_OPTIONS set STATUS = 'SAVED' where POLICY_ID = p_policy_id and nvl(STATUS, '~') <> 'ACTIVE';
4527: END IF;
4528: END status_saved_sched_opts;
4529:
4530: /*========================================================================

Line 4580: update AP_POL_SCHEDULE_OPTIONS set STATUS = p_status_code where POLICY_ID = p_policy_id;

4576: p_status_code IN VARCHAR2) IS
4577: BEGIN
4578: IF p_policy_id IS NOT NULL AND
4579: p_status_code IS NOT NULL THEN
4580: update AP_POL_SCHEDULE_OPTIONS set STATUS = p_status_code where POLICY_ID = p_policy_id;
4581: END IF;
4582: END set_status_pol_sched_opts;
4583:
4584: /*========================================================================