APPS.AMS_ADI_MEDIA_PLANNER_PVT dependencies on AMS_ADI_MEDIA_PLANNER

Line 1: PACKAGE BODY ams_adi_media_planner_pvt AS

1: PACKAGE BODY ams_adi_media_planner_pvt AS
2: /* $Header: amsvwmpb.pls 120.3 2005/10/13 11:08:52 dmvincen noship $ */
3: -- ===============================================================
4: -- Package name
5: -- Web ADI Media Planner

Line 28: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AMS_ADI_MEDIA_PLANNER_PVT';

24: AMS_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
25: AMS_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
26: AMS_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
27:
28: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AMS_ADI_MEDIA_PLANNER_PVT';
29:
30: /* ############# Forward Procedure Declarations ################ */
31: PROCEDURE resolve_metrics_from_rec (
32: p_interface_rec IN ams_adi_media_planner%ROWTYPE,

Line 32: p_interface_rec IN ams_adi_media_planner%ROWTYPE,

28: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AMS_ADI_MEDIA_PLANNER_PVT';
29:
30: /* ############# Forward Procedure Declarations ################ */
31: PROCEDURE resolve_metrics_from_rec (
32: p_interface_rec IN ams_adi_media_planner%ROWTYPE,
33: x_actmetric_table OUT NOCOPY actmetrics_tab_t
34: );
35:
36: -- ==========================================================================

Line 103: l_interface_rec ams_adi_media_planner%ROWTYPE;

99: )
100: IS
101: L_API_NAME CONSTANT VARCHAR2(30) := 'load_metrics';
102: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
103: l_interface_rec ams_adi_media_planner%ROWTYPE;
104: l_err_recs AMS_ADI_COMMON_PVT.ams_adi_error_rec_t :=
105: AMS_ADI_COMMON_PVT.ams_adi_error_rec_t();
106: BEGIN
107: IF fnd_api.to_boolean (p_init_msg_list) THEN

Line 122: FROM ams_adi_media_planner

118:
119: BEGIN
120: SELECT *
121: INTO l_interface_rec
122: FROM ams_adi_media_planner
123: WHERE operation_type = 'IMPORT'
124: AND object_type = p_object_type
125: AND object_name = p_object_name
126: AND parent_type = p_parent_type

Line 215: p_media_planner_rec IN ams_adi_media_planner%ROWTYPE,

211: PROCEDURE load_metrics (
212: p_api_version IN NUMBER,
213: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
214: p_commit IN VARCHAR2 := FND_API.g_false,
215: p_media_planner_rec IN ams_adi_media_planner%ROWTYPE,
216: p_err_recs IN OUT NOCOPY AMS_ADI_COMMON_PVT.ams_adi_error_rec_t,
217: x_return_status OUT NOCOPY VARCHAR2,
218: x_msg_count OUT NOCOPY NUMBER,
219: x_msg_data OUT NOCOPY VARCHAR2

Line 447: AMS_UTILITY_PVT.Write_Conc_Log('Private API :AMS_ADI_MEDIA_PLANNER_PVT.LOAD_METRICS. x_return_status = '||x_return_status);

443: ROLLBACK TO LOAD_METRICS_SP;
444: END IF;
445:
446: IF (AMS_DEBUG_HIGH_ON) THEN
447: AMS_UTILITY_PVT.Write_Conc_Log('Private API :AMS_ADI_MEDIA_PLANNER_PVT.LOAD_METRICS. x_return_status = '||x_return_status);
448: END IF;
449:
450: EXCEPTION
451: WHEN fnd_api.G_EXC_ERROR THEN

Line 507: FROM ams_adi_media_planner

503: AMS_ADI_COMMON_PVT.ams_adi_error_rec_t();
504:
505: CURSOR c_interface IS
506: SELECT *
507: FROM ams_adi_media_planner
508: WHERE upload_batch_id = p_upload_batch_id;
509:
510: BEGIN
511: x_retcode := 0; -- 0 is normal end of execution

Line 552: 'AMS_ADI_MEDIA_PLANNER',

548: 'batch id : '||p_upload_batch_id||'. Done load');
549: END IF;
550:
551: AMS_ADI_COMMON_PVT.complete_batch(
552: 'AMS_ADI_MEDIA_PLANNER',
553: p_upload_batch_id,
554: FND_API.G_TRUE,
555: FND_API.G_TRUE,
556: l_err_recs

Line 604: p_interface_rec IN ams_adi_media_planner%ROWTYPE,

600: -- interface.
601: --
602: -- ==========================================================================
603: PROCEDURE resolve_metrics_from_rec (
604: p_interface_rec IN ams_adi_media_planner%ROWTYPE,
605: x_actmetric_table OUT NOCOPY actmetrics_tab_t
606: )
607: IS
608: l_act_metric_rec AMS_ActMetric_PVT.act_metric_rec_type;

Line 1000: DELETE FROM ams_adi_media_planner

996: p_parent_type ||'::'|| p_parent_id);
997: END IF;
998:
999: --Clean up rows for import
1000: DELETE FROM ams_adi_media_planner
1001: WHERE operation_type = 'IMPORT'
1002: AND object_type = p_object_type
1003: AND object_name = p_object_name
1004: AND parent_type = p_parent_type

Line 1011: END ams_adi_media_planner_pvt;

1007: -- COMMIT;
1008:
1009: END;
1010:
1011: END ams_adi_media_planner_pvt;