APPS.AP_WEB_POLICY_UTILS dependencies on AP_POL_SCHEDULE_OPTIONS_S

Line 2263: SELECT ap_pol_schedule_options_s.NEXTVAL

2259: and threshold = 0;
2260:
2261: IF ( l_zero_threshold_count = 0 ) THEN
2262: BEGIN
2263: SELECT ap_pol_schedule_options_s.NEXTVAL
2264: INTO l_schedule_option_rec.schedule_option_id
2265: FROM DUAL;
2266:
2267: INSERT INTO ap_pol_schedule_options

Line 2335: SELECT ap_pol_schedule_options_s.NEXTVAL

2331: and threshold = 0;
2332:
2333: IF ( l_zero_threshold_count = 0 ) THEN
2334: BEGIN
2335: SELECT ap_pol_schedule_options_s.NEXTVAL
2336: INTO l_schedule_option_rec.schedule_option_id
2337: FROM DUAL;
2338:
2339: INSERT INTO ap_pol_schedule_options

Line 4170: AP_POL_SCHEDULE_OPTIONS_S.NEXTVAL AS SCHEDULE_OPTION_ID,

4166: LAST_UPDATE_DATE,
4167: LAST_UPDATED_BY
4168: )
4169: select
4170: AP_POL_SCHEDULE_OPTIONS_S.NEXTVAL AS SCHEDULE_OPTION_ID,
4171: p_to_policy_id AS POLICY_ID,
4172: OPTION_TYPE,
4173: OPTION_CODE,
4174: THRESHOLD,

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

4451: *=======================================================================*/
4452: PROCEDURE status_saved_sched_opts(p_policy_id IN NUMBER) IS
4453: BEGIN
4454: IF p_policy_id IS NOT NULL THEN
4455: update AP_POL_SCHEDULE_OPTIONS set STATUS = 'SAVED' where POLICY_ID = p_policy_id and nvl(STATUS, '~') <> 'ACTIVE';
4456: END IF;
4457: END status_saved_sched_opts;
4458:
4459: /*========================================================================

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

4505: p_status_code IN VARCHAR2) IS
4506: BEGIN
4507: IF p_policy_id IS NOT NULL AND
4508: p_status_code IS NOT NULL THEN
4509: update AP_POL_SCHEDULE_OPTIONS set STATUS = p_status_code where POLICY_ID = p_policy_id;
4510: END IF;
4511: END set_status_pol_sched_opts;
4512:
4513: /*========================================================================