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