APPS.AP_WEB_UPLOAD_PDM_PKG dependencies on AP_POL_SCHEDULE_OPTIONS

Line 871: select AP_POL_SCHEDULE_OPTIONS_S.NEXTVAL

867: l_schedule_option_id NUMBER(15);
868:
869: BEGIN
870:
871: select AP_POL_SCHEDULE_OPTIONS_S.NEXTVAL
872: into l_schedule_option_id
873: from dual;
874:
875: insert into AP_POL_SCHEDULE_OPTIONS

Line 875: insert into AP_POL_SCHEDULE_OPTIONS

871: select AP_POL_SCHEDULE_OPTIONS_S.NEXTVAL
872: into l_schedule_option_id
873: from dual;
874:
875: insert into AP_POL_SCHEDULE_OPTIONS
876: (
877: SCHEDULE_OPTION_ID,
878: POLICY_ID,
879: OPTION_TYPE,

Line 1303: from ap_pol_schedule_options

1299: ------------------------------------------------------------------------
1300:
1301: cursor schedule_option_cur is
1302: select schedule_option_id
1303: from ap_pol_schedule_options
1304: where policy_id = p_policy_id
1305: and option_type = 'LOCATION'
1306: and location_id = p_location_id
1307: and rownum = 1;

Line 2558: from ap_pol_schedule_options

2554: -- cursor roles
2555: -------------------------------
2556: cursor roles_cur is
2557: select role_id
2558: from ap_pol_schedule_options
2559: where policy_id = p_policy_id
2560: and option_type = AP_WEB_POLICY_UTILS.c_EMPLOYEE_ROLE
2561: and role_id is not null;
2562: