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.OZF_ACT_OFFERS_PVT dependencies on OZF_ACT_OFFERS

Line 1: PACKAGE BODY OZF_Act_Offers_PVT AS

1: PACKAGE BODY OZF_Act_Offers_PVT AS
2: /* $Header: ozfvoffb.pls 120.0 2005/06/01 01:54:23 appldev noship $ */
3:
4: g_pkg_name CONSTANT VARCHAR2(30) := 'OZF_Act_Offers_PVT';
5:

Line 4: g_pkg_name CONSTANT VARCHAR2(30) := 'OZF_Act_Offers_PVT';

1: PACKAGE BODY OZF_Act_Offers_PVT AS
2: /* $Header: ozfvoffb.pls 120.0 2005/06/01 01:54:23 appldev noship $ */
3:
4: g_pkg_name CONSTANT VARCHAR2(30) := 'OZF_Act_Offers_PVT';
5:
6:
7: /*****************************************************************************/
8: -- Procedure: create_act_offer

Line 57: SELECT ozf_act_offers_s.NEXTVAL

53: WHERE object_type = 'OFFR'
54: AND activity_type_code = p_act_offer_rec.offer_type;
55: */
56: CURSOR c_act_offer_seq IS
57: SELECT ozf_act_offers_s.NEXTVAL
58: FROM DUAL;
59:
60: CURSOR c_act_offer_count(act_offer_id IN NUMBER) IS
61: SELECT COUNT(*)

Line 62: FROM ozf_act_offers

58: FROM DUAL;
59:
60: CURSOR c_act_offer_count(act_offer_id IN NUMBER) IS
61: SELECT COUNT(*)
62: FROM ozf_act_offers
63: WHERE activity_offer_id = act_offer_id;
64:
65: BEGIN
66:

Line 163: INSERT INTO OZF_ACT_OFFERS

159: OPEN c_offer_code(l_act_offer_rec.qp_list_header_id);
160: FETCH c_offer_code INTO l_offer_code;
161: CLOSE c_offer_code;
162:
163: INSERT INTO OZF_ACT_OFFERS
164: (
165: activity_offer_id,
166: last_update_date,
167: last_updated_by,

Line 445: UPDATE ozf_act_offers SET

441: l_act_offer_rec.primary_offer_flag := 'N';
442: END IF;
443:
444: -- update
445: UPDATE ozf_act_offers SET
446: last_update_date = SYSDATE,
447: last_updated_by = FND_GLOBAL.user_id,
448: object_version_number = l_act_offer_rec.object_version_number + 1,
449: last_update_login = FND_GLOBAL.conc_login_id,

Line 559: FROM ozf_act_offers

555: l_dummy NUMBER;
556:
557: CURSOR c_used_by IS
558: SELECT act_offer_used_by_id, arc_act_offer_used_by
559: FROM ozf_act_offers
560: WHERE activity_offer_id = p_act_offer_id;
561:
562: CURSOR c_offer IS
563: SELECT 1

Line 564: FROM ozf_act_offers

560: WHERE activity_offer_id = p_act_offer_id;
561:
562: CURSOR c_offer IS
563: SELECT 1
564: FROM ozf_act_offers
565: WHERE act_offer_used_by_id = l_used_by_id
566: AND arc_act_offer_used_by = l_used_by;
567:
568: BEGIN

Line 595: DELETE FROM OZF_ACT_OFFERS

591: FETCH c_used_by INTO l_used_by_id, l_used_by;
592: CLOSE c_used_by;
593:
594: -- delete
595: DELETE FROM OZF_ACT_OFFERS
596: WHERE activity_offer_id = p_act_offer_id
597: AND object_version_number = p_object_version;
598:
599: IF (SQL%NOTFOUND) THEN

Line 712: FROM OZF_ACT_OFFERS

708: l_act_offer_id NUMBER;
709:
710: CURSOR c_act_offer_b IS
711: SELECT activity_offer_id
712: FROM OZF_ACT_OFFERS
713: WHERE activity_offer_id = p_act_offer_id
714: AND object_version_number = p_object_version
715: FOR UPDATE OF activity_offer_id NOWAIT;
716:

Line 1030: 'OZF_ACT_OFFERS',

1026: -- AND p_act_offer_rec.activity_offer_id IS NOT NULL
1027: THEN
1028: l_uk_flag := OZF_Utility_PVT.check_uniqueness
1029: (
1030: 'OZF_ACT_OFFERS',
1031: ' qp_list_header_id = ' || p_act_offer_rec.qp_list_header_id ||
1032: ' AND act_offer_used_by_id = ' || p_act_offer_rec.act_offer_used_by_id ||
1033: ' AND arc_act_offer_used_by = ' ||p_act_offer_rec.arc_act_offer_used_by
1034: );

Line 1040: 'OZF_ACT_OFFERS',

1036: AND p_act_offer_rec.activity_offer_id IS NOT NULL
1037: THEN
1038: l_uk_flag := OZF_Utility_PVT.check_uniqueness
1039: (
1040: 'OZF_ACT_OFFERS',
1041: ' activity_offer_id <> '|| p_act_offer_rec.activity_offer_id ||
1042: ' AND qp_list_header_id = ' || p_act_offer_rec.qp_list_header_id ||
1043: ' AND act_offer_used_by_id = ' || p_act_offer_rec.act_offer_used_by_id ||
1044: ' AND arc_act_offer_used_by = ' ||p_act_offer_rec.arc_act_offer_used_by

Line 1378: SELECT COUNT(*) FROM OZF_ACT_OFFERS

1374: OR actual_exec_end_date >= trunc(SYSDATE) );
1375:
1376:
1377: CURSOR c_primary_offer_count1(used_by_id IN NUMBER, used_by IN VARCHAR2) IS
1378: SELECT COUNT(*) FROM OZF_ACT_OFFERS
1379: WHERE act_offer_used_by_id = used_by_id
1380: AND arc_act_offer_used_by = used_by
1381: AND primary_offer_flag = 'Y';
1382:

Line 1384: SELECT COUNT(*) FROM OZF_ACT_OFFERS

1380: AND arc_act_offer_used_by = used_by
1381: AND primary_offer_flag = 'Y';
1382:
1383: CURSOR c_primary_offer_count2(act_offer_id IN NUMBER, used_by_id IN NUMBER, used_by IN VARCHAR2) IS
1384: SELECT COUNT(*) FROM OZF_ACT_OFFERS
1385: WHERE act_offer_used_by_id = used_by_id
1386: AND arc_act_offer_used_by = used_by
1387: AND activity_offer_id <> act_offer_id
1388: AND primary_offer_flag = 'Y';

Line 1504: FROM ozf_act_offers

1500: IS
1501:
1502: CURSOR c_act_offer IS
1503: SELECT *
1504: FROM ozf_act_offers
1505: WHERE activity_offer_id = p_act_offer_rec.activity_offer_id;
1506:
1507: l_act_offer_rec c_act_offer%ROWTYPE;
1508:

Line 2418: END OZF_Act_Offers_PVT;

2414:
2415: END Delete_Offer;
2416: */
2417:
2418: END OZF_Act_Offers_PVT;