APPS.AP_WEB_UPLOAD_PDM_PKG dependencies on AP_POL_SCHEDULE_OPTIONS

Line 850: select AP_POL_SCHEDULE_OPTIONS_S.NEXTVAL

846: l_schedule_option_id NUMBER(15);
847:
848: BEGIN
849:
850: select AP_POL_SCHEDULE_OPTIONS_S.NEXTVAL
851: into l_schedule_option_id
852: from dual;
853:
854: insert into AP_POL_SCHEDULE_OPTIONS

Line 854: insert into AP_POL_SCHEDULE_OPTIONS

850: select AP_POL_SCHEDULE_OPTIONS_S.NEXTVAL
851: into l_schedule_option_id
852: from dual;
853:
854: insert into AP_POL_SCHEDULE_OPTIONS
855: (
856: SCHEDULE_OPTION_ID,
857: POLICY_ID,
858: OPTION_TYPE,

Line 1281: from ap_pol_schedule_options

1277: ------------------------------------------------------------------------
1278:
1279: cursor schedule_option_cur is
1280: select schedule_option_id
1281: from ap_pol_schedule_options
1282: where policy_id = p_policy_id
1283: and option_type = 'LOCATION'
1284: and location_id = p_location_id
1285: and rownum = 1;

Line 2529: from ap_pol_schedule_options

2525: -- cursor roles
2526: -------------------------------
2527: cursor roles_cur is
2528: select role_id
2529: from ap_pol_schedule_options
2530: where policy_id = p_policy_id
2531: and option_type = AP_WEB_POLICY_UTILS.c_EMPLOYEE_ROLE
2532: and role_id is not null;
2533: