2: /* $Header: PAACTNVS.pls 120.1 2005/08/19 16:14:50 mwasowic noship $ */
3:
4: PROCEDURE CREATE_DLV_ACTIONS_IN_BULK
5: (p_api_version IN NUMBER :=1.0
6: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
7: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
8: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
9: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
10: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
3:
4: PROCEDURE CREATE_DLV_ACTIONS_IN_BULK
5: (p_api_version IN NUMBER :=1.0
6: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
7: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
8: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
9: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
10: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
11: ,p_debug_mode IN VARCHAR2 :='N'
4: PROCEDURE CREATE_DLV_ACTIONS_IN_BULK
5: (p_api_version IN NUMBER :=1.0
6: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
7: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
8: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
9: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
10: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
11: ,p_debug_mode IN VARCHAR2 :='N'
12: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5: (p_api_version IN NUMBER :=1.0
6: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
7: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
8: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
9: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
10: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
11: ,p_debug_mode IN VARCHAR2 :='N'
12: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
13: ,p_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
50: ) ;
51:
52: PROCEDURE UPDATE_DLV_ACTIONS_IN_BULK
53: (p_api_version IN NUMBER :=1.0
54: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
55: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
56: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
57: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
58: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
51:
52: PROCEDURE UPDATE_DLV_ACTIONS_IN_BULK
53: (p_api_version IN NUMBER :=1.0
54: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
55: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
56: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
57: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
58: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
59: ,p_debug_mode IN VARCHAR2 :='N'
52: PROCEDURE UPDATE_DLV_ACTIONS_IN_BULK
53: (p_api_version IN NUMBER :=1.0
54: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
55: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
56: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
57: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
58: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
59: ,p_debug_mode IN VARCHAR2 :='N'
60: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
53: (p_api_version IN NUMBER :=1.0
54: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
55: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
56: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
57: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
58: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
59: ,p_debug_mode IN VARCHAR2 :='N'
60: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
61: ,p_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
97: );
98:
99: PROCEDURE DELETE_DLV_ACTIONS_IN_BULK
100: (p_api_version IN NUMBER :=1.0
101: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
102: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
103: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
104: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
105: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
98:
99: PROCEDURE DELETE_DLV_ACTIONS_IN_BULK
100: (p_api_version IN NUMBER :=1.0
101: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
102: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
103: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
104: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
105: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
106: ,p_debug_mode IN VARCHAR2 :='N'
99: PROCEDURE DELETE_DLV_ACTIONS_IN_BULK
100: (p_api_version IN NUMBER :=1.0
101: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
102: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
103: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
104: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
105: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
106: ,p_debug_mode IN VARCHAR2 :='N'
107: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
100: (p_api_version IN NUMBER :=1.0
101: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
102: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
103: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
104: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
105: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
106: ,p_debug_mode IN VARCHAR2 :='N'
107: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
108: ,p_object_type IN PA_LOOKUPS.LOOKUP_CODE%TYPE
116: );
117:
118: PROCEDURE DELETE_DLV_ACTION
119: (p_api_version IN NUMBER :=1.0
120: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
121: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
122: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
123: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
124: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
117:
118: PROCEDURE DELETE_DLV_ACTION
119: (p_api_version IN NUMBER :=1.0
120: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
121: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
122: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
123: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
124: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
125: ,p_debug_mode IN VARCHAR2 :='N'
118: PROCEDURE DELETE_DLV_ACTION
119: (p_api_version IN NUMBER :=1.0
120: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
121: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
122: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
123: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
124: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
125: ,p_debug_mode IN VARCHAR2 :='N'
126: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
119: (p_api_version IN NUMBER :=1.0
120: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
121: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
122: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
123: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
124: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
125: ,p_debug_mode IN VARCHAR2 :='N'
126: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
127: ,p_action_id IN pa_proj_elements.proj_element_id%TYPE
136: ) ;
137:
138: PROCEDURE COPY_ACTIONS
139: (p_api_version IN NUMBER :=1.0
140: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
141: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
142: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
143: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
144: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
137:
138: PROCEDURE COPY_ACTIONS
139: (p_api_version IN NUMBER :=1.0
140: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
141: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
142: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
143: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
144: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
145: ,p_debug_mode IN VARCHAR2 :='N'
138: PROCEDURE COPY_ACTIONS
139: (p_api_version IN NUMBER :=1.0
140: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
141: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
142: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
143: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
144: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
145: ,p_debug_mode IN VARCHAR2 :='N'
146: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
139: (p_api_version IN NUMBER :=1.0
140: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
141: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
142: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
143: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
144: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
145: ,p_debug_mode IN VARCHAR2 :='N'
146: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
147: ,p_source_object_id IN pa_object_relationships.object_id_from2%TYPE
162: ) ;
163:
164: PROCEDURE IS_DELETE_ACTION_ALLOWED
165: (p_api_version IN NUMBER :=1.0
166: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
167: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
168: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
169: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
170: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
163:
164: PROCEDURE IS_DELETE_ACTION_ALLOWED
165: (p_api_version IN NUMBER :=1.0
166: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
167: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
168: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
169: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
170: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
171: ,p_debug_mode IN VARCHAR2 :='N'
164: PROCEDURE IS_DELETE_ACTION_ALLOWED
165: (p_api_version IN NUMBER :=1.0
166: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
167: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
168: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
169: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
170: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
171: ,p_debug_mode IN VARCHAR2 :='N'
172: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
165: (p_api_version IN NUMBER :=1.0
166: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
167: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
168: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
169: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
170: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
171: ,p_debug_mode IN VARCHAR2 :='N'
172: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
173: ,p_action_id IN pa_proj_elements.proj_element_id%TYPE