DBA Data[Home] [Help]

PACKAGE: APPS.AMS_EVENTSCHEDULE_COPY_PVT

Source


1 PACKAGE AMS_EventSchedule_Copy_PVT AUTHID CURRENT_USER as
2 /*$Header: amsvescs.pls 115.16 2003/05/16 20:33:51 dbiswas ship $*/
3 
4     G_ATTRIBUTE_DETL  CONSTANT VARCHAR2(30) := 'DETL';-- already
5     G_ATTRIBUTE_PROD    CONSTANT VARCHAR2(30) := 'PROD';-- already there
6     G_ATTRIBUTE_CATG     CONSTANT VARCHAR2(30) := 'CATG';-- already
7     G_ATTRIBUTE_ATCH      CONSTANT VARCHAR2(30) := 'ATCH';-- already
8     G_ATTRIBUTE_MESG     CONSTANT VARCHAR2(30) := 'MESG';-- already
9     G_ATTRIBUTE_RESC   CONSTANT VARCHAR2(30) := 'RESC';-- already
10     G_ATTRIBUTE_AGEN   CONSTANT VARCHAR2(30) := 'AGEN';
11 
12     G_ATTRIBUTE_PTNR    CONSTANT VARCHAR2(30) := 'PTNR';-- already
13     G_ATTRIBUTE_CPNT    CONSTANT VARCHAR2(30) := 'CPNT';
14 PROCEDURE copy_event_schedule(
15    p_api_version        IN NUMBER,
16    p_init_msg_list      IN VARCHAR2 := FND_API.G_FALSE,
17    p_commit             IN VARCHAR2 := FND_API.G_FALSE,
18    p_validation_level   IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
19    x_return_status      OUT NOCOPY VARCHAR2,
20    x_msg_count          OUT NOCOPY NUMBER,
21    x_msg_data           OUT NOCOPY VARCHAR2,
22    p_source_object_id   IN NUMBER,
23    p_attributes_table   IN AMS_CpyUtility_PVT.copy_attributes_table_type,
24    p_copy_columns_table IN AMS_CpyUtility_PVT.copy_columns_table_type,
25    x_new_object_id      OUT NOCOPY NUMBER,
26    x_custom_setup_id    OUT NOCOPY NUMBER
27 );
28 
29    PROCEDURE copy_event_schedule_agenda (
30       p_src_act_type   IN       VARCHAR2,
31       p_new_act_type   IN       VARCHAR2 := NULL,
32       p_src_act_id     IN       NUMBER,
33       p_new_act_id     IN       NUMBER,
34       p_errnum         OUT NOCOPY NUMBER,
35       p_errcode        OUT NOCOPY VARCHAR2,
36       p_errmsg         OUT NOCOPY VARCHAR2
37    );
38 
39 PROCEDURE copy_act_delivery_method (
40       p_src_act_type   IN       VARCHAR2,
41       p_new_act_type   IN       VARCHAR2 := NULL,
42       p_src_act_id     IN       NUMBER,
43       p_new_act_id     IN       NUMBER,
44       p_errnum         OUT NOCOPY      NUMBER,
45       p_errcode        OUT NOCOPY      VARCHAR2,
46       p_errmsg         OUT NOCOPY      VARCHAR2
47    );
48 FUNCTION get_agenda_name(p_agenda_id IN NUMBER)
49       RETURN VARCHAR2;
50 END AMS_EventSchedule_Copy_PVT;