1 PACKAGE ENG_NIR_UTIL_PKG AS
2 /* $Header: ENGNIRS.pls 120.8 2007/07/16 12:11:12 sdarbha ship $ */
3
4 G_ENG_NEW_ITEM_APPROVED CONSTANT NUMBER := 13;
5 G_ENG_NEW_ITEM_SFA CONSTANT NUMBER := 1;
6 G_ENG_NEW_ITEM_REJECTED CONSTANT NUMBER := 14;
7 G_ENG_NEW_ITEM_CANCELLED CONSTANT NUMBER := 5;
8
9 --TYPE G_ENG_TABLE_NUMBER is table of number;
10
11 PROCEDURE set_nir_item_approval_status (
12 p_change_id IN NUMBER,
13 p_approval_status IN NUMBER,
14 x_return_status OUT NOCOPY VARCHAR2,
15 x_msg_count OUT NOCOPY NUMBER,
16 x_msg_data OUT NOCOPY VARCHAR2);
17
18 PROCEDURE Cancel_NIR(
19 p_change_id IN NUMBER,
20 p_org_id IN NUMBER,
21 p_change_notice IN VARCHAR2,
22 p_auto_commit IN VARCHAR2,
23 -- p_item_action IN VARCHAR2 DEFAULT NULL,
24 p_wf_user_id IN NUMBER,
25 p_fnd_user_id IN NUMBER,
26 p_cancel_comments IN VARCHAR2,
27 p_check_security IN BOOLEAN DEFAULT TRUE,
28 x_nir_cancel_status OUT NOCOPY VARCHAR2
29 );
30
31 PROCEDURE Cancel_NIR_FOR_ITEM(
32 p_item_id IN NUMBER,
33 p_org_id IN NUMBER,
34 -- p_item_number IN VARCHAR2,
35 p_auto_commit IN VARCHAR2,
36 -- p_mode IN VARCHAR2,
37 p_wf_user_id IN NUMBER,
38 p_fnd_user_id IN NUMBER,
39 p_cancel_comments IN VARCHAR2,
40 p_check_security IN BOOLEAN DEFAULT TRUE,
41 x_nir_cancel_status OUT NOCOPY VARCHAR2
42 );
43
44 PROCEDURE Delete_Child_Associations(
45 p_parent_icc_id IN NUMBER,
46 p_item_catalog_group_ids IN VARCHAR2,
47 p_route_people_id IN NUMBER DEFAULT NULL,
48 p_attribute_group_id IN NUMBER DEFAULT NULL,
49 p_commit IN VARCHAR2
50 );
51
52 PROCEDURE Create_Child_Associations(
53 p_source_item_catalog_group_id IN VARCHAR2,
54 p_parent_item_catalog_group_id IN VARCHAR2,
55 p_child_item_catalog_group_ids IN VARCHAR2,
56 -- following parameters will be used while calling only when the AG is associated to ICC directly
57 p_route_people_id IN NUMBER DEFAULT NULL,
58 p_attribute_group_id IN NUMBER DEFAULT NULL,
59 p_assoc_creation_date IN DATE DEFAULT NULL,
60 p_assoc_created_by IN NUMBER DEFAULT NULL,
61 p_assoc_last_update_date IN DATE DEFAULT NULL,
62 p_assoc_last_update_login IN NUMBER DEFAULT NULL,
63 p_assoc_last_updated_by IN NUMBER DEFAULT NULL,
64 p_commit IN VARCHAR2
65 );
66
67 PROCEDURE Update_Child_Associations(
68 p_parent_item_catalog_group_id IN VARCHAR2,
69 p_child_item_catalog_group_ids IN VARCHAR2,
70 p_route_people_id IN NUMBER DEFAULT NULL,
71 p_attribute_group_id IN NUMBER DEFAULT NULL,
72 p_route_association_id IN NUMBER,
73 p_commit IN VARCHAR2
74 );
75
76 FUNCTION Tokenize(
77 p_string IN VARCHAR2, -- input string
78 p_start_position IN NUMBER, -- token number
79 p_seperator IN VARCHAR2 DEFAULT ',' -- separator character
80 ) RETURN VARCHAR2;
81
82 PROCEDURE Cancel_NIR_Line_Item(
83 p_change_id NUMBER,
84 p_item_id NUMBER,
85 p_org_id NUMBER,
86 -- p_mode VARCHAR2, -- (DELETE/CHANGE_ICC)
87 p_wf_user_id IN NUMBER,
88 p_fnd_user_id IN NUMBER,
89 p_cancel_comments IN VARCHAR2,
90 p_commit IN VARCHAR2 :=FND_API.G_FALSE,
91 x_return_status OUT NOCOPY VARCHAR2
92 );
93
94 PROCEDURE Update_Item_Approval_Status (
95 p_change_id IN NUMBER,
96 p_change_line_id IN NUMBER,
97 p_approval_status IN NUMBER,
98 x_return_status OUT NOCOPY VARCHAR2
99 );
100
101 FUNCTION checkNIRValidForApproval( p_change_id IN NUMBER)
102 return boolean;
103
104 PROCEDURE Update_Line_Items_App_St(
105 p_change_id IN NUMBER,
106 p_item_approval_status IN NUMBER,
107 x_sfa_line_items_exists OUT NOCOPY VARCHAR2
108 );
109
110 END ENG_NIR_UTIL_PKG;