[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
1038: ,:l_user_id
1039: ,:l_user_id
1040: ,:l_current_time
1041: FROM
1042: per_jobs job
1043: ,per_job_definitions pjd
1044: WHERE job.job_definition_id = pjd.job_definition_id
1045: UNION ALL
1046: SELECT
1127: ,:l_user_id
1128: ,:l_user_id
1129: ,:l_current_time
1130: FROM
1131: per_jobs job
1132: ,per_job_definitions pjd
1133: WHERE job.job_definition_id = pjd.job_definition_id
1134: AND NOT EXISTS
1135: (SELECT null
1150: -- Bug 3347127 - don't delete unassigned row
1151: DELETE FROM hri_cs_jobh_ct jobh
1152: WHERE NOT EXISTS
1153: (SELECT null
1154: FROM per_jobs job
1155: WHERE job.job_id = jobh.job_id)
1156: AND jobh.job_id <> -1;
1157:
1158: -- Update changed rows
1165: (SELECT
1166: ' || l_job_fmly_column || '
1167: ,' || l_job_fnctn_column || '
1168: FROM
1169: per_jobs job
1170: ,per_job_definitions pjd
1171: WHERE job.job_definition_id = pjd.job_definition_id
1172: AND job.job_id = jobh.job_id)
1173: WHERE EXISTS
1172: AND job.job_id = jobh.job_id)
1173: WHERE EXISTS
1174: (SELECT null
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: AND (jobh.job_fmly_code <> ' || l_job_fmly_column || '