APPS.PER_ZA_QUA_UPD dependencies on PER_QUA_SHD

Line 64: per_qua_shd.g_api_dml := true; -- Set the api dml status

60: --
61: -- Increment the object version
62: --
63: --
64: per_qua_shd.g_api_dml := true; -- Set the api dml status
65: --
66: -- Update the per_qualifications Row
67: --
68: update per_za_formal_qualifications

Line 78: per_qua_shd.g_api_dml := false; -- Unset the api dml status

74: registration_date = p_rec.registration_date,
75: registration_number = p_rec.registration_number
76: where qualification_id = p_rec.qualification_id;
77: --
78: per_qua_shd.g_api_dml := false; -- Unset the api dml status
79: --
80: hr_utility.set_location(' Leaving:'||l_proc, 10);
81: --
82: Exception

Line 85: per_qua_shd.g_api_dml := false; -- Unset the api dml status

81: --
82: Exception
83: When hr_api.check_integrity_violated Then
84: -- A check constraint has been violated
85: per_qua_shd.g_api_dml := false; -- Unset the api dml status
86: per_qua_shd.constraint_error
87: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
88: When hr_api.parent_integrity_violated Then
89: -- Parent integrity has been violated

Line 86: per_qua_shd.constraint_error

82: Exception
83: When hr_api.check_integrity_violated Then
84: -- A check constraint has been violated
85: per_qua_shd.g_api_dml := false; -- Unset the api dml status
86: per_qua_shd.constraint_error
87: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
88: When hr_api.parent_integrity_violated Then
89: -- Parent integrity has been violated
90: per_qua_shd.g_api_dml := false; -- Unset the api dml status

Line 90: per_qua_shd.g_api_dml := false; -- Unset the api dml status

86: per_qua_shd.constraint_error
87: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
88: When hr_api.parent_integrity_violated Then
89: -- Parent integrity has been violated
90: per_qua_shd.g_api_dml := false; -- Unset the api dml status
91: per_qua_shd.constraint_error
92: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
93: When hr_api.unique_integrity_violated Then
94: -- Unique integrity has been violated

Line 91: per_qua_shd.constraint_error

87: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
88: When hr_api.parent_integrity_violated Then
89: -- Parent integrity has been violated
90: per_qua_shd.g_api_dml := false; -- Unset the api dml status
91: per_qua_shd.constraint_error
92: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
93: When hr_api.unique_integrity_violated Then
94: -- Unique integrity has been violated
95: per_qua_shd.g_api_dml := false; -- Unset the api dml status

Line 95: per_qua_shd.g_api_dml := false; -- Unset the api dml status

91: per_qua_shd.constraint_error
92: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
93: When hr_api.unique_integrity_violated Then
94: -- Unique integrity has been violated
95: per_qua_shd.g_api_dml := false; -- Unset the api dml status
96: per_qua_shd.constraint_error
97: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
98: When Others Then
99: per_qua_shd.g_api_dml := false; -- Unset the api dml status

Line 96: per_qua_shd.constraint_error

92: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
93: When hr_api.unique_integrity_violated Then
94: -- Unique integrity has been violated
95: per_qua_shd.g_api_dml := false; -- Unset the api dml status
96: per_qua_shd.constraint_error
97: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
98: When Others Then
99: per_qua_shd.g_api_dml := false; -- Unset the api dml status
100: Raise;

Line 99: per_qua_shd.g_api_dml := false; -- Unset the api dml status

95: per_qua_shd.g_api_dml := false; -- Unset the api dml status
96: per_qua_shd.constraint_error
97: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
98: When Others Then
99: per_qua_shd.g_api_dml := false; -- Unset the api dml status
100: Raise;
101: End update_dml;
102: --
103: -- ----------------------------------------------------------------------------