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_ADI_CAMP_SCHED_PVT dependencies on AMS_ADI_CAMPAIGNS_INTERFACE

Line 4: type onameArray is table of ams_adi_campaigns_interface.object_name%type index by binary_integer;

1: PACKAGE BODY AMS_ADI_CAMP_SCHED_PVT AS
2: /* $Header: amsvadsb.pls 120.5 2006/03/14 03:00:27 mayjain noship $ */
3:
4: type onameArray is table of ams_adi_campaigns_interface.object_name%type index by binary_integer;
5: type oidArray is table of ams_adi_campaigns_interface.object_id%type index by binary_integer;
6: type scodeArray is table of ams_adi_campaigns_interface.source_code%type index by binary_integer;
7: type dateArray is table of ams_adi_campaigns_interface.start_date%type index by binary_integer;
8: type timeArray is table of ams_adi_campaigns_interface.start_time%type index by binary_integer;

Line 5: type oidArray is table of ams_adi_campaigns_interface.object_id%type index by binary_integer;

1: PACKAGE BODY AMS_ADI_CAMP_SCHED_PVT AS
2: /* $Header: amsvadsb.pls 120.5 2006/03/14 03:00:27 mayjain noship $ */
3:
4: type onameArray is table of ams_adi_campaigns_interface.object_name%type index by binary_integer;
5: type oidArray is table of ams_adi_campaigns_interface.object_id%type index by binary_integer;
6: type scodeArray is table of ams_adi_campaigns_interface.source_code%type index by binary_integer;
7: type dateArray is table of ams_adi_campaigns_interface.start_date%type index by binary_integer;
8: type timeArray is table of ams_adi_campaigns_interface.start_time%type index by binary_integer;
9: type objectiveArray is table of ams_adi_campaigns_interface.objective%type index by binary_integer;

Line 6: type scodeArray is table of ams_adi_campaigns_interface.source_code%type index by binary_integer;

2: /* $Header: amsvadsb.pls 120.5 2006/03/14 03:00:27 mayjain noship $ */
3:
4: type onameArray is table of ams_adi_campaigns_interface.object_name%type index by binary_integer;
5: type oidArray is table of ams_adi_campaigns_interface.object_id%type index by binary_integer;
6: type scodeArray is table of ams_adi_campaigns_interface.source_code%type index by binary_integer;
7: type dateArray is table of ams_adi_campaigns_interface.start_date%type index by binary_integer;
8: type timeArray is table of ams_adi_campaigns_interface.start_time%type index by binary_integer;
9: type objectiveArray is table of ams_adi_campaigns_interface.objective%type index by binary_integer;
10: type lookupCodeArray is table of ams_adi_campaigns_interface.approval_action_code%type index by binary_integer;

Line 7: type dateArray is table of ams_adi_campaigns_interface.start_date%type index by binary_integer;

3:
4: type onameArray is table of ams_adi_campaigns_interface.object_name%type index by binary_integer;
5: type oidArray is table of ams_adi_campaigns_interface.object_id%type index by binary_integer;
6: type scodeArray is table of ams_adi_campaigns_interface.source_code%type index by binary_integer;
7: type dateArray is table of ams_adi_campaigns_interface.start_date%type index by binary_integer;
8: type timeArray is table of ams_adi_campaigns_interface.start_time%type index by binary_integer;
9: type objectiveArray is table of ams_adi_campaigns_interface.objective%type index by binary_integer;
10: type lookupCodeArray is table of ams_adi_campaigns_interface.approval_action_code%type index by binary_integer;
11: type flexAttrArray is table of ams_adi_campaigns_interface.attribute1%type index by binary_integer;

Line 8: type timeArray is table of ams_adi_campaigns_interface.start_time%type index by binary_integer;

4: type onameArray is table of ams_adi_campaigns_interface.object_name%type index by binary_integer;
5: type oidArray is table of ams_adi_campaigns_interface.object_id%type index by binary_integer;
6: type scodeArray is table of ams_adi_campaigns_interface.source_code%type index by binary_integer;
7: type dateArray is table of ams_adi_campaigns_interface.start_date%type index by binary_integer;
8: type timeArray is table of ams_adi_campaigns_interface.start_time%type index by binary_integer;
9: type objectiveArray is table of ams_adi_campaigns_interface.objective%type index by binary_integer;
10: type lookupCodeArray is table of ams_adi_campaigns_interface.approval_action_code%type index by binary_integer;
11: type flexAttrArray is table of ams_adi_campaigns_interface.attribute1%type index by binary_integer;
12: type flexContextArray is table of ams_adi_campaigns_interface.attribute_category%type index by binary_integer;

Line 9: type objectiveArray is table of ams_adi_campaigns_interface.objective%type index by binary_integer;

5: type oidArray is table of ams_adi_campaigns_interface.object_id%type index by binary_integer;
6: type scodeArray is table of ams_adi_campaigns_interface.source_code%type index by binary_integer;
7: type dateArray is table of ams_adi_campaigns_interface.start_date%type index by binary_integer;
8: type timeArray is table of ams_adi_campaigns_interface.start_time%type index by binary_integer;
9: type objectiveArray is table of ams_adi_campaigns_interface.objective%type index by binary_integer;
10: type lookupCodeArray is table of ams_adi_campaigns_interface.approval_action_code%type index by binary_integer;
11: type flexAttrArray is table of ams_adi_campaigns_interface.attribute1%type index by binary_integer;
12: type flexContextArray is table of ams_adi_campaigns_interface.attribute_category%type index by binary_integer;
13: /* types added by mayjain */

Line 10: type lookupCodeArray is table of ams_adi_campaigns_interface.approval_action_code%type index by binary_integer;

6: type scodeArray is table of ams_adi_campaigns_interface.source_code%type index by binary_integer;
7: type dateArray is table of ams_adi_campaigns_interface.start_date%type index by binary_integer;
8: type timeArray is table of ams_adi_campaigns_interface.start_time%type index by binary_integer;
9: type objectiveArray is table of ams_adi_campaigns_interface.objective%type index by binary_integer;
10: type lookupCodeArray is table of ams_adi_campaigns_interface.approval_action_code%type index by binary_integer;
11: type flexAttrArray is table of ams_adi_campaigns_interface.attribute1%type index by binary_integer;
12: type flexContextArray is table of ams_adi_campaigns_interface.attribute_category%type index by binary_integer;
13: /* types added by mayjain */
14: type notesArray is table of ams_adi_campaigns_interface.notes%type index by binary_integer;

Line 11: type flexAttrArray is table of ams_adi_campaigns_interface.attribute1%type index by binary_integer;

7: type dateArray is table of ams_adi_campaigns_interface.start_date%type index by binary_integer;
8: type timeArray is table of ams_adi_campaigns_interface.start_time%type index by binary_integer;
9: type objectiveArray is table of ams_adi_campaigns_interface.objective%type index by binary_integer;
10: type lookupCodeArray is table of ams_adi_campaigns_interface.approval_action_code%type index by binary_integer;
11: type flexAttrArray is table of ams_adi_campaigns_interface.attribute1%type index by binary_integer;
12: type flexContextArray is table of ams_adi_campaigns_interface.attribute_category%type index by binary_integer;
13: /* types added by mayjain */
14: type notesArray is table of ams_adi_campaigns_interface.notes%type index by binary_integer;
15: type puwsArray is table of ams_adi_campaigns_interface.pretty_url_website%type index by binary_integer;

Line 12: type flexContextArray is table of ams_adi_campaigns_interface.attribute_category%type index by binary_integer;

8: type timeArray is table of ams_adi_campaigns_interface.start_time%type index by binary_integer;
9: type objectiveArray is table of ams_adi_campaigns_interface.objective%type index by binary_integer;
10: type lookupCodeArray is table of ams_adi_campaigns_interface.approval_action_code%type index by binary_integer;
11: type flexAttrArray is table of ams_adi_campaigns_interface.attribute1%type index by binary_integer;
12: type flexContextArray is table of ams_adi_campaigns_interface.attribute_category%type index by binary_integer;
13: /* types added by mayjain */
14: type notesArray is table of ams_adi_campaigns_interface.notes%type index by binary_integer;
15: type puwsArray is table of ams_adi_campaigns_interface.pretty_url_website%type index by binary_integer;
16: type wptitleArray is table of ams_adi_campaigns_interface.wp_placement_title%type index by binary_integer;

Line 14: type notesArray is table of ams_adi_campaigns_interface.notes%type index by binary_integer;

10: type lookupCodeArray is table of ams_adi_campaigns_interface.approval_action_code%type index by binary_integer;
11: type flexAttrArray is table of ams_adi_campaigns_interface.attribute1%type index by binary_integer;
12: type flexContextArray is table of ams_adi_campaigns_interface.attribute_category%type index by binary_integer;
13: /* types added by mayjain */
14: type notesArray is table of ams_adi_campaigns_interface.notes%type index by binary_integer;
15: type puwsArray is table of ams_adi_campaigns_interface.pretty_url_website%type index by binary_integer;
16: type wptitleArray is table of ams_adi_campaigns_interface.wp_placement_title%type index by binary_integer;
17: type ctdAhParamArray is table of ams_adi_campaigns_interface.ctd_adhoc_param1%type index by binary_integer;
18: type ctdAhParamValArray is table of ams_adi_campaigns_interface.ctd_adhoc_param_val1%type index by binary_integer;

Line 15: type puwsArray is table of ams_adi_campaigns_interface.pretty_url_website%type index by binary_integer;

11: type flexAttrArray is table of ams_adi_campaigns_interface.attribute1%type index by binary_integer;
12: type flexContextArray is table of ams_adi_campaigns_interface.attribute_category%type index by binary_integer;
13: /* types added by mayjain */
14: type notesArray is table of ams_adi_campaigns_interface.notes%type index by binary_integer;
15: type puwsArray is table of ams_adi_campaigns_interface.pretty_url_website%type index by binary_integer;
16: type wptitleArray is table of ams_adi_campaigns_interface.wp_placement_title%type index by binary_integer;
17: type ctdAhParamArray is table of ams_adi_campaigns_interface.ctd_adhoc_param1%type index by binary_integer;
18: type ctdAhParamValArray is table of ams_adi_campaigns_interface.ctd_adhoc_param_val1%type index by binary_integer;
19: /* types added by mayjain */

Line 16: type wptitleArray is table of ams_adi_campaigns_interface.wp_placement_title%type index by binary_integer;

12: type flexContextArray is table of ams_adi_campaigns_interface.attribute_category%type index by binary_integer;
13: /* types added by mayjain */
14: type notesArray is table of ams_adi_campaigns_interface.notes%type index by binary_integer;
15: type puwsArray is table of ams_adi_campaigns_interface.pretty_url_website%type index by binary_integer;
16: type wptitleArray is table of ams_adi_campaigns_interface.wp_placement_title%type index by binary_integer;
17: type ctdAhParamArray is table of ams_adi_campaigns_interface.ctd_adhoc_param1%type index by binary_integer;
18: type ctdAhParamValArray is table of ams_adi_campaigns_interface.ctd_adhoc_param_val1%type index by binary_integer;
19: /* types added by mayjain */
20:

Line 17: type ctdAhParamArray is table of ams_adi_campaigns_interface.ctd_adhoc_param1%type index by binary_integer;

13: /* types added by mayjain */
14: type notesArray is table of ams_adi_campaigns_interface.notes%type index by binary_integer;
15: type puwsArray is table of ams_adi_campaigns_interface.pretty_url_website%type index by binary_integer;
16: type wptitleArray is table of ams_adi_campaigns_interface.wp_placement_title%type index by binary_integer;
17: type ctdAhParamArray is table of ams_adi_campaigns_interface.ctd_adhoc_param1%type index by binary_integer;
18: type ctdAhParamValArray is table of ams_adi_campaigns_interface.ctd_adhoc_param_val1%type index by binary_integer;
19: /* types added by mayjain */
20:
21:

Line 18: type ctdAhParamValArray is table of ams_adi_campaigns_interface.ctd_adhoc_param_val1%type index by binary_integer;

14: type notesArray is table of ams_adi_campaigns_interface.notes%type index by binary_integer;
15: type puwsArray is table of ams_adi_campaigns_interface.pretty_url_website%type index by binary_integer;
16: type wptitleArray is table of ams_adi_campaigns_interface.wp_placement_title%type index by binary_integer;
17: type ctdAhParamArray is table of ams_adi_campaigns_interface.ctd_adhoc_param1%type index by binary_integer;
18: type ctdAhParamValArray is table of ams_adi_campaigns_interface.ctd_adhoc_param_val1%type index by binary_integer;
19: /* types added by mayjain */
20:
21:
22:

Line 53: -- Updates Campaign Schedules based on Web ADI input in staging table AMS_ADI_CAMPAIGNS_INTERFACE

49: --========================================================================
50: -- PROCEDURE
51: -- Updates Campaign Schedules from Web ADI
52: -- Purpose
53: -- Updates Campaign Schedules based on Web ADI input in staging table AMS_ADI_CAMPAIGNS_INTERFACE
54: -- The algorithm is as follows :
55: -- 1. call AMS_ADI_COMMON_PVT.init
56: -- 2. BULK COLLECT data from staging table in batches of AMS_ADI_COMMON_PVT.g_batch_size(set as 100). Then for
57: -- each batch do the following :

Line 96: from ams_adi_campaigns_interface a, ams_media_b b

92: a.activity_attribute1,a.activity_attribute2,a.activity_attribute3,a.activity_attribute4,a.activity_attribute5,
93: a.activity_attribute6,a.activity_attribute7,a.activity_attribute8,a.activity_attribute9,a.activity_attribute10,
94: a.activity_attribute11,a.activity_attribute12,a.activity_attribute13,a.activity_attribute14,a.activity_attribute15,
95: a.activity_attribute_category,a.object_version_number,a.currency_code,a.actual_activity_id,b.media_type_code
96: from ams_adi_campaigns_interface a, ams_media_b b
97: where a.upload_batch_id = l_upload_batch_id
98: and a.actual_activity_id = b.media_id(+)
99: and b.enabled_flag(+) = 'Y';
100:

Line 176: AMS_UTILITY_PVT.debug_message('Start to read feom ams_adi_campaigns_interface with limit '||AMS_ADI_COMMON_PVT.g_batch_size);

172: AMS_ADI_COMMON_PVT.init();
173:
174: -- Debug Message
175: IF (AMS_DEBUG_HIGH_ON) THEN
176: AMS_UTILITY_PVT.debug_message('Start to read feom ams_adi_campaigns_interface with limit '||AMS_ADI_COMMON_PVT.g_batch_size);
177: END IF;
178:
179: open c(p_upload_batch_id);
180:

Line 381: 'AMS_ADI_CAMPAIGNS_INTERFACE',

377: AMS_UTILITY_PVT.debug_message('Calling Complete batch');
378: END IF;
379:
380: AMS_ADI_COMMON_PVT.complete_batch(
381: 'AMS_ADI_CAMPAIGNS_INTERFACE',
382: p_upload_batch_id,
383: FND_API.G_TRUE,
384: FND_API.G_FALSE, -- do not need COMMIT for batches as well
385: l_error_recs

Line 542: -- Imports New Campaign Schedules based on Web ADI input in staging table AMS_ADI_CAMPAIGNS_INTERFACE

538: --========================================================================
539: -- PROCEDURE
540: -- Imports New Campaign Schedules from Web ADI
541: -- Purpose
542: -- Imports New Campaign Schedules based on Web ADI input in staging table AMS_ADI_CAMPAIGNS_INTERFACE
543: -- The algorithm is as follows :
544: -- 1. call AMS_ADI_COMMON_PVT.init
545: -- 2. BULK COLLECT data from staging table in batches of AMS_ADI_COMMON_PVT.g_batch_size(set as 100). Then for
546: -- each batch do the following :

Line 616: AMS_ADI_CAMPAIGNS_INTERFACE

612: activity_attribute6, activity_attribute7, activity_attribute8, activity_attribute9, activity_attribute10,
613: activity_attribute11, activity_attribute12, activity_attribute13, activity_attribute14, activity_attribute15
614: --last_update_date, last_updated_by, creation_date, created_by, last_update_login
615: FROM
616: AMS_ADI_CAMPAIGNS_INTERFACE
617: where
618: upload_batch_id = l_upload_batch_id and
619: operation_status = 'NEW' and
620: operation_type = 'IMPORT' and

Line 737: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||'Start to read from ams_adi_campaigns_interface with limit '||AMS_ADI_COMMON_PVT.g_batch_size);

733: AMS_ADI_COMMON_PVT.init();
734:
735: -- Debug Message
736: IF (AMS_DEBUG_HIGH_ON) THEN
737: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||'Start to read from ams_adi_campaigns_interface with limit '||AMS_ADI_COMMON_PVT.g_batch_size);
738: END IF;
739:
740: OPEN C_IMPORT_BATCH(p_upload_batch_id);
741: LOOP -- C_IMPORT_BATCH loop

Line 798: AMS_ADI_CAMPAIGNS_INTERFACE

794: BEGIN
795: SELECT
796: 1 into l_temp_num
797: FROM
798: AMS_ADI_CAMPAIGNS_INTERFACE
799: WHERE
800: upload_batch_id = p_upload_batch_id and
801: operation_status = 'NEW' and
802: operation_type = 'IMPORT' and

Line 1798: 'AMS_ADI_CAMPAIGNS_INTERFACE',

1794: END IF;
1795:
1796:
1797: AMS_ADI_COMMON_PVT.complete_batch(
1798: 'AMS_ADI_CAMPAIGNS_INTERFACE',
1799: p_upload_batch_id,
1800: FND_API.G_FALSE,
1801: FND_API.G_TRUE,
1802: l_error_recs