APPS.HR_INTEGRATION_UTILS dependencies on HR_ADI_INTG_RESP

Line 25: FROM hr_adi_intg_resp

21: FUNCTION intg_resp_chk(p_intg_code IN varchar2) RETURN boolean IS
22: --
23: CURSOR csr_chk_resp IS
24: SELECT resp_application_id, responsibility_id
25: FROM hr_adi_intg_resp
26: WHERE intg_application_id || ':' || integrator_code = p_intg_code;
27: --
28: l_curr_resp_id number := fnd_global.resp_id;
29: l_curr_resp_app_id number := fnd_global.resp_appl_id;

Line 1126: -- Called to populate an entry in the HR_ADI_INTG_RESP table, which is

1122: -- |-------------------< hr_create_resp_association >-------------------------|
1123: -- ----------------------------------------------------------------------------
1124: --
1125: -- Description:
1126: -- Called to populate an entry in the HR_ADI_INTG_RESP table, which is
1127: -- a table holding associations between integrators and responsibilities.
1128: --
1129: -- ----------------------------------------------------------------------------
1130: PROCEDURE hr_create_resp_association

Line 1212: -- combination, so create an entry in the HR_ADI_INTG_RESP table

1208: END IF;
1209: CLOSE csr_get_resp_id;
1210: --
1211: -- Now have a valid app_id/integrator_code and app_id/resp_id
1212: -- combination, so create an entry in the HR_ADI_INTG_RESP table
1213: --
1214: INSERT INTO hr_adi_intg_resp
1215: (resp_association_id,
1216: intg_application_id,

Line 1214: INSERT INTO hr_adi_intg_resp

1210: --
1211: -- Now have a valid app_id/integrator_code and app_id/resp_id
1212: -- combination, so create an entry in the HR_ADI_INTG_RESP table
1213: --
1214: INSERT INTO hr_adi_intg_resp
1215: (resp_association_id,
1216: intg_application_id,
1217: integrator_code,
1218: resp_application_id,

Line 1221: (hr_adi_intg_resp_s.nextval

1217: integrator_code,
1218: resp_application_id,
1219: responsibility_id)
1220: VALUES
1221: (hr_adi_intg_resp_s.nextval
1222: ,l_intg_application_id
1223: ,l_integrator_code
1224: ,l_resp_application_id
1225: ,l_responsibility_id);

Line 1234: -- Called to update or delete an entry in the HR_ADI_INTG_RESP table. If

1230: -- |--------------------< hr_upd_or_del_resp_association >--------------------|
1231: -- ----------------------------------------------------------------------------
1232: --
1233: -- Description:
1234: -- Called to update or delete an entry in the HR_ADI_INTG_RESP table. If
1235: -- the resp associated with an integrator is updated to NULL, then it is
1236: -- removed from the table. Otherwise, the resp_application_id and resp_name
1237: -- fields are updated.
1238: --

Line 1252: FROM hr_adi_intg_resp

1248: l_responsibility_id number;
1249: --
1250: CURSOR csr_chk_exists IS
1251: SELECT 'Y'
1252: FROM hr_adi_intg_resp
1253: WHERE resp_association_id = p_resp_association_id;
1254: --
1255: CURSOR csr_chk_app_exists IS
1256: SELECT application_id

Line 1285: -- Delete row from hr_adi_intg_resp

1281: --
1282: IF ((p_resp_application IS NULL)
1283: and (p_responsibility_name IS NULL)) THEN
1284: --
1285: -- Delete row from hr_adi_intg_resp
1286: DELETE FROM hr_adi_intg_resp
1287: WHERE resp_association_id = p_resp_association_id;
1288: --
1289: ELSE

Line 1286: DELETE FROM hr_adi_intg_resp

1282: IF ((p_resp_application IS NULL)
1283: and (p_responsibility_name IS NULL)) THEN
1284: --
1285: -- Delete row from hr_adi_intg_resp
1286: DELETE FROM hr_adi_intg_resp
1287: WHERE resp_association_id = p_resp_association_id;
1288: --
1289: ELSE
1290: -- Update required

Line 1323: UPDATE hr_adi_intg_resp

1319: END IF;
1320: CLOSE csr_chk_resp_exists;
1321: --
1322: -- Update the resp
1323: UPDATE hr_adi_intg_resp
1324: SET resp_application_id = l_application_id,
1325: responsibility_id = l_responsibility_id
1326: WHERE resp_association_id = p_resp_association_id;
1327: --