DBA Data[Home] [Help]

APPS.AHL_WF_MAPPING_PVT dependencies on AHL_UTILITY_PVT

Line 1273: IF Ahl_Utility_Pvt.check_uniqueness(

1269: -- check if this ID is unique.
1270: IF p_validation_mode = Jtf_Plsql_Api.g_create
1271: AND p_Wf_Mapping_rec.WF_Mapping_ID IS NOT NULL
1272: THEN
1273: IF Ahl_Utility_Pvt.check_uniqueness(
1274: 'AHL_Wf_Mapping',
1275: 'WF_Mapping_ID = ' || p_Wf_Mapping_rec.WF_Mapping_ID
1276: ) = Fnd_Api.g_false
1277: THEN

Line 1299: l_valid_flag := Ahl_Utility_Pvt.check_uniqueness (

1295: CLOSE c_appl_usg;*/
1296:
1297: -- check if APPROVAL OBJECT is UNIQUE
1298: IF p_validation_mode = Jtf_Plsql_Api.g_create THEN
1299: l_valid_flag := Ahl_Utility_Pvt.check_uniqueness (
1300: 'AHL_Wf_Mapping',
1301: 'APPROVAL_OBJECT = ''' || p_Wf_Mapping_rec.approval_object ||
1302: ''' AND APPLICATION_USG_CODE = ''' || p_Wf_Mapping_rec.application_usg_code || '''');
1303: ELSE

Line 1304: l_valid_flag := Ahl_Utility_Pvt.check_uniqueness (

1300: 'AHL_Wf_Mapping',
1301: 'APPROVAL_OBJECT = ''' || p_Wf_Mapping_rec.approval_object ||
1302: ''' AND APPLICATION_USG_CODE = ''' || p_Wf_Mapping_rec.application_usg_code || '''');
1303: ELSE
1304: l_valid_flag := Ahl_Utility_Pvt.check_uniqueness (
1305: 'AHL_Wf_Mapping',
1306: 'APPROVAL_OBJECT = ''' || p_Wf_Mapping_rec.approval_object ||
1307: ''' AND APPLICATION_USG_CODE = ''' || p_Wf_Mapping_rec.application_usg_code ||
1308: ''' AND WF_Mapping_ID <> ' || p_Wf_Mapping_rec.WF_Mapping_ID );