[Home] [Help]
79: CURSOR full_descr_flex_csr IS
80: SELECT 'DESCRIPTIVE'
81: FROM
82: fnd_descr_flex_col_usage_vl dfcu
83: WHERE dfcu.descriptive_flexfield_name = 'PER_JOBS'
84: AND dfcu.application_id = 800
85: AND dfcu.flex_value_set_id = p_value_set_id
86: AND rownum = 1;
87:
206: ,ctxt.global_flag global_flag
207: FROM
208: fnd_descr_flex_col_usage_vl dfcu
209: ,fnd_descr_flex_contexts_vl ctxt
210: WHERE dfcu.descriptive_flexfield_name = 'PER_JOBS'
211: AND dfcu.application_id = 800
212: AND dfcu.flex_value_set_id = v_valueset_id
213: AND ctxt.application_id = dfcu.application_id
214: AND ctxt.descriptive_flexfield_name = dfcu.descriptive_flexfield_name
1045: ,:l_user_id
1046: ,:l_user_id
1047: ,:l_current_time
1048: FROM
1049: per_jobs job
1050: ,per_job_definitions pjd
1051: WHERE job.job_definition_id = pjd.job_definition_id
1052: UNION ALL
1053: SELECT
1134: ,:l_user_id
1135: ,:l_user_id
1136: ,:l_current_time
1137: FROM
1138: per_jobs job
1139: ,per_job_definitions pjd
1140: WHERE job.job_definition_id = pjd.job_definition_id
1141: AND NOT EXISTS
1142: (SELECT null
1157: -- Bug 3347127 - don't delete unassigned row
1158: DELETE FROM hri_cs_jobh_ct jobh
1159: WHERE NOT EXISTS
1160: (SELECT null
1161: FROM per_jobs job
1162: WHERE job.job_id = jobh.job_id)
1163: AND jobh.job_id <> -1;
1164:
1165: -- Update changed rows
1172: (SELECT
1173: ' || l_job_fmly_column || '
1174: ,' || l_job_fnctn_column || '
1175: FROM
1176: per_jobs job
1177: ,per_job_definitions pjd
1178: WHERE job.job_definition_id = pjd.job_definition_id
1179: AND job.job_id = jobh.job_id)
1180: WHERE EXISTS
1179: AND job.job_id = jobh.job_id)
1180: WHERE EXISTS
1181: (SELECT null
1182: FROM
1183: per_jobs job
1184: ,per_job_definitions pjd
1185: WHERE job.job_definition_id = pjd.job_definition_id
1186: AND job.job_id = jobh.job_id
1187: AND (jobh.job_fmly_code <> ' || l_job_fmly_column || '