1 PACKAGE EGO_ITEM_LC_IMP_PC_PUB AUTHID CURRENT_USER AS
2 /* $Header: EGOCIPSS.pls 120.0 2005/05/26 22:11:23 appldev noship $ */
3
4 FUNCTION get_master_controlled_status
5 RETURN VARCHAR2;
6
7 FUNCTION get_master_org_status (p_organization_id IN NUMBER)
8 RETURN VARCHAR2;
9
10 FUNCTION get_revision_id (p_inventory_item_id IN NUMBER
11 ,p_organization_id IN NUMBER
12 ,p_revision IN VARCHAR2)
13 RETURN NUMBER;
14
15 -- commented for 3637854
16 /***
17 PROCEDURE Check_Pending_Change_Orders
18 (
19 p_inventory_item_id IN NUMBER
20 ,p_organization_id IN NUMBER
21 ,p_revision_id IN NUMBER
22 ,x_return_status OUT NOCOPY VARCHAR2
23 ,x_msg_data OUT NOCOPY VARCHAR2
24 );
25 ***/
26
27 -- 4052565 added parameter perform_security_check
28 PROCEDURE Create_Pending_Phase_Change
29 (
30 p_api_version IN NUMBER
31 ,p_commit IN VARCHAR2
32 ,p_inventory_item_id IN NUMBER
33 ,p_item_number IN VARCHAR2 DEFAULT NULL
34 ,p_organization_id IN NUMBER
35 ,p_effective_date IN DATE
36 ,p_pending_flag IN VARCHAR2
37 ,p_revision IN VARCHAR2
38 ,p_revision_id IN NUMBER DEFAULT NULL
39 ,p_lifecycle_id IN NUMBER
40 ,p_phase_id IN NUMBER
41 ,p_status_code IN VARCHAR2 DEFAULT NULL
42 ,p_change_id IN NUMBER
43 ,p_change_line_id IN NUMBER
44 ,p_perform_security_check IN VARCHAR2 DEFAULT 'F'
45 ,x_return_status OUT NOCOPY VARCHAR2
46 ,x_errorcode OUT NOCOPY NUMBER
47 ,x_msg_count OUT NOCOPY NUMBER
48 ,x_msg_data OUT NOCOPY VARCHAR2
49 );
50
51 -- 4052565 added parameter perform_security_check
52 PROCEDURE Modify_Pending_Phase_Change
53 (p_api_version IN NUMBER
54 ,p_commit IN VARCHAR2
55 ,p_transaction_type IN VARCHAR2
56 ,p_inventory_item_id IN NUMBER
57 ,p_organization_id IN NUMBER
58 ,p_revision_id IN NUMBER
59 ,p_lifecycle_id IN NUMBER
60 ,p_phase_id IN NUMBER
61 ,p_status_code IN VARCHAR2
62 ,p_change_id IN NUMBER
63 ,p_change_line_id IN NUMBER
64 ,p_effective_date IN DATE
65 ,p_new_effective_date IN DATE
66 ,p_perform_security_check IN VARCHAR2
67 ,x_return_status OUT NOCOPY VARCHAR2
68 ,x_errorcode OUT NOCOPY NUMBER
69 ,x_msg_count OUT NOCOPY NUMBER
70 ,x_msg_data OUT NOCOPY VARCHAR2
71 );
72
73 /***
74 PROCEDURE Delete_Pending_Phase_Change
75 (
76 p_api_version IN NUMBER
77 ,p_commit IN VARCHAR2
78 ,p_inventory_item_id IN NUMBER
79 ,p_organization_id IN NUMBER
80 ,p_change_id IN NUMBER
81 ,p_change_line_id IN NUMBER
82 ,x_return_status OUT NOCOPY VARCHAR2
83 ,x_errorcode OUT NOCOPY NUMBER
84 ,x_msg_count OUT NOCOPY NUMBER
85 ,x_msg_data OUT NOCOPY VARCHAR2
86 );
87 ***/
88
89 PROCEDURE Implement_Pending_Changes_CP
90 (
91 ERRBUF OUT NOCOPY VARCHAR2
92 , RETCODE OUT NOCOPY NUMBER
93 , p_organization_id IN MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE
94 , p_inventory_item_id IN MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE
95 , p_revision_code IN MTL_ITEM_REVISIONS_B.REVISION%TYPE
96 );
97
98 --
99 -- Created as a part of fix for 3371749
100 --
101 -- 4052565 added parameter perform_security_check
102 PROCEDURE Implement_Pending_Changes
103 (
104 p_api_version IN NUMBER
105 , p_commit IN VARCHAR2
106 , p_change_id IN NUMBER
107 , p_change_line_id IN NUMBER
108 , p_perform_security_check IN VARCHAR2 DEFAULT 'F'
109 , x_return_status OUT NOCOPY VARCHAR2
110 , x_errorcode OUT NOCOPY NUMBER
111 , x_msg_count OUT NOCOPY NUMBER
112 , x_msg_data OUT NOCOPY VARCHAR2
113 );
114
115 -- 4052565 added parameter perform_security_check
116 PROCEDURE Implement_Pending_Changes
117 (
118 p_api_version IN NUMBER
119 , p_inventory_item_id IN NUMBER
120 , p_organization_id IN NUMBER
121 , p_revision_id IN NUMBER
122 , p_revision_master_controlled IN VARCHAR2
123 , p_status_master_controlled IN VARCHAR2
124 , p_is_master_org IN VARCHAR2
125 , p_perform_security_check IN VARCHAR2 DEFAULT 'F'
126 , x_return_status OUT NOCOPY VARCHAR2
127 , x_errorcode OUT NOCOPY NUMBER
128 , x_msg_count OUT NOCOPY NUMBER
129 , x_msg_data OUT NOCOPY VARCHAR2
130 );
131
132 END EGO_ITEM_LC_IMP_PC_PUB;