1 PACKAGE AMW_CREATE_LINES_PKG AUTHID CURRENT_USER AS
2 /* $Header: amwcrlns.pls 120.0 2005/05/31 20:21:55 appldev noship $ */
3
4 PROCEDURE CREATE_LINES (
5 P_CHANGE_ID IN NUMBER
6 ,X_RETURN_STATUS OUT NOCOPY VARCHAR2
7 ,X_MSG_COUNT OUT NOCOPY VARCHAR2
8 ,X_MSG_DATA OUT NOCOPY VARCHAR2
9 );
10
11 PROCEDURE CREATE_LINES_RL(
12 P_CHANGE_ID IN NUMBER
13 ,P_PK1 IN NUMBER --PROCESS_ID
14 ,P_PK2 IN NUMBER
15 ,P_PK3 IN NUMBER
16 ,P_PK4 IN NUMBER
17 ,P_PK5 IN NUMBER
18 ,P_ENTITY_NAME IN VARCHAR2 --AMW_REVISION_ETTY for Risk Library Approvals
19 --02.15.2005 npanandi: added below parameter for ProcessApprovalOption parameter value
20 ,p_approval_option in varchar2
21 );
22
23 PROCEDURE CREATE_LINES_ORG (
24 P_CHANGE_ID IN NUMBER
25 ,P_PK1 IN NUMBER --PROCESS_ID
26 ,P_PK2 IN NUMBER --ORGANIZATION_ID
27 ,P_PK3 IN NUMBER
28 ,P_PK4 IN NUMBER
29 ,P_PK5 IN NUMBER
30 ,P_ENTITY_NAME IN VARCHAR2 --NAME not yet seeded
31 --02.15.2005 npanandi: added below parameter for ProcessApprovalOption parameter value
32 ,p_approval_option in varchar2
33 );
34
35 ---01.21.2005 NPANANDI: ADDED BELOW PROCEDURE TO CREATE LINE SUBJECTS
36 PROCEDURE CREATE_SUBJECT_LINES(
37 P_CHANGE_ID IN NUMBER
38 ,P_CHANGE_LINE_ID IN NUMBER
39 ,P_ENTITY_NAME IN VARCHAR2
40 --02.03.2005 npanandi: added pk1 to pk5 to populate for Process/Risk/Ctrl Lines
41 ,p_pk1_value in number
42 ,p_pk2_value in number default null
43 ,p_pk3_value in number default null
44 ,p_pk4_value in number default null
45 ,p_pk5_value in number default null
46 ,P_SUBJECT_LEVEL IN NUMBER);
47
48 ---
49 ---02.03.2005 npanandi: added below method
50 ---
51 PROCEDURE CREATE_CHANGE_REQUEST_LINES(
52 P_CHANGE_ID IN NUMBER
53 ,p_seq_num_incr IN NUMBER
54 ,p_line_type_id IN number
55 ,p_name in varchar2
56 ,p_description in varchar2
57 ,x_change_line_id out nocopy number);
58
59 ---
60 ---02.16.2005 npanandi: added method to check for and insert
61 ---lines of DeleteProcess lineType
62 ---
63 PROCEDURE process_lines(
64 P_CHANGE_ID IN NUMBER
65 ,p_seq_num_incr in number
66 ,p_line_type_id in number
67 ,p_name in varchar2
68 ,p_description in varchar2
69 ,P_ENTITY_NAME1 IN VARCHAR2
70 ,P_ENTITY_NAME2 IN VARCHAR2
71 ,p_pk1_value in number
72 ,p_pk2_value in number default null
73 ,p_pk3_value in number default null
74 ,p_pk4_value in number default null
75 ,p_pk5_value in number default null);
76
77 --
78 --02.15.2004 npanandi: added below function to get lineTypeId
79 --given ChangeMgmtTypeCode, EntityName, ParentEntityName
80 --
81 FUNCTION get_line_type_id(
82 p_change_mgmt_type_code IN varchar2
83 ,p_entity_name in varchar2
84 ,p_parent_entity_name IN VARCHAR2) RETURN number;
85
86 END AMW_CREATE_LINES_PKG;