eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_CNT_POINT_PVT dependencies on AMS_ACT_CONTACT_POINTS

Line 55: SELECT AMS_ACT_CONTACT_POINTS_s.NEXTVAL

51: l_CONTACT_POINT_ID NUMBER;
52: l_dummy NUMBER;
53:
54: CURSOR c_id IS
55: SELECT AMS_ACT_CONTACT_POINTS_s.NEXTVAL
56: FROM dual;
57:
58: CURSOR c_id_exists (l_id IN NUMBER) IS
59: SELECT 1 FROM dual

Line 60: WHERE EXISTS (SELECT 1 FROM AMS_ACT_CONTACT_POINTS

56: FROM dual;
57:
58: CURSOR c_id_exists (l_id IN NUMBER) IS
59: SELECT 1 FROM dual
60: WHERE EXISTS (SELECT 1 FROM AMS_ACT_CONTACT_POINTS
61: WHERE CONTACT_POINT_ID = l_id);
62:
63: BEGIN
64: IF (AMS_DEBUG_HIGH_ON) THEN

Line 174: -- Invoke table handler(AMS_ACT_CONTACT_POINTS_PKG.Insert_Row)

170:
171: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
172: END IF;
173:
174: -- Invoke table handler(AMS_ACT_CONTACT_POINTS_PKG.Insert_Row)
175: AMS_ACT_CONTACT_POINTS_PKG.Insert_Row(
176: px_contact_point_id => l_contact_point_id,
177: p_last_update_date => SYSDATE,
178: p_last_updated_by => FND_GLOBAL.user_id,

Line 175: AMS_ACT_CONTACT_POINTS_PKG.Insert_Row(

171: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
172: END IF;
173:
174: -- Invoke table handler(AMS_ACT_CONTACT_POINTS_PKG.Insert_Row)
175: AMS_ACT_CONTACT_POINTS_PKG.Insert_Row(
176: px_contact_point_id => l_contact_point_id,
177: p_last_update_date => SYSDATE,
178: p_last_updated_by => FND_GLOBAL.user_id,
179: p_creation_date => SYSDATE,

Line 296: FROM AMS_ACT_CONTACT_POINTS

292: IS
293:
294: CURSOR c_get_cnt_point(contact_point_id NUMBER) IS
295: SELECT *
296: FROM AMS_ACT_CONTACT_POINTS
297: WHERE contact_point_id = p_cnt_point_rec.contact_point_id;
298: -- Hint: Developer need to provide Where clause
299:
300: L_API_NAME CONSTANT VARCHAR2(30) := 'Update_Cnt_Point';

Line 413: -- Invoke table handler(AMS_ACT_CONTACT_POINTS_PKG.Update_Row)

409:
410: AMS_UTILITY_PVT.debug_message( 'Private API: Calling update table handler');
411: END IF;
412:
413: -- Invoke table handler(AMS_ACT_CONTACT_POINTS_PKG.Update_Row)
414: AMS_ACT_CONTACT_POINTS_PKG.Update_Row(
415: p_contact_point_id => p_cnt_point_rec.contact_point_id,
416: p_last_update_date => SYSDATE,
417: p_last_updated_by => FND_GLOBAL.user_id,

Line 414: AMS_ACT_CONTACT_POINTS_PKG.Update_Row(

410: AMS_UTILITY_PVT.debug_message( 'Private API: Calling update table handler');
411: END IF;
412:
413: -- Invoke table handler(AMS_ACT_CONTACT_POINTS_PKG.Update_Row)
414: AMS_ACT_CONTACT_POINTS_PKG.Update_Row(
415: p_contact_point_id => p_cnt_point_rec.contact_point_id,
416: p_last_update_date => SYSDATE,
417: p_last_updated_by => FND_GLOBAL.user_id,
418: p_last_update_login => FND_GLOBAL.conc_login_id,

Line 525: FROM AMS_ACT_CONTACT_POINTS

521: IS
522:
523: CURSOR c_Cnt_Point IS
524: SELECT CONTACT_POINT_ID
525: FROM AMS_ACT_CONTACT_POINTS
526: WHERE CONTACT_POINT_ID = p_CONTACT_POINT_ID
527: AND object_version_number = p_object_version_number ;
528:
529: L_API_NAME CONSTANT VARCHAR2(30) := 'Delete_Cnt_Point';

Line 588: -- Invoke table handler(AMS_ACT_CONTACT_POINTS_PKG.Delete_Row)

584:
585: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
586: END IF;
587:
588: -- Invoke table handler(AMS_ACT_CONTACT_POINTS_PKG.Delete_Row)
589: AMS_ACT_CONTACT_POINTS_PKG.Delete_Row(
590: p_CONTACT_POINT_ID => p_CONTACT_POINT_ID);
591: --
592: -- End of API body

Line 589: AMS_ACT_CONTACT_POINTS_PKG.Delete_Row(

585: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
586: END IF;
587:
588: -- Invoke table handler(AMS_ACT_CONTACT_POINTS_PKG.Delete_Row)
589: AMS_ACT_CONTACT_POINTS_PKG.Delete_Row(
590: p_CONTACT_POINT_ID => p_CONTACT_POINT_ID);
591: --
592: -- End of API body
593: --

Line 679: FROM AMS_ACT_CONTACT_POINTS

675: l_CONTACT_POINT_ID NUMBER;
676:
677: CURSOR c_Cnt_Point IS
678: SELECT CONTACT_POINT_ID
679: FROM AMS_ACT_CONTACT_POINTS
680: WHERE CONTACT_POINT_ID = p_CONTACT_POINT_ID
681: AND object_version_number = p_object_version
682: FOR UPDATE NOWAIT;
683:

Line 813: 'AMS_ACT_CONTACT_POINTS',

809: AMS_UTILITY_PVT.debug_message(p_cnt_point_rec.arc_contact_used_by);
810: END IF;
811: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
812: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
813: 'AMS_ACT_CONTACT_POINTS',
814: 'CONTACT_POINT_ID = ' || p_cnt_point_rec.CONTACT_POINT_ID
815: );
816: IF l_valid_flag = FND_API.g_false THEN
817: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_CONTACT_POINT_ID_DUPLICATE');

Line 823: 'AMS_ACT_CONTACT_POINTS'

819: RETURN;
820: END IF;
821: -- code added by me
822: /*l_valid_flag := AMS_Utility_PVT.check_uniqueness(
823: 'AMS_ACT_CONTACT_POINTS'
824: , '''ARC_CONTACT_USED_BY = ''' || p_cnt_point_rec.ARC_CONTACT_USED_BY ||
825: ''' AND ACT_CONTACT_USED_BY_ID = ' || p_cnt_point_rec.ACT_CONTACT_USED_BY_ID ||
826: ''' AND CONTACT_POINT_TYPE = ''' || p_cnt_point_rec.CONTACT_POINT_TYPE ||
827: ''' AND CONTACT_POINT_VALUE = ''' || p_cnt_point_rec.CONTACT_POINT_VALUE

Line 837: 'AMS_ACT_CONTACT_POINTS',

833:
834:
835: /*ELSE
836: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
837: 'AMS_ACT_CONTACT_POINTS',
838: 'CONTACT_POINT_ID = ' || p_cnt_point_rec.CONTACT_POINT_ID
839: );
840:
841:

Line 1502: FROM ams_act_contact_points

1498: IS
1499: l_contact_point_id NUMBER ;
1500: CURSOR c_check_cnt_point_uk_rec_cr IS
1501: SELECT contact_point_id
1502: FROM ams_act_contact_points
1503: WHERE arc_contact_used_by = p_cnt_point_rec.arc_contact_used_by
1504: AND act_contact_used_by_id = p_cnt_point_rec.act_contact_used_by_id
1505: AND contact_point_type = p_cnt_point_rec.contact_point_type
1506: AND contact_point_value = p_cnt_point_rec.contact_point_value

Line 1511: FROM ams_act_contact_points

1507: AND contact_point_value_id = p_cnt_point_rec.contact_point_value_id;
1508:
1509: CURSOR c_check_cnt_point_uk_rec_up IS
1510: SELECT contact_point_id
1511: FROM ams_act_contact_points
1512: WHERE arc_contact_used_by = p_cnt_point_rec.arc_contact_used_by
1513: AND act_contact_used_by_id = p_cnt_point_rec.act_contact_used_by_id
1514: AND contact_point_type = p_cnt_point_rec.contact_point_type
1515: AND contact_point_value = p_cnt_point_rec.contact_point_value