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_ACTPRODUCT_PVT dependencies on AMS_ACT_PRODUCTS

Line 44: -- 01-MAY-2001 julou modified, added 3 columns to ams_act_products

40: -- HISTORY
41: -- 11/11/1999 rvaka created
42: -- 08/01/2000 sugupta added access code to prevent hacking
43: -- 04/03/2001 abhola call to AMS_ACCESS_PVT changed to check for return value N
44: -- 01-MAY-2001 julou modified, added 3 columns to ams_act_products
45: -- security_group_id, line_lumpsum_amount, line_lumpsum_qty
46: -- 03-May-2001 rssharma Added validation for Offers(prod)
47: -- 07-May-2001 rssharma changed the validation for offer
48: -- 18-Oct-2001 Musman Added the validation for the schedules.

Line 123: SELECT ams_act_products_s.NEXTVAL

119: FROM ams_jtf_rs_emp_v
120: WHERE user_id = l_user_id;
121:
122: CURSOR C_act_product_id IS
123: SELECT ams_act_products_s.NEXTVAL
124: FROM dual;
125: BEGIN
126: -- Standard Start of API savepoint
127: SAVEPOINT Create_Act_Product_PVT;

Line 206: INSERT INTO AMS_ACT_PRODUCTS

202: OPEN c_act_product_id;
203: FETCH c_act_product_id INTO l_act_Product_rec.activity_product_id;
204: CLOSE c_act_product_id;
205:
206: INSERT INTO AMS_ACT_PRODUCTS
207: (
208: activity_product_id,
209: last_update_date,
210: last_updated_by,

Line 481: update AMS_ACT_PRODUCTS

477: end if;
478: ---------------------------------update-----------------------------
479: -- Perform the database operation
480:
481: update AMS_ACT_PRODUCTS
482: set
483: last_update_date = sysdate
484: ,last_updated_by = FND_GLOBAL.User_Id
485: ,last_update_login = FND_GLOBAL.Conc_Login_Id

Line 619: FROM ams_act_products a, ams_act_products b

615: l_res_id NUMBER;
616:
617: cursor get_association_info(l_act_id IN NUMBER) is
618: SELECT distinct a.ARC_ACT_PRODUCT_USED_BY, a.ACT_PRODUCT_USED_BY_ID
619: FROM ams_act_products a, ams_act_products b
620: WHERE a.ARC_ACT_PRODUCT_USED_BY = b.ARC_ACT_PRODUCT_USED_BY
621: AND a.ACT_PRODUCT_USED_BY_ID = b.ACT_PRODUCT_USED_BY_ID
622: AND b.ACTIVITY_PRODUCT_ID = l_act_id;
623:

Line 626: FROM ams_act_products

622: AND b.ACTIVITY_PRODUCT_ID = l_act_id;
623:
624: cursor get_count(c_obj_type IN VARCHAR2, c_obj_id IN NUMBER) is
625: SELECT 'dummy'
626: FROM ams_act_products
627: WHERE ARC_ACT_PRODUCT_USED_BY = c_obj_type
628: AND ACT_PRODUCT_USED_BY_ID = c_obj_id;
629:
630: CURSOR get_res_id(l_user_id IN NUMBER) IS

Line 637: FROM ams_act_products

633: WHERE user_id = l_user_id;
634:
635: CURSOR get_obj_info(l_actprd_id IN NUMBER) IS
636: SELECT arc_act_product_used_by, act_product_used_by_id
637: FROM ams_act_products
638: WHERE activity_product_id = l_actprd_id;
639:
640: BEGIN
641: -- Standard Start of API savepoint

Line 697: DELETE FROM AMS_ACT_PRODUCTS

693: close get_association_info;
694:
695: -- Perform the database operation
696: -- Delete header data
697: DELETE FROM AMS_ACT_PRODUCTS
698: WHERE activity_product_id = l_act_product_id
699: and object_version_number = p_object_version;
700: IF SQL%NOTFOUND THEN
701: --

Line 829: FROM AMS_ACT_PRODUCTS

825: l_return_status VARCHAR2(1); -- Return value from procedures
826: l_act_product_id NUMBER;
827: CURSOR c_act_product IS
828: SELECT activity_product_id
829: FROM AMS_ACT_PRODUCTS
830: WHERE activity_product_id = p_act_product_id
831: AND object_version_number = p_object_version
832: FOR UPDATE of activity_product_id NOWAIT;
833: BEGIN

Line 1055: FROM ams_act_products

1051: ,p_act_product_used_by_id IN NUMBER
1052: ,p_arc_act_product_used_by IN VARCHAR2)
1053: IS
1054: SELECT distinct primary_product_flag
1055: FROM ams_act_products
1056: WHERE category_set_id = p_category_set_id
1057: AND act_product_used_by_id = p_act_product_used_by_id
1058: AND arc_act_product_used_by = p_arc_act_product_used_by
1059: AND primary_product_flag = 'Y';

Line 1138: from AMS_ACT_PRODUCTS

1134: l_level VARCHAR2(150) := null;
1135:
1136: CURSOR c_include_level IS
1137: select level_type_code
1138: from AMS_ACT_PRODUCTS
1139: where ARC_ACT_PRODUCT_USED_BY = p_act_Product_rec.ARC_ACT_PRODUCT_USED_BY
1140: and ACT_PRODUCT_USED_BY_ID = p_act_Product_rec.ACT_PRODUCT_USED_BY_ID;
1141:
1142: CURSOR c_get_budget_type(l_fund_id IN NUMBER) IS

Line 1310: 'ams_act_products',

1306: IF p_validation_mode = JTF_PLSQL_API.g_create
1307: AND p_act_Product_rec.activity_product_id IS NOT NULL
1308: THEN
1309: IF AMS_Utility_PVT.check_uniqueness(
1310: 'ams_act_products',
1311: 'activity_product_id = ' || p_act_Product_rec.activity_product_id
1312: ) = FND_API.g_false
1313: THEN
1314: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

Line 1419: l_table_name := 'AMS_ACT_PRODUCTS_V';

1415: l_pk_name := 'CAMPAIGN_ID';
1416: -- 03-May-2001 RSSHARMA added
1417: ELSIF p_act_Product_rec.arc_act_product_used_by='PROD'
1418: THEN
1419: l_table_name := 'AMS_ACT_PRODUCTS_V';
1420: l_pk_name := 'ACTIVITY_PRODUCT_ID';
1421: -- end 03-May-2001
1422: ELSIF p_act_Product_rec.arc_act_product_used_by='MESG'
1423: THEN

Line 1692: from AMS_ACT_PRODUCTS

1688: item_in_cat NUMBER := 0; -- return value for cursor c_check_item
1689:
1690: CURSOR c_get_categories IS
1691: select category_id
1692: from AMS_ACT_PRODUCTS
1693: where ARC_ACT_PRODUCT_USED_BY = p_act_Product_rec.ARC_ACT_PRODUCT_USED_BY
1694: and ACT_PRODUCT_USED_BY_ID = p_act_Product_rec.ACT_PRODUCT_USED_BY_ID
1695: and EXCLUDED_FLAG = 'N';
1696:

Line 1699: from AMS_ACT_PRODUCTS

1695: and EXCLUDED_FLAG = 'N';
1696:
1697: CURSOR c_get_all_categories IS
1698: select category_id
1699: from AMS_ACT_PRODUCTS
1700: where ARC_ACT_PRODUCT_USED_BY = p_act_Product_rec.ARC_ACT_PRODUCT_USED_BY
1701: and ACT_PRODUCT_USED_BY_ID = p_act_Product_rec.ACT_PRODUCT_USED_BY_ID
1702: and level_type_code = 'FAMILY' -- musman: in prod assoc also we store cat id for lite
1703: and CATEGORY_ID IS NOT NULL;

Line 1707: from AMS_ACT_PRODUCTS

1703: and CATEGORY_ID IS NOT NULL;
1704:
1705: CURSOR c_get_all_items IS
1706: select INVENTORY_ITEM_ID
1707: from AMS_ACT_PRODUCTS
1708: where ARC_ACT_PRODUCT_USED_BY = p_act_Product_rec.ARC_ACT_PRODUCT_USED_BY
1709: and ACT_PRODUCT_USED_BY_ID = p_act_Product_rec.ACT_PRODUCT_USED_BY_ID
1710: and INVENTORY_ITEM_ID IS NOT NULL;
1711:

Line 1726: FROM ams_act_products

1722:
1723: -- julou cursors to check duplication of items and categories for scan data
1724: CURSOR c_scan_cat_dup1 IS
1725: SELECT COUNT(*)
1726: FROM ams_act_products
1727: WHERE arc_act_product_used_by = 'OFFR'
1728: AND act_product_used_by_id = p_act_Product_rec.act_product_used_by_id
1729: AND category_id = p_act_product_rec.category_id
1730: AND channel_id = p_act_Product_rec.channel_id

Line 1735: FROM ams_act_products

1731: AND excluded_flag = 'N';
1732:
1733: CURSOR c_scan_cat_dup2 IS
1734: SELECT COUNT(*)
1735: FROM ams_act_products
1736: WHERE arc_act_product_used_by = 'OFFR'
1737: AND act_product_used_by_id = p_act_Product_rec.act_product_used_by_id
1738: AND category_id = p_act_product_rec.category_id
1739: AND channel_id IS NULL

Line 1744: FROM ams_act_products

1740: AND excluded_flag = 'N';
1741:
1742: CURSOR c_scan_item_dup1 IS
1743: SELECT COUNT(*)
1744: FROM ams_act_products
1745: WHERE arc_act_product_used_by = 'OFFR'
1746: AND act_product_used_by_id = p_act_Product_rec.act_product_used_by_id
1747: AND inventory_item_id = p_act_Product_rec.inventory_item_id
1748: AND channel_id = p_act_Product_rec.channel_id

Line 1753: FROM ams_act_products

1749: AND excluded_flag = 'N';
1750:
1751: CURSOR c_scan_item_dup2 IS
1752: SELECT count(*)
1753: FROM ams_act_products
1754: WHERE arc_act_product_used_by = 'OFFR'
1755: AND act_product_used_by_id = p_act_Product_rec.act_product_used_by_id
1756: AND inventory_item_id = p_act_Product_rec.inventory_item_id
1757: AND channel_id IS NULL

Line 1762: FROM ams_act_products

1758: AND excluded_flag = 'N';
1759:
1760: CURSOR c_all_cat1 IS
1761: SELECT category_id
1762: FROM ams_act_products
1763: WHERE arc_act_product_used_by = p_act_product_rec.arc_act_product_used_by
1764: AND act_product_used_by_id = p_act_product_rec.act_product_used_by_id
1765: AND channel_id = p_act_Product_rec.channel_id
1766: AND category_id IS NOT NULL;

Line 1770: FROM ams_act_products

1766: AND category_id IS NOT NULL;
1767:
1768: CURSOR c_all_cat2 IS
1769: SELECT category_id
1770: FROM ams_act_products
1771: WHERE arc_act_product_used_by = p_act_product_rec.arc_act_product_used_by
1772: AND act_product_used_by_id = p_act_product_rec.act_product_used_by_id
1773: AND channel_id IS NULL
1774: AND category_id IS NOT NULL;

Line 1778: FROM ams_act_products

1774: AND category_id IS NOT NULL;
1775:
1776: CURSOR c_all_item1 IS
1777: SELECT inventory_item_id
1778: FROM ams_act_products
1779: WHERE arc_act_product_used_by = p_act_product_rec.arc_act_product_used_by
1780: AND act_product_used_by_id = p_act_product_rec.act_product_used_by_id
1781: AND channel_id = p_act_Product_rec.channel_id
1782: AND inventory_item_id IS NOT NULL;

Line 1786: FROM ams_act_products

1782: AND inventory_item_id IS NOT NULL;
1783:
1784: CURSOR c_all_item2 IS
1785: SELECT inventory_item_id
1786: FROM ams_act_products
1787: WHERE arc_act_product_used_by = p_act_product_rec.arc_act_product_used_by
1788: AND act_product_used_by_id = p_act_product_rec.act_product_used_by_id
1789: AND channel_id IS NULL
1790: AND inventory_item_id IS NOT NULL;

Line 2073: FROM ams_act_products

2069: x_act_Product_rec OUT NOCOPY act_Product_rec_type
2070: ) IS
2071: CURSOR c_product IS
2072: SELECT *
2073: FROM ams_act_products
2074: WHERE activity_product_id = p_act_Product_rec.activity_product_id;
2075:
2076: l_act_Product_rec c_product%ROWTYPE;
2077: BEGIN

Line 2451: from ams_act_products act, ams_campaign_schedules_b csc

2447:
2448: /* -- primary product flag should be marked from the UI
2449: CURSOR c_act_prod_id (l_csch_id IN NUMBER) IS
2450: SELECT activity_product_id
2451: from ams_act_products act, ams_campaign_schedules_b csc
2452: where act.ARC_ACT_PRODUCT_USED_BY = 'CSCH'
2453: and act.ACT_PRODUCT_USED_BY_ID = l_csch_id
2454: and act.LEVEL_TYPE_CODE = 'FAMILY'
2455: and act.ACT_PRODUCT_USED_BY_ID = csc.SCHEDULE_ID

Line 2489: UPDATE ams_act_products

2485: CLOSE c_act_prod_id ;
2486:
2487: IF (l_act_prod_id IS NOT NULL)
2488: THEN
2489: UPDATE ams_act_products
2490: SET primary_product_flag = 'Y'
2491: WHERE activity_product_id =l_act_prod_id;
2492: END IF;
2493: */

Line 2500: WF_CORE.CONTEXT('AMS_ACT_PRODUCTS','UPDATE_SCHEDULE_ACTIVITIES',

2496:
2497: EXCEPTION
2498:
2499: WHEN OTHERS THEN
2500: WF_CORE.CONTEXT('AMS_ACT_PRODUCTS','UPDATE_SCHEDULE_ACTIVITIES',
2501: p_event.getEventName( ), p_subscription_guid);
2502: WF_EVENT.setErrorInfo(p_event, 'ERROR');
2503: RETURN 'ERROR';
2504: END UPDATE_SCHEDULE_ACTIVITIES;

Line 2561: from ams_act_products

2557:
2558: CURSOR check_prod_exist
2559: IS
2560: SELECT 1
2561: from ams_act_products
2562: where arc_act_product_used_by = 'CAMP'
2563: and act_product_used_by_id = l_campaign_id
2564: and level_type_code = 'PRODUCT'
2565: and organization_id = p_act_product_rec.organization_id

Line 2571: from ams_act_products a

2567:
2568: CURSOR check_prod_cat_exist
2569: IS
2570: SELECT 1
2571: from ams_act_products a
2572: ,mtl_item_categories ml
2573: where arc_act_product_used_by = 'CAMP'
2574: and act_product_used_by_id = l_campaign_id
2575: and level_type_code = 'FAMILY'

Line 2585: from ams_act_products

2581:
2582: CURSOR check_cat_exist
2583: IS
2584: SELECT 1
2585: from ams_act_products
2586: where arc_act_product_used_by = 'CAMP'
2587: and act_product_used_by_id = l_campaign_id
2588: and level_type_code = 'FAMILY'
2589: and category_id = p_act_product_rec.category_id

Line 2598: from ams_act_products

2594: select 1
2595: from ENI_PROD_DEN_HRCHY_PARENTS_V
2596: where category_id = p_act_product_rec.category_id
2597: start with category_id in (select category_id
2598: from ams_act_products
2599: where arc_act_product_used_by = 'CAMP'
2600: and act_product_used_by_id = l_campaign_id
2601: and level_type_code = 'FAMILY')
2602: connect by prior category_id = category_parent_id ;