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_ACT_LIST_PVT dependencies on AMS_ACT_LISTS

Line 368: FROM ams_act_lists

364: -- Get the smallest order number
365: l_min_order number;
366: cursor c_min_order is
367: SELECT nvl(Min(order_number),-1)
368: FROM ams_act_lists
369: WHERE list_used_by_id = p_act_list_rec.list_used_by_id and
370: list_used_by = p_act_list_rec.list_used_by and
371: list_act_type <> 'TARGET';
372:

Line 376: FROM ams_act_lists

372:
373: -- Get list action type where order num is the smallest
374: Cursor c_min_list_action_type IS
375: SELECT list_action_type
376: FROM ams_act_lists
377: WHERE list_used_by_id = p_act_list_rec.list_used_by_id and
378: list_used_by = p_act_list_rec.list_used_by and
379: list_act_type <> 'TARGET' and
380: order_number = l_min_order;

Line 385: SELECT AMS_ACT_LISTS_s.NEXTVAL

381: l_action_type varchar2(30);
382:
383:
384: CURSOR c_id IS
385: SELECT AMS_ACT_LISTS_s.NEXTVAL
386: FROM dual;
387:
388: CURSOR c_id_exists (l_id IN NUMBER) IS
389: SELECT 1

Line 390: FROM AMS_ACT_LISTS

386: FROM dual;
387:
388: CURSOR c_id_exists (l_id IN NUMBER) IS
389: SELECT 1
390: FROM AMS_ACT_LISTS
391: WHERE ACT_LIST_HEADER_ID = l_id;
392: l_act_list_rec act_list_rec_type := p_act_list_rec;
393:
394: cursor c_check_group (cur_group_code in varchar2) is

Line 397: ams_act_lists acl

393:
394: cursor c_check_group (cur_group_code in varchar2) is
395: select alg.act_list_group_id
396: from ams_act_list_groups alg,
397: ams_act_lists acl
398: where alg.arc_act_list_used_by = 'TARGET'
399: and alg.group_code = cur_group_code
400: and alg.act_list_used_by_id = acl.list_header_id
401: and acl.list_used_by = 'LIST'

Line 560: -- Invoke table handler(AMS_ACT_LISTS_PKG.Insert_Row)

556: END IF;
557: end if;
558: end if;
559:
560: -- Invoke table handler(AMS_ACT_LISTS_PKG.Insert_Row)
561: -- Debug Message
562: IF (AMS_DEBUG_HIGH_ON) THEN
563:
564: AMS_Utility_PVT.debug_message( 'Private API: Call create table handler');

Line 567: AMS_ACT_LISTS_PKG.Insert_Row(

563:
564: AMS_Utility_PVT.debug_message( 'Private API: Call create table handler');
565: END IF;
566:
567: AMS_ACT_LISTS_PKG.Insert_Row(
568: px_act_list_header_id => l_act_list_header_id,
569: p_last_update_date => SYSDATE,
570: p_last_updated_by => FND_GLOBAL.USER_ID,
571: p_creation_date => SYSDATE,

Line 704: FROM ams_act_lists

700: l_return_status VARCHAR2(1);
701:
702: CURSOR c_complete IS
703: SELECT *
704: FROM ams_act_lists
705: WHERE act_list_header_id = p_act_list_rec.act_list_header_id;
706: l_act_list_rec c_complete%ROWTYPE;
707: BEGIN
708: x_complete_rec := p_act_list_rec;

Line 803: FROM ams_act_lists

799: -- Get the smallest order number
800: l_min_order number;
801: cursor c_min_order is
802: SELECT nvl(Min(order_number),-1)
803: FROM ams_act_lists
804: WHERE list_used_by_id = p_act_list_rec.list_used_by_id and
805: list_used_by = p_act_list_rec.list_used_by and
806: list_act_type <> 'TARGET';
807:

Line 811: FROM ams_act_lists

807:
808: -- Get list action type where order num is the smallest
809: Cursor c_min_list_action_type IS
810: SELECT list_action_type
811: FROM ams_act_lists
812: WHERE list_used_by_id = p_act_list_rec.list_used_by_id and
813: list_used_by = p_act_list_rec.list_used_by and
814: list_act_type <> 'TARGET' and
815: order_number = l_min_order;

Line 820: FROM AMS_ACT_LISTS

816: l_action_type varchar2(30);
817:
818: CURSOR c_get_act_list(cur_act_list_header_id NUMBER) IS
819: SELECT *
820: FROM AMS_ACT_LISTS
821: where act_list_header_id = cur_act_list_header_id ;
822: L_API_NAME CONSTANT VARCHAR2(30) := 'Update_Act_List';
823: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
824: cursor c_check_group (cur_group_code in varchar2) is

Line 827: ams_act_lists acl

823: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
824: cursor c_check_group (cur_group_code in varchar2) is
825: select alg.act_list_group_id
826: from ams_act_list_groups alg,
827: ams_act_lists acl
828: where alg.arc_act_list_used_by = 'TARGET'
829: and alg.group_code = cur_group_code
830: and p_act_list_rec.list_header_id = alg.act_list_used_by_id
831: and acl.list_used_by = 'LIST'

Line 1006: AMS_ACT_LISTS_PKG.Update_Row(

1002: END IF;
1003: end if;
1004: end if;
1005:
1006: AMS_ACT_LISTS_PKG.Update_Row(
1007: p_act_list_header_id => l_act_list_rec.act_list_header_id,
1008: p_last_update_date => SYSDATE,
1009: p_last_updated_by => FND_GLOBAL.USER_ID,
1010: p_creation_date => SYSDATE,

Line 1104: from ams_act_lists a, ams_campaign_schedules_vl b

1100: l_object_version_number NUMBER;
1101:
1102: cursor c1 is
1103: select 'x'
1104: from ams_act_lists a, ams_campaign_schedules_vl b
1105: where act_list_header_id = p_act_list_header_id
1106: and a.list_used_by_id = b.schedule_id
1107: and a.list_used_by = 'CSCH'
1108: and b.status_code = 'ACTIVE'

Line 1111: from ams_act_lists a, ams_event_offers_vl b

1107: and a.list_used_by = 'CSCH'
1108: and b.status_code = 'ACTIVE'
1109: union
1110: select 'x'
1111: from ams_act_lists a, ams_event_offers_vl b
1112: where p_act_list_header_id = p_act_list_header_id
1113: and a.list_used_by_id = b.event_offer_id
1114: and a.list_used_by in('EVEO','EONE')
1115: and b.system_status_code = 'ACTIVE';

Line 1159: -- Invoke table handler(AMS_ACT_LISTS_PKG.Delete_Row)

1155: AMS_Utility_PVT.debug_message( 'Private API: Calling delete table
1156: handler');
1157: END IF;
1158:
1159: -- Invoke table handler(AMS_ACT_LISTS_PKG.Delete_Row)
1160: if l_char = 'x' then
1161: FND_MESSAGE.set_name('AMS', 'AMS_DELETE_TARGET');
1162: FND_MSG_PUB.add;
1163: RAISE FND_API.g_exc_error;

Line 1165: AMS_ACT_LISTS_PKG.Delete_Row(

1161: FND_MESSAGE.set_name('AMS', 'AMS_DELETE_TARGET');
1162: FND_MSG_PUB.add;
1163: RAISE FND_API.g_exc_error;
1164: else
1165: AMS_ACT_LISTS_PKG.Delete_Row(
1166: p_ACT_LIST_HEADER_ID => p_ACT_LIST_HEADER_ID);
1167: end if;
1168: --
1169: -- End of API body

Line 1251: FROM AMS_ACT_LISTS

1247: l_api_name;
1248: l_ACT_LIST_HEADER_ID NUMBER;
1249: CURSOR c_Act_List IS
1250: SELECT ACT_LIST_HEADER_ID
1251: FROM AMS_ACT_LISTS
1252: WHERE ACT_LIST_HEADER_ID = p_ACT_LIST_HEADER_ID
1253: AND object_version_number = p_object_version
1254: FOR UPDATE NOWAIT;
1255:

Line 1368: SELECT count(1) FROM ams_act_lists

1364: p_list_act_type VARCHAR,
1365: p_list_header_id NUMBER,
1366: p_act_list_header_id NUMBER)
1367: IS
1368: SELECT count(1) FROM ams_act_lists
1369: WHERE list_used_by_id = p_list_used_by_id
1370: AND list_used_by = p_list_used_by
1371: AND LIST_ACT_TYPE = p_LIST_ACT_TYPE
1372: AND list_header_id = p_list_header_id

Line 1380: 'AMS_ACT_LISTS',

1376: BEGIN
1377: x_return_status := FND_API.g_ret_sts_success;
1378: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1379: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
1380: 'AMS_ACT_LISTS',
1381: 'ACT_LIST_HEADER_ID = ' || p_act_list_rec.ACT_LIST_HEADER_ID
1382: ||' AND LIST_ACT_TYPE = ' ||''''|| p_act_list_rec.LIST_ACT_TYPE||''''
1383: );
1384: ELSE

Line 1386: 'AMS_ACT_LISTS',

1382: ||' AND LIST_ACT_TYPE = ' ||''''|| p_act_list_rec.LIST_ACT_TYPE||''''
1383: );
1384: ELSE
1385: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
1386: 'AMS_ACT_LISTS',
1387: 'ACT_LIST_HEADER_ID = ' || p_act_list_rec.ACT_LIST_HEADER_ID
1388: ||' AND LIST_ACT_TYPE = ' ||''''|| p_act_list_rec.LIST_ACT_TYPE||''''
1389: ||' AND ACT_LIST_HEADER_ID <> ' || p_act_list_rec.ACT_LIST_HEADER_ID
1390: );

Line 1402: 'ams_act_lists',

1398: END IF;
1399:
1400: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1401: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
1402: 'ams_act_lists',
1403: 'list_used_by_id = ' || p_act_list_rec.list_used_by_id||
1404: ' and list_used_by = '||''''||p_act_list_rec.list_used_by||''''
1405: ||' AND LIST_ACT_TYPE = ' || ''''||p_act_list_rec.LIST_ACT_TYPE||''''
1406: ||' and list_header_id = '||p_act_list_rec.list_header_id

Line 1411: 'ams_act_lists',

1407: ) ;
1408: ELSE
1409: /* dmvincen BUG 3792776: Too many variables for auto binding.
1410: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
1411: 'ams_act_lists',
1412: 'list_used_by_id = ' || p_act_list_rec.list_used_by_id||
1413: ' and list_used_by = '||''''||p_act_list_rec.list_used_by||''''
1414: ||' AND LIST_ACT_TYPE = ' || ''''||p_act_list_rec.LIST_ACT_TYPE||''''
1415: ||' and list_header_id = '||p_act_list_rec.list_header_id

Line 1933: from ams_act_lists

1929: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_Act_List_PVT';
1930: l_count number;
1931: cursor c1 is
1932: select count(1)
1933: from ams_act_lists
1934: where list_used_by = p_list_used_by
1935: and list_used_by_id = p_list_used_by_id
1936: and list_act_type = 'TARGET' ;
1937:

Line 2573: from ams_act_lists acl,ams_list_headers_all al

2569: select al.list_header_id,
2570: al.ctrl_random_pct_row_selection,
2571: al.ctrl_random_nth_row_selection,
2572: al.generate_control_group_flag, al.generation_type
2573: from ams_act_lists acl,ams_list_headers_all al
2574: where acl.list_used_by = p_list_used_by
2575: and acl.list_used_by_id = p_list_used_by_id
2576: and acl.list_act_type = 'TARGET'
2577: and al.list_header_id = acl.list_header_id ;

Line 2586: from ams_act_lists

2582: l_generate_control_group_flag varchar2(1);
2583:
2584: cursor c2 is
2585: select list_header_id
2586: from ams_act_lists
2587: where list_used_by = p_list_used_by
2588: and list_used_by_id = p_list_used_by_id
2589: and list_act_type <> 'TARGET' ;
2590:

Line 2599: from ams_act_lists acl

2595: cursor c_get_act is
2596: select acl.list_act_type,
2597: acl.list_header_id,
2598: acl.list_used_by_id, acl.act_list_header_id
2599: from ams_act_lists acl
2600: where acl.list_used_by = p_list_used_by
2601: and acl.list_used_by_id = p_list_used_by_id
2602: and acl.list_act_type = 'CELL' ;
2603: l_list_act_type_02 varchar2(30);

Line 3029: from ams_act_lists acl,ams_list_headers_all al

3025: x_msg_data OUT NOCOPY VARCHAR2
3026: ) is
3027: cursor c1 is
3028: select al.list_header_id
3029: from ams_act_lists acl,ams_list_headers_all al
3030: where acl.list_used_by = p_list_used_by
3031: and acl.list_used_by_id = p_list_used_by_id
3032: and acl.list_act_type = 'TARGET'
3033: and al.list_header_id = acl.list_header_id ;

Line 3038: from ams_act_lists acl

3034:
3035: l_cell_id number;
3036: cursor check_cell is
3037: select acl.list_header_id
3038: from ams_act_lists acl
3039: where acl.list_used_by = p_list_used_by
3040: and acl.list_used_by_id = p_list_used_by_id
3041: and acl.list_act_type = 'CELL' ;
3042:

Line 3895: from ams_act_lists a, ams_list_headers_vl b, ams_campaign_schedules_vl c

3891: b.CTRL_CONF_LEVEL, b.CTRL_REQ_RESP_RATE, b.CTRL_LIMIT_OF_ERROR, b.STATUS_CODE_OLD, b.CTRL_CONC_JOB_ID, b.CTRL_STATUS_CODE, b.CTRL_GEN_MODE, b.APPLY_SUPPRESSION_FLAG,
3892: -- end ckapoor R12 copy tg enhancements
3893: c.schedule_name || ' - ' || c.source_code list_name1
3894: ,b.main_random_pct_row_selection,b.row_selection_type,b.no_of_rows_max_requested --rmbhanda bug#4667513
3895: from ams_act_lists a, ams_list_headers_vl b, ams_campaign_schedules_vl c
3896: where a.list_used_by = p_list_used_by
3897: and a.list_used_by_id = p_from_schedule_id
3898: and a.list_act_type = l_list_type
3899: and a.list_header_id = b.list_header_id

Line 3906: from ams_act_lists a

3902:
3903: cursor c_get_target_group_comp is
3904: select a.list_header_id, a.list_used_by, a.list_used_by_id,
3905: a.list_act_type, a.group_code, a.list_action_type, a.order_number
3906: from ams_act_lists a
3907: where a.list_used_by = p_list_used_by
3908: and a.list_used_by_id = p_from_schedule_id
3909: and a.list_act_type <> l_list_type
3910: order by order_number ;