1 PACKAGE IBE_DSP_SECTION_ITEM_PVT AS
2 /* $Header: IBEVCISS.pls 120.0 2005/05/30 02:46:55 appldev noship $ */
3
4 -- HISTORY
5 -- 12/12/02 SCHAK Modified for NOCOPY (Bug # 2691704) and Debug (Bug # 2691710) Changes.
6 -- **********************************************************************************************************
7
8 PROCEDURE insert_row
9 (
10 p_section_item_id IN NUMBER,
11 p_object_version_number IN NUMBER,
12 p_section_id IN NUMBER,
13 p_inventory_item_id IN NUMBER,
14 p_organization_id IN NUMBER,
15 p_start_date_active IN DATE,
16 p_end_date_active IN DATE,
17 p_usage_name IN VARCHAR2,
18 p_sort_order IN NUMBER,
19 p_association_reason_code IN VARCHAR2,
20 p_creation_date IN DATE,
21 p_created_by IN NUMBER,
22 p_last_update_date IN DATE,
23 p_last_updated_by IN NUMBER,
24 p_last_update_login IN NUMBER,
25 x_rowid OUT NOCOPY VARCHAR2,
26 x_section_item_id OUT NOCOPY NUMBER
27 );
28
29 PROCEDURE update_row
30 (
31 p_section_item_id IN NUMBER,
32 p_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
33 p_start_date_active IN DATE,
34 p_end_date_active IN DATE,
35 p_usage_name IN VARCHAR2,
36 p_sort_order IN NUMBER,
37 p_association_reason_code IN VARCHAR2,
38 p_last_update_date IN DATE,
39 p_last_updated_by IN NUMBER,
40 p_last_update_login IN NUMBER
41 );
42
43 PROCEDURE delete_row
44 (
45 p_section_item_id IN NUMBER
46 );
47
48 PROCEDURE Create_Section_Item
49 (
50 p_api_version IN NUMBER,
51 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
52 p_commit IN VARCHAR2 := FND_API.G_FALSE,
53 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
54 p_section_id IN NUMBER,
55 p_inventory_item_id IN NUMBER,
56 p_organization_id IN NUMBER,
57 p_start_date_active IN DATE,
58 p_end_date_active IN DATE := FND_API.G_MISS_DATE,
59 p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
60 p_association_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
61 x_section_item_id OUT NOCOPY NUMBER,
62 x_return_status OUT NOCOPY VARCHAR2,
63 x_msg_count OUT NOCOPY NUMBER,
64 x_msg_data OUT NOCOPY VARCHAR2
65 );
66
67 PROCEDURE Update_Section_Item
68 (
69 p_api_version IN NUMBER,
70 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
71 p_commit IN VARCHAR2 := FND_API.G_FALSE,
72 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
73 p_section_item_id IN NUMBER := FND_API.G_MISS_NUM,
74 p_object_version_number IN NUMBER,
75 p_section_id IN NUMBER := FND_API.G_MISS_NUM,
76 p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM,
77 p_organization_id IN NUMBER := FND_API.G_MISS_NUM,
78 p_start_date_active IN DATE := FND_API.G_MISS_DATE,
79 p_end_date_active IN DATE := FND_API.G_MISS_DATE,
80 p_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
81 p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
82 p_association_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
83 x_return_status OUT NOCOPY VARCHAR2,
84 x_msg_count OUT NOCOPY NUMBER,
85 x_msg_data OUT NOCOPY VARCHAR2
86 );
87
88 PROCEDURE Delete_Section_Item
89 (
90 p_api_version IN NUMBER,
91 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
92 p_commit IN VARCHAR2 := FND_API.G_FALSE,
93 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
94 p_call_from_trigger IN BOOLEAN := FALSE,
95 p_section_item_id IN NUMBER := FND_API.G_MISS_NUM,
96 p_section_id IN NUMBER := FND_API.G_MISS_NUM,
97 p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM,
98 p_organization_id IN NUMBER := FND_API.G_MISS_NUM,
99 x_return_status OUT NOCOPY VARCHAR2,
100 x_msg_count OUT NOCOPY NUMBER,
101 x_msg_data OUT NOCOPY VARCHAR2
102 );
103
104 PROCEDURE Delete_Section_Items_For_Item
105 (
106 p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM,
107 p_organization_id IN NUMBER := FND_API.G_MISS_NUM
108 );
109
110 PROCEDURE Update_Delete_Sct_Itms
111 (
112 p_api_version IN NUMBER,
113 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
114 p_commit IN VARCHAR2 := FND_API.G_FALSE,
115 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
116 p_section_item_ids IN JTF_NUMBER_TABLE,
117 p_object_version_numbers IN JTF_NUMBER_TABLE,
118 p_start_date_actives IN JTF_DATE_TABLE,
119 p_end_date_actives IN JTF_DATE_TABLE,
120 p_usage_names IN JTF_VARCHAR2_TABLE_300,
121 p_sort_orders IN JTF_NUMBER_TABLE,
122 p_association_reason_codes IN JTF_VARCHAR2_TABLE_300,
123 p_delete_flags IN JTF_VARCHAR2_TABLE_300,
124 x_return_status OUT NOCOPY VARCHAR2,
125 x_msg_count OUT NOCOPY NUMBER,
126 x_msg_data OUT NOCOPY VARCHAR2
127 );
128
129 END IBE_DSP_SECTION_ITEM_PVT;