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,
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,
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,
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,
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,
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,
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
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,
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,
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,
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,
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,
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,
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,
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,
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,
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
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,
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,
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,
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,
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,
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
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: );
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
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: (
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,
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,
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,