[Home] [Help]
PACKAGE: APPS.AMS_EVENT_OBJECTS_COPY_PVT
Source
1 PACKAGE AMS_Event_Objects_Copy_PVT AUTHID CURRENT_USER as
2 /* $Header: amsveocs.pls 115.12 2004/03/05 07:05:14 vmodur 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 G_ATTRIBUTE_EVEO CONSTANT VARCHAR2(30) := 'EVEO';
12 G_ATTRIBUTE_PTNR CONSTANT VARCHAR2(30) := 'PTNR';-- already
13 G_ATTRIBUTE_CPNT CONSTANT VARCHAR2(30) := 'CPNT';
14 G_ATTRIBUTE_DELV CONSTANT VARCHAR2(30) := 'DELV';
15 PROCEDURE copy_event_header (
16 p_api_version IN NUMBER,
17 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
18 p_commit IN VARCHAR2 := FND_API.G_FALSE,
19 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
20 x_return_status OUT NOCOPY VARCHAR2,
21 x_msg_count OUT NOCOPY NUMBER,
22 x_msg_data OUT NOCOPY VARCHAR2,
23 p_source_object_id IN NUMBER,
24 p_attributes_table IN AMS_CpyUtility_PVT.copy_attributes_table_type,
25 p_copy_columns_table IN AMS_CpyUtility_PVT.copy_columns_table_type,
26 x_new_object_id OUT NOCOPY NUMBER,
27 x_custom_setup_id OUT NOCOPY NUMBER
28 );
29
30 PROCEDURE copy_event_header_agenda (
31 p_src_act_type IN VARCHAR2,
32 p_new_act_type IN VARCHAR2 := NULL,
33 p_src_act_id IN NUMBER,
34 p_new_act_id IN NUMBER,
35 p_errnum OUT NOCOPY NUMBER,
36 p_errcode OUT NOCOPY VARCHAR2,
37 p_errmsg OUT NOCOPY VARCHAR2
38 );
39 PROCEDURE copy_act_offers (
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
45 -- p_new_start_date IN DATE,
46 -- p_new_end_date IN DATE,
47
48 p_errnum OUT NOCOPY NUMBER,
49 p_errcode OUT NOCOPY VARCHAR2,
50 p_errmsg OUT NOCOPY VARCHAR2
51 );
52 PROCEDURE copy_act_delivery_method (
53 p_src_act_type IN VARCHAR2,
54 p_new_act_type IN VARCHAR2 := NULL,
55 p_src_act_id IN NUMBER,
56 p_new_act_id IN NUMBER,
57 p_errnum OUT NOCOPY NUMBER,
58 p_errcode OUT NOCOPY VARCHAR2,
59 p_errmsg OUT NOCOPY VARCHAR2
60 );
61 FUNCTION get_agenda_name(p_agenda_id IN NUMBER)
62 RETURN VARCHAR2;
63 FUNCTION get_offer_name(p_offer_id IN NUMBER)
64 RETURN VARCHAR2;
65 END AMS_Event_Objects_Copy_PVT;