PACKAGE: APPS.AMS_LISTGENERATION_UTIL_PKG

Source

1 PACKAGE AMS_LISTGENERATION_UTIL_PKG AS
2 /* $Header: amsvlgus.pls 120.3 2006/02/23 01:35:46 bmuthukr noship $*/
3 
4 cancelListGen Exception ;
5 
6 cursor get_status_code(p_list_header_id Number) is
7   select status_code
8   from ams_list_headers_all
9   where list_header_id = p_list_header_id;
10 
11 type spl_preview_count is record
12 (s_no         number,
13  sp_query     varchar2(32767),
14  prv_count    number);
15 
16 type spl_preview_count_tbl is table of spl_preview_count index by binary_integer;
17 
18 split_preview_count_tbl spl_preview_count_tbl;
19 
20 PROCEDURE cancel_list_gen(p_list_header_id in NUMBER,
21                           p_remote_gen in VARCHAR2,
22                           p_remote_gen_list in VARCHAR2,
23                           p_database_link in VARCHAR2,
24                           x_msg_count OUT NOCOPY NUMBER,
25                           x_msg_data OUT NOCOPY VARCHAR2,
26                           x_return_status OUT NOCOPY VARCHAR2);
27 
28 Procedure Delete_List_entries(p_list_header_id in NUMBER,
29                  x_msg_count OUT NOCOPY NUMBER,
30                  x_msg_data OUT NOCOPY VARCHAR2,
31 		 x_return_status out nocopy VARCHAR2);
32 
33 Procedure Update_list_header(p_list_header_id in Number,
34 --			     p_msg_count IN NUMBER,
35 --                           p_msg_data IN VARCHAR2,
36                              x_return_status OUT NOCOPY VARCHAR2);
37 
38 Function getWFItemStatus(p_list_header_id in Number) return VARCHAR2;
39 
40 Function isListCancelling(p_list_header_id in Number) return VARCHAR2;
41 /*PROCEDURE START_CTRL_GRP_PROCESS
42              (p_list_header_id  in  number,
43               p_log_flag           in  varchar2 := 'Y'  ,-- DEFAULT 'Y',
44               x_return_status      OUT NOCOPY VARCHAR2,
45               x_msg_count          OUT NOCOPY NUMBER,
46               x_msg_data           OUT NOCOPY VARCHAR2) ;*/
47 
48 PROCEDURE START_CTRL_GRP_PROCESS
49              (p_list_header_id  in  number);
50 
51 /*PROCEDURE CANCEL_CTRL_GRP_PROCESS
52              (p_list_header_id  in  number,
53               p_log_flag           in  varchar2  := 'Y',
54               x_return_status      OUT NOCOPY VARCHAR2,
55               x_msg_count          OUT NOCOPY NUMBER,
56               x_msg_data           OUT NOCOPY VARCHAR2);*/
57 PROCEDURE CANCEL_CTRL_GRP_PROCESS
58              (p_list_header_id  in  number);
59 
60 --Procedure added by bmuthukr for CR#4886329
61 procedure get_split_preview_count(p_split_preview_count_tbl IN OUT NOCOPY AMS_LISTGENERATION_UTIL_PKG.split_preview_count_tbl%type,
62                                   p_list_header_id          IN NUMBER,
63 				  x_return_status           OUT NOCOPY VARCHAR2,
64                                   x_msg_count               OUT NOCOPY NUMBER,
65                                   x_msg_data                OUT NOCOPY VARCHAR2);
66 
67 END AMS_LISTGENERATION_UTIL_PKG;