1: PACKAGE AMS_item_section_PVT AUTHID CURRENT_USER AS
2: /* $Header: amsvpses.pls 115.2 2002/07/16 18:08:34 musman noship $*/
3:
4: TYPE section_rec_type IS RECORD (
5: section_id NUMBER := FND_API.G_MISS_NUM
6: ,inventory_item_id NUMBER := FND_API.G_MISS_NUM
7: ,organization_id NUMBER := FND_API.G_MISS_NUM
8: ,start_date DATE := FND_API.G_MISS_DATE
9: ,end_date DATE := FND_API.g_MISS_DATE
2: /* $Header: amsvpses.pls 115.2 2002/07/16 18:08:34 musman noship $*/
3:
4: TYPE section_rec_type IS RECORD (
5: section_id NUMBER := FND_API.G_MISS_NUM
6: ,inventory_item_id NUMBER := FND_API.G_MISS_NUM
7: ,organization_id NUMBER := FND_API.G_MISS_NUM
8: ,start_date DATE := FND_API.G_MISS_DATE
9: ,end_date DATE := FND_API.g_MISS_DATE
10: );
3:
4: TYPE section_rec_type IS RECORD (
5: section_id NUMBER := FND_API.G_MISS_NUM
6: ,inventory_item_id NUMBER := FND_API.G_MISS_NUM
7: ,organization_id NUMBER := FND_API.G_MISS_NUM
8: ,start_date DATE := FND_API.G_MISS_DATE
9: ,end_date DATE := FND_API.g_MISS_DATE
10: );
11:
4: TYPE section_rec_type IS RECORD (
5: section_id NUMBER := FND_API.G_MISS_NUM
6: ,inventory_item_id NUMBER := FND_API.G_MISS_NUM
7: ,organization_id NUMBER := FND_API.G_MISS_NUM
8: ,start_date DATE := FND_API.G_MISS_DATE
9: ,end_date DATE := FND_API.g_MISS_DATE
10: );
11:
12:
5: section_id NUMBER := FND_API.G_MISS_NUM
6: ,inventory_item_id NUMBER := FND_API.G_MISS_NUM
7: ,organization_id NUMBER := FND_API.G_MISS_NUM
8: ,start_date DATE := FND_API.G_MISS_DATE
9: ,end_date DATE := FND_API.g_MISS_DATE
10: );
11:
12:
13: ---------------------------------------------------------------------
18:
19: PROCEDURE create_item_sec_assoc
20: (
21: p_api_version IN NUMBER,
22: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
23: p_commit IN VARCHAR2 := FND_API.g_false,
24: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
25:
26: x_return_status OUT VARCHAR2,
19: PROCEDURE create_item_sec_assoc
20: (
21: p_api_version IN NUMBER,
22: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
23: p_commit IN VARCHAR2 := FND_API.g_false,
24: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
25:
26: x_return_status OUT VARCHAR2,
27: x_msg_count OUT NUMBER,
20: (
21: p_api_version IN NUMBER,
22: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
23: p_commit IN VARCHAR2 := FND_API.g_false,
24: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
25:
26: x_return_status OUT VARCHAR2,
27: x_msg_count OUT NUMBER,
28: x_msg_data OUT VARCHAR2,
40:
41: PROCEDURE delete_item_sec_assoc
42: (
43: p_api_version IN NUMBER,
44: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
45: p_commit IN VARCHAR2 := FND_API.g_false,
46: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
47:
48: x_return_status OUT VARCHAR2,
41: PROCEDURE delete_item_sec_assoc
42: (
43: p_api_version IN NUMBER,
44: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
45: p_commit IN VARCHAR2 := FND_API.g_false,
46: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
47:
48: x_return_status OUT VARCHAR2,
49: x_msg_count OUT NUMBER,
42: (
43: p_api_version IN NUMBER,
44: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
45: p_commit IN VARCHAR2 := FND_API.g_false,
46: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
47:
48: x_return_status OUT VARCHAR2,
49: x_msg_count OUT NUMBER,
50: x_msg_data OUT VARCHAR2,