APPS.AMS_ACTPARTNER_PVT dependencies on AMS_ACT_PARTNERS

Line 62: SELECT ams_act_partners_s.NEXTVAL

58: l_act_partner_count NUMBER;
59: l_act_partner_rec act_partner_rec_type := p_act_partner_rec;
60:
61: CURSOR c_act_partner_seq IS
62: SELECT ams_act_partners_s.NEXTVAL
63: FROM DUAL;
64:
65: CURSOR c_act_partner_count(act_partner_id IN NUMBER) IS
66: SELECT COUNT(*)

Line 67: FROM ams_act_partners

63: FROM DUAL;
64:
65: CURSOR c_act_partner_count(act_partner_id IN NUMBER) IS
66: SELECT COUNT(*)
67: FROM ams_act_partners
68: WHERE activity_partner_id = act_partner_id;
69:
70: BEGIN
71:

Line 142: INSERT INTO ams_act_partners(

138: );
139:
140: check_primary(l_act_partner_rec.primary_flag ,l_act_partner_rec.act_partner_used_by_id,l_act_partner_rec.arc_act_partner_used_by,l_return_status);
141: ---------------------- insert --------------------------
142: INSERT INTO ams_act_partners(
143:
144: activity_partner_id,
145: last_update_date,
146: last_updated_by,

Line 394: UPDATE ams_act_partners SET

390:
391:
392: -------------------------- update --------------------
393:
394: UPDATE ams_act_partners SET
395: last_update_date = SYSDATE,
396: last_updated_by = FND_GLOBAL.user_id,
397: last_update_login = FND_GLOBAL.conc_login_id,
398: primary_flag = l_act_partner_rec.primary_flag,

Line 552: FROM ams_act_partners

548: -- still associated to the marketing
549: -- object.
550: CURSOR c_partner_type (p_act_partner_id IN NUMBER) IS
551: SELECT arc_act_partner_used_by, act_partner_used_by_id
552: FROM ams_act_partners
553: WHERE activity_partner_id = p_act_partner_id;
554:
555: CURSOR c_partner_attr (p_object_type IN VARCHAR2, p_object_id IN NUMBER) IS
556: SELECT 1

Line 557: FROM ams_act_partners

553: WHERE activity_partner_id = p_act_partner_id;
554:
555: CURSOR c_partner_attr (p_object_type IN VARCHAR2, p_object_id IN NUMBER) IS
556: SELECT 1
557: FROM ams_act_partners
558: WHERE arc_act_partner_used_by = p_object_type
559: AND act_partner_used_by_id = p_object_id;
560:
561: BEGIN

Line 604: DELETE FROM ams_act_partners

600:
601: AMS_Utility_PVT.debug_message(p_object_version ||': p_object_version');
602: END IF;
603:
604: DELETE FROM ams_act_partners
605: WHERE activity_partner_id = p_act_partner_id
606: AND object_version_number = p_object_version;
607:
608: IF (SQL%NOTFOUND) THEN

Line 705: FROM ams_act_partners

701: l_act_partner_id NUMBER;
702:
703: CURSOR c_act_partner IS
704: SELECT activity_partner_id
705: FROM ams_act_partners
706: WHERE activity_partner_id = p_act_partner_id
707: AND object_version_number = p_object_version
708: FOR UPDATE OF activity_partner_id NOWAIT;
709:

Line 1139: FROM ams_act_partners

1135: IS
1136:
1137: CURSOR c_act_partner IS
1138: SELECT *
1139: FROM ams_act_partners
1140: WHERE activity_partner_id = p_act_partner_rec.activity_partner_id;
1141:
1142: l_act_partner_rec c_act_partner%ROWTYPE;
1143:

Line 1287: FROM ams_act_partners

1283: l_activity_partner_id NUMBER :=0;
1284:
1285: CURSOR c_primary_flag(l_id IN NUMBER , l_used_by IN VARCHAR2) IS
1286: SELECT count(*)
1287: FROM ams_act_partners
1288: WHERE primary_flag = 'Y'
1289: AND act_partner_used_by_id = l_id
1290: AND arc_act_partner_used_by = l_used_by;
1291: BEGIN

Line 1342: 'AMS_ACT_PARTNERS',

1338: x_return_status := FND_API.g_ret_sts_success;
1339:
1340: -- validate uniqueness of arc_used_by, arc_used_by_id, and partner_id
1341: IF AMS_Utility_PVT.check_uniqueness (
1342: 'AMS_ACT_PARTNERS',
1343: 'arc_act_partner_used_by = ' || p_act_partner_rec.arc_act_partner_used_by ||
1344: ' AND act_partner_used_by_id = ' || p_act_partner_rec.act_partner_used_by_id ||
1345: ' AND partner_id = ' || p_act_partner_rec.partner_id
1346: ) = FND_API.g_false THEN