1 PACKAGE EGO_INV_ITEM_CATALOG_PVT AS
2 /* $Header: EGOITCCS.pls 120.2 2006/09/20 14:54:51 ninaraya noship $ */
3
4 Procedure Change_Item_Lifecycle(
5 P_INVENTORY_ITEM_ID IN NUMBER,
6 P_ORGANIZATION_ID IN NUMBER,
7 P_NEW_CATALOG_CATEGORY_ID IN NUMBER,
8 P_NEW_LIFECYCLE_ID IN NUMBER,
9 P_NEW_PHASE_ID IN NUMBER,
10 P_NEW_ITEM_STATUS_CODE IN VARCHAR2,
11 P_COMMIT IN VARCHAR2,
12 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
13 X_MSG_COUNT OUT NOCOPY NUMBER,
14 X_MSG_DATA OUT NOCOPY VARCHAR2
15 );
16
17 Procedure Change_Item_Catalog(
18 P_INVENTORY_ITEM_ID IN NUMBER,
19 P_ORGANIZATION_ID IN NUMBER,
20 P_CATALOG_GROUP_ID IN NUMBER,
21 P_NEW_CATALOG_GROUP_ID IN NUMBER,
22 P_NEW_LIFECYCLE_ID IN NUMBER,
23 P_NEW_PHASE_ID IN NUMBER,
24 P_NEW_ITEM_STATUS_CODE IN VARCHAR2,
25 P_NEW_APPROVAL_STATUS IN VARCHAR2 DEFAULT NULL,
26 P_COMMIT IN VARCHAR2,
27 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
28 X_MSG_COUNT OUT NOCOPY NUMBER,
29 X_MSG_DATA OUT NOCOPY VARCHAR2
30 );
31
32 Procedure Validate_And_Change_Item_LC (
33 p_api_version IN NUMBER
34 ,p_commit IN VARCHAR2
35 ,p_inventory_item_id IN NUMBER
36 ,p_item_revision_id IN NUMBER
37 ,p_organization_id IN NUMBER
38 ,p_fetch_curr_values IN VARCHAR2
39 ,p_curr_cc_id IN NUMBER
40 ,p_new_cc_id IN NUMBER
41 ,p_is_new_cc_in_hier IN VARCHAR2
42 ,p_curr_lc_id IN NUMBER
43 ,p_new_lc_id IN NUMBER
44 ,p_curr_lcp_id IN NUMBER
45 ,p_new_lcp_id IN NUMBER
46 ,p_change_id IN NUMBER
47 ,p_change_line_id IN NUMBER
48 ,x_return_status OUT NOCOPY VARCHAR2
49 ,x_msg_count OUT NOCOPY NUMBER
50 ,x_msg_data OUT NOCOPY VARCHAR2
51 );
52
53 Procedure Change_Item_LC_Dependecies
54 (p_api_version IN NUMBER
55 ,p_inventory_item_id IN NUMBER
56 ,p_organization_id IN NUMBER
57 ,p_item_revision_id IN NUMBER
58 ,p_lifecycle_id IN NUMBER
59 ,p_lifecycle_phase_id IN NUMBER
60 ,p_lifecycle_changed IN VARCHAR2
61 ,p_lifecycle_phase_changed IN VARCHAR2
62 ,p_perform_sync_only IN VARCHAR2
63 ,p_new_cc_in_hier IN BOOLEAN := FALSE
64 ,x_return_status OUT NOCOPY VARCHAR2
65 ,x_msg_count OUT NOCOPY NUMBER
66 ,x_msg_data OUT NOCOPY VARCHAR2
67 );
68
69 PROCEDURE Create_phase_History_Record (
70 p_api_version IN NUMBER
71 ,p_commit IN VARCHAR2
72 ,p_inventory_item_id IN NUMBER
73 ,p_organization_id IN NUMBER
74 ,p_revision_id IN NUMBER
75 ,p_lifecycle_id IN VARCHAR2
76 ,p_lifecycle_phase_id IN VARCHAR2
77 ,p_item_status_code IN VARCHAR2
78 ,x_return_status OUT NOCOPY VARCHAR2
79 ,x_msg_count OUT NOCOPY NUMBER
80 ,x_msg_data OUT NOCOPY VARCHAR2
81 );
82
83 PROCEDURE Check_pending_Change_Orders (
84 p_inventory_item_id IN NUMBER
85 ,p_organization_id IN NUMBER
86 ,p_revision_id IN NUMBER
87 ,p_lifecycle_changed IN VARCHAR2
88 ,p_lifecycle_phase_changed IN VARCHAR2
89 ,p_change_id IN NUMBER
90 ,p_change_line_id IN NUMBER
91 ,x_return_status OUT NOCOPY VARCHAR2
92 ,x_msg_count OUT NOCOPY NUMBER
93 ,x_msg_data OUT NOCOPY VARCHAR2
94 );
95
96 END EGO_INV_ITEM_CATALOG_PVT;