[Home] [Help]
PACKAGE: APPS.ENG_CHANGE_LINE_UTIL
Source
1 PACKAGE ENG_Change_Line_Util AS
2 /* $Header: ENGUCHLS.pls 120.4 2007/08/14 06:24:50 prgopala ship $ */
3
4
5
6 /****************************************************************************
7 * QUERY ROW
8 *****************************************************************************/
9
10 PROCEDURE Query_Row
11 ( p_line_sequence_number IN NUMBER
12 , p_organization_id IN NUMBER
13 , p_change_notice IN VARCHAR2
14 , p_change_line_name IN VARCHAR2
15 , p_mesg_token_tbl IN Error_Handler.Mesg_Token_Tbl_Type
16 , x_change_line_rec OUT NOCOPY Eng_Eco_Pub.Change_Line_Rec_Type
17 , x_change_line_unexp_rec OUT NOCOPY Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
18 , x_mesg_token_tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
19 , x_return_status OUT NOCOPY VARCHAR2
20 );
21
22
23
24 /****************************************************************************
25 * PERFORM WRITE
26 *****************************************************************************/
27
28 PROCEDURE Perform_Writes
29 ( p_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
30 , p_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
31 , x_mesg_token_tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
32 , x_return_status OUT NOCOPY VARCHAR2
33 ) ;
34
35
36 /****************************************************************************
37 * OTHERS
38 *****************************************************************************/
39
40 PROCEDURE Insert_Row
41 ( p_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
42 , p_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
43 , x_mesg_token_tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
44 , x_return_status OUT NOCOPY VARCHAR2
45 ) ;
46
47
48 PROCEDURE Update_Row
49 ( p_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
50 , p_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
51 , x_mesg_token_tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
52 , x_return_status OUT NOCOPY VARCHAR2
53 ) ;
54
55
56 PROCEDURE Delete_Row
57 ( p_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
58 , p_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
59 , x_mesg_token_tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
60 , x_return_status OUT NOCOPY VARCHAR2
61 ) ;
62
63 PROCEDURE Change_Subjects
64 (
65 p_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
66 , p_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
67 , x_change_subject_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Change_Subject_Unexp_Rec_Type
68 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type -- 4033384
69 , x_return_status IN OUT NOCOPY VARCHAR2
70 );
71
72 -- ****************************************************************** --
73 -- API name : Get_Concatenated_Subjects --
74 -- Type : Public --
75 -- Pre-reqs : None. --
76 -- Function : Gets the concatenated subject value for display --
77 -- Parameters : --
78 -- IN : --
79 -- p_change_id NUMBER Required --
80 -- p_change_line_id NUMBER --
81 -- p_subject_id NUMBER --
82 -- Version : --
83 -- Current version 1.0 --
84 -- Initial version 1.0 --
85 -- --
86 -- Notes : None --
87 -- ****************************************************************** --
88 FUNCTION Get_Concatenated_Subjects (
89 p_change_id NUMBER
90 , p_change_line_id NUMBER
91 , p_subject_id NUMBER
92 ) RETURN VARCHAR2;
93
94 -- Fix to bug no: 6038875
95 FUNCTION Get_Concatenated_Subjects_URL (
96 p_change_id IN NUMBER
97 , p_change_line_id IN NUMBER
98 ) RETURN VARCHAR2;
99
100 END ENG_Change_Line_Util ;
101