1 PACKAGE AMS_MANUAL_LIST_GEN AS
2 /* $Header: amsvlmls.pls 120.0 2005/05/31 15:07:24 appldev noship $ */
3
4 G_PKG_NAME CONSTANT VARCHAR2(30) := 'AMS_MANUAL_LIST_GEN';
5
6 TYPE primary_key_Tbl_Type is table of number
7 INDEX BY BINARY_INTEGER;
8 TYPE varchar2_Tbl_Type IS TABLE OF varchar2(400)
9 INDEX BY BINARY_INTEGER;
10
11 TYPE child_type IS TABLE OF VARCHAR2(80) INDEX BY BINARY_INTEGER;
12
13 PROCEDURE process_manual_list(
14 p_api_version IN NUMBER,
15 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
16 p_commit IN VARCHAR2 := FND_API.g_false,
17 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
18 x_return_status OUT NOCOPY VARCHAR2,
19 x_msg_count OUT NOCOPY NUMBER,
20 x_msg_data OUT NOCOPY VARCHAR2,
21 p_list_header_id in NUMBER,
22 p_primary_key_tbl IN JTF_NUMBER_TABLE, --primary_key_Tbl_Type ,
23 p_master_type in VARCHAR2,
24 x_added_entry_count OUT NOCOPY NUMBER
25 );
26
27 --Wrapper API added for supporting contact list created from OSO
28 --bug 4348939
29 PROCEDURE process_manual_list(
30 p_api_version IN NUMBER,
31 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
32 p_commit IN VARCHAR2 := FND_API.g_false,
33 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
34 x_return_status OUT NOCOPY VARCHAR2,
35 x_msg_count OUT NOCOPY NUMBER,
36 x_msg_data OUT NOCOPY VARCHAR2,
37 p_list_header_id in NUMBER,
38 p_primary_key_tbl IN JTF_NUMBER_TABLE,--primary_key_Tbl_Type ,
39 p_master_type in VARCHAR2
40 -- , x_added_entry_count OUT NOCOPY NUMBER --- manual entries changes added:musman
41 );
42
43 PROCEDURE process_employee_list(
44 p_api_version IN NUMBER,
45 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
46 p_commit IN VARCHAR2 := FND_API.g_false,
47 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
48 x_return_status OUT NOCOPY VARCHAR2,
49 x_msg_count OUT NOCOPY NUMBER,
50 x_msg_data OUT NOCOPY VARCHAR2,
51 p_list_header_id in NUMBER,
52 p_primary_key_tbl IN primary_key_Tbl_Type ,
53 p_last_name_tbl IN varchar2_Tbl_Type ,
54 p_first_name_tbl IN varchar2_Tbl_Type ,
55 p_email_tbl IN varchar2_Tbl_Type ,
56 p_master_type in VARCHAR2
57 ) ;
58
59 END AMS_MANUAL_LIST_GEN ;