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 1113: -- Called to populate an entry in the HR_ADI_INTG_RESP table, which is

1109: -- |-------------------< hr_create_resp_association >-------------------------|
1110: -- ----------------------------------------------------------------------------
1111: --
1112: -- Description:
1113: -- Called to populate an entry in the HR_ADI_INTG_RESP table, which is
1114: -- a table holding associations between integrators and responsibilities.
1115: --
1116: -- ----------------------------------------------------------------------------
1117: PROCEDURE hr_create_resp_association

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

1195: END IF;
1196: CLOSE csr_get_resp_id;
1197: --
1198: -- Now have a valid app_id/integrator_code and app_id/resp_id
1199: -- combination, so create an entry in the HR_ADI_INTG_RESP table
1200: --
1201: INSERT INTO hr_adi_intg_resp
1202: (resp_association_id,
1203: intg_application_id,

Line 1201: INSERT INTO hr_adi_intg_resp

1197: --
1198: -- Now have a valid app_id/integrator_code and app_id/resp_id
1199: -- combination, so create an entry in the HR_ADI_INTG_RESP table
1200: --
1201: INSERT INTO hr_adi_intg_resp
1202: (resp_association_id,
1203: intg_application_id,
1204: integrator_code,
1205: resp_application_id,

Line 1208: (hr_adi_intg_resp_s.nextval

1204: integrator_code,
1205: resp_application_id,
1206: responsibility_id)
1207: VALUES
1208: (hr_adi_intg_resp_s.nextval
1209: ,l_intg_application_id
1210: ,l_integrator_code
1211: ,l_resp_application_id
1212: ,l_responsibility_id);

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

1217: -- |--------------------< hr_upd_or_del_resp_association >--------------------|
1218: -- ----------------------------------------------------------------------------
1219: --
1220: -- Description:
1221: -- Called to update or delete an entry in the HR_ADI_INTG_RESP table. If
1222: -- the resp associated with an integrator is updated to NULL, then it is
1223: -- removed from the table. Otherwise, the resp_application_id and resp_name
1224: -- fields are updated.
1225: --

Line 1239: FROM hr_adi_intg_resp

1235: l_responsibility_id number;
1236: --
1237: CURSOR csr_chk_exists IS
1238: SELECT 'Y'
1239: FROM hr_adi_intg_resp
1240: WHERE resp_association_id = p_resp_association_id;
1241: --
1242: CURSOR csr_chk_app_exists IS
1243: SELECT application_id

Line 1272: -- Delete row from hr_adi_intg_resp

1268: --
1269: IF ((p_resp_application IS NULL)
1270: and (p_responsibility_name IS NULL)) THEN
1271: --
1272: -- Delete row from hr_adi_intg_resp
1273: DELETE FROM hr_adi_intg_resp
1274: WHERE resp_association_id = p_resp_association_id;
1275: --
1276: ELSE

Line 1273: DELETE FROM hr_adi_intg_resp

1269: IF ((p_resp_application IS NULL)
1270: and (p_responsibility_name IS NULL)) THEN
1271: --
1272: -- Delete row from hr_adi_intg_resp
1273: DELETE FROM hr_adi_intg_resp
1274: WHERE resp_association_id = p_resp_association_id;
1275: --
1276: ELSE
1277: -- Update required

Line 1310: UPDATE hr_adi_intg_resp

1306: END IF;
1307: CLOSE csr_chk_resp_exists;
1308: --
1309: -- Update the resp
1310: UPDATE hr_adi_intg_resp
1311: SET resp_application_id = l_application_id,
1312: responsibility_id = l_responsibility_id
1313: WHERE resp_association_id = p_resp_association_id;
1314: --