1 PACKAGE pon_clm_clo_util_pkg AUTHID CURRENT_USER AS
2 --$Header: PONCLOUTILS.pls 120.11.12020000.2 2013/02/09 09:23:38 hvutukur ship $
3 /*======================================================================
4 PROCEDURE : delete_single_line
5 PARAMETERS: 1. x_result - return status.
6 2. x_error_code - error code
7 3. x_error_message - The actual error message
8 4. p_auction_header_id - The auction header id
9 5. p_line_number - The line to be deleted
10 number for this line
11 COMMENT : This procedure will delete the given line. iT WILL ALSO DELETE ALL THE OPTIONS OF THE GIVEN LINE
12 If it is a clin, THEN ALL THE slins WILL ALSO BE DELETED.
13 ======================================================================*/
14
15 PROCEDURE delete_single_line (
16 x_result OUT NOCOPY VARCHAR2,
17 x_error_code OUT NOCOPY VARCHAR2,
18 x_error_message OUT NOCOPY VARCHAR2,
19 p_auction_header_id IN NUMBER,
20 p_line_number IN NUMBER,
21 p_delete_linked_option IN VARCHAR2 DEFAULT 'Y',
22 x_number_of_lines_deleted IN OUT NOCOPY NUMBER);
23
24 --This procedure is called while creating an option for either a slin or a clin
25 -- this willl first copy the base line and create a new line
26 -- later user willl be forwarded to edit line of this new option line
27 -- where user will give option related information
28 PROCEDURE copy_and_create_option(p_auction_header_id IN NUMBER,
29 p_src_line_number IN NUMBER,
30 x_new_line_number OUT NOCOPY NUMBER,
31 x_result OUT NOCOPY VARCHAR2,
32 x_error_code OUT NOCOPY VARCHAR2,
33 x_error_message OUT NOCOPY VARCHAR2
34 );
35
36 /*
37 This procdure will copy a clin or slin.
38 If it is a clin, the whole hierarchy will be copied.
39 */
40 PROCEDURE copy_clin(p_auction_header_id IN NUMBER,
41 p_src_line_number IN NUMBER,
42 x_max_line_number IN OUT NOCOPY NUMBER,
43 x_result OUT NOCOPY VARCHAR2,
44 x_error_code OUT NOCOPY VARCHAR2,
45 x_error_message OUT NOCOPY VARCHAR2
46 );
47
48
49
50 PROCEDURE POPULATE_CROSSLINK_MAP(p_auction_header_id IN NUMBER,
51 x_option_num OUT NOCOPY PO_TBL_NUMBER,
52 x_base_num OUT NOCOPY PO_TBL_NUMBER) ;
53
54 PROCEDURE SEND_LINE_DELETED_NOTIF(p_caller IN VARCHAR2,
55 p_document_id IN NUMBER,
56 p_document_line_id IN NUMBER,
57 x_return_status OUT NOCOPY VARCHAR2,
58 x_msg_count OUT NOCOPY NUMBER,
59 x_msg_data OUT NOCOPY VARCHAR2
60 );
61
62 PROCEDURE copy_lines(p_auction_header_id IN NUMBER,
63 p_src_line_numbers IN PO_TBL_NUMBER,
64 p_user_pref IN copy_user_preferences,
65 x_max_line_number OUT NOCOPY NUMBER,
66 x_result OUT NOCOPY VARCHAR2,
67 x_error_code OUT NOCOPY VARCHAR2,
68 x_error_message OUT NOCOPY VARCHAR2) ;
69
70 PROCEDURE redefault_tx(x_need_by_date IN OUT NOCOPY DATE,
71 x_pop_start_date IN OUT NOCOPY DATE ,
72 x_pop_end_date IN OUT NOCOPY DATE ,
73 x_option_from_date IN OUT NOCOPY DATE,
74 x_option_to_date IN OUT NOCOPY DATE,
75 x_clm_option_num IN OUT NOCOPY NUMBER,
76 x_clm_option_indicator IN OUT NOCOPY VARCHAR2,
77 x_clm_info_flag IN OUT NOCOPY VARCHAR2,
78 p_user_pref IN copy_user_preferences) ;
79 Function calculatedates(
80 p_user_date IN DATE,
81 p_unit IN VARCHAR2,
82 p_incr_value IN NUMBER,
83 p_flag IN BOOLEAN) RETURN date;
84
85
86
87 END PON_CLM_CLO_UTIL_PKG;