APPS.HR_EFC_INFO dependencies on HR_EFC_WORKER_AUDITS

Line 1209: FROM hr_efc_worker_audits ewa

1205: CURSOR csr_find_row(c_worker_id IN number, c_column_name IN varchar2,
1206: c_currency IN varchar2) IS
1207: SELECT ewa.efc_worker_audit_id
1208: , ewa.number_of_rows
1209: FROM hr_efc_worker_audits ewa
1210: WHERE ewa.efc_worker_id = c_worker_id
1211: AND ewa.column_name = c_column_name
1212: AND ewa.currency_code = c_currency;
1213: --

Line 1216: SELECT hr_efc_worker_audits_s.nextval

1212: AND ewa.currency_code = c_currency;
1213: --
1214: -- Cursor to fetch a unique id
1215: CURSOR csr_get_id IS
1216: SELECT hr_efc_worker_audits_s.nextval
1217: FROM dual;
1218: --
1219: l_audit_id number;
1220: l_rows number;

Line 1250: INSERT INTO hr_efc_worker_audits

1246: -- No current row in audit table, so add one
1247: CLOSE csr_find_row;
1248: --
1249: -- Insert row into audit table
1250: INSERT INTO hr_efc_worker_audits
1251: (efc_worker_audit_id
1252: ,efc_worker_id
1253: ,column_name
1254: ,currency_code

Line 1263: (hr_efc_worker_audits_s.nextval

1259: ,created_by
1260: ,creation_date
1261: )
1262: VALUES
1263: (hr_efc_worker_audits_s.nextval
1264: ,p_worker_id
1265: ,p_column_name
1266: ,p_last_curr
1267: ,p_count

Line 1277: UPDATE hr_efc_worker_audits

1273: );
1274: ELSE
1275: CLOSE csr_find_row;
1276: -- Update row in Audit table
1277: UPDATE hr_efc_worker_audits
1278: SET number_of_rows = l_rows + p_count
1279: WHERE efc_worker_audit_id = l_audit_id;
1280: END IF;
1281: -- Changes made to audit table, so indicate this, and reset variables

Line 1305: FROM hr_efc_worker_audits ewa

1301: CURSOR csr_find_row(c_worker_id IN number, c_column_name IN varchar2,
1302: c_currency IN varchar2) IS
1303: SELECT ewa.efc_worker_audit_id
1304: , ewa.number_of_rows
1305: FROM hr_efc_worker_audits ewa
1306: WHERE ewa.efc_worker_id = c_worker_id
1307: AND ewa.column_name = c_column_name
1308: AND ewa.currency_code = c_currency;
1309: --

Line 1324: INSERT INTO hr_efc_worker_audits

1320: -- No current row in audit table, so add one
1321: CLOSE csr_find_row;
1322: --
1323: -- Insert row into audit table
1324: INSERT INTO hr_efc_worker_audits
1325: (efc_worker_audit_id
1326: ,efc_worker_id
1327: ,column_name
1328: ,currency_code

Line 1337: (hr_efc_worker_audits_s.nextval

1333: ,created_by
1334: ,creation_date
1335: )
1336: VALUES
1337: (hr_efc_worker_audits_s.nextval
1338: ,p_efc_worker_id
1339: ,p_col_name
1340: ,p_last_curr
1341: ,p_count

Line 1351: UPDATE hr_efc_worker_audits

1347: );
1348: ELSE
1349: CLOSE csr_find_row;
1350: -- Update row in Audit table
1351: UPDATE hr_efc_worker_audits
1352: SET number_of_rows = l_rows + p_count
1353: WHERE efc_worker_audit_id = l_audit_id;
1354: END IF;
1355: -- Changes made to audit table, so indicate this, and reset variables