54: , end_date
55: , wrap_up_level
56: ) VALUES (
57: x_wrap_id
58: , DECODE(x_object_version_number,FND_API.G_MISS_NUM,NULL,x_object_version_number)
59: , DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
60: , DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
61: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
62: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
55: , wrap_up_level
56: ) VALUES (
57: x_wrap_id
58: , DECODE(x_object_version_number,FND_API.G_MISS_NUM,NULL,x_object_version_number)
59: , DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
60: , DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
61: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
62: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
63: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
56: ) VALUES (
57: x_wrap_id
58: , DECODE(x_object_version_number,FND_API.G_MISS_NUM,NULL,x_object_version_number)
59: , DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
60: , DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
61: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
62: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
63: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
64: , DECODE(x_outcome_required,FND_API.G_MISS_CHAR,NULL,x_outcome_required)
57: x_wrap_id
58: , DECODE(x_object_version_number,FND_API.G_MISS_NUM,NULL,x_object_version_number)
59: , DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
60: , DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
61: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
62: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
63: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
64: , DECODE(x_outcome_required,FND_API.G_MISS_CHAR,NULL,x_outcome_required)
65: , DECODE(x_result_required,FND_API.G_MISS_CHAR,NULL,x_result_required)
58: , DECODE(x_object_version_number,FND_API.G_MISS_NUM,NULL,x_object_version_number)
59: , DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
60: , DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
61: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
62: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
63: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
64: , DECODE(x_outcome_required,FND_API.G_MISS_CHAR,NULL,x_outcome_required)
65: , DECODE(x_result_required,FND_API.G_MISS_CHAR,NULL,x_result_required)
66: , DECODE(x_reason_required,FND_API.G_MISS_CHAR,NULL,x_reason_required)
59: , DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
60: , DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
61: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
62: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
63: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
64: , DECODE(x_outcome_required,FND_API.G_MISS_CHAR,NULL,x_outcome_required)
65: , DECODE(x_result_required,FND_API.G_MISS_CHAR,NULL,x_result_required)
66: , DECODE(x_reason_required,FND_API.G_MISS_CHAR,NULL,x_reason_required)
67: , DECODE(x_result_id,FND_API.G_MISS_NUM,NULL,x_result_id)
60: , DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
61: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
62: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
63: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
64: , DECODE(x_outcome_required,FND_API.G_MISS_CHAR,NULL,x_outcome_required)
65: , DECODE(x_result_required,FND_API.G_MISS_CHAR,NULL,x_result_required)
66: , DECODE(x_reason_required,FND_API.G_MISS_CHAR,NULL,x_reason_required)
67: , DECODE(x_result_id,FND_API.G_MISS_NUM,NULL,x_result_id)
68: , DECODE(x_reason_id,FND_API.G_MISS_NUM,NULL,x_reason_id)
61: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
62: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
63: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
64: , DECODE(x_outcome_required,FND_API.G_MISS_CHAR,NULL,x_outcome_required)
65: , DECODE(x_result_required,FND_API.G_MISS_CHAR,NULL,x_result_required)
66: , DECODE(x_reason_required,FND_API.G_MISS_CHAR,NULL,x_reason_required)
67: , DECODE(x_result_id,FND_API.G_MISS_NUM,NULL,x_result_id)
68: , DECODE(x_reason_id,FND_API.G_MISS_NUM,NULL,x_reason_id)
69: , DECODE(x_outcome_id,FND_API.G_MISS_NUM,NULL,x_outcome_id)
62: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
63: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
64: , DECODE(x_outcome_required,FND_API.G_MISS_CHAR,NULL,x_outcome_required)
65: , DECODE(x_result_required,FND_API.G_MISS_CHAR,NULL,x_result_required)
66: , DECODE(x_reason_required,FND_API.G_MISS_CHAR,NULL,x_reason_required)
67: , DECODE(x_result_id,FND_API.G_MISS_NUM,NULL,x_result_id)
68: , DECODE(x_reason_id,FND_API.G_MISS_NUM,NULL,x_reason_id)
69: , DECODE(x_outcome_id,FND_API.G_MISS_NUM,NULL,x_outcome_id)
70: , DECODE(x_action_activity_id,FND_API.G_MISS_NUM,NULL,x_action_activity_id)
63: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
64: , DECODE(x_outcome_required,FND_API.G_MISS_CHAR,NULL,x_outcome_required)
65: , DECODE(x_result_required,FND_API.G_MISS_CHAR,NULL,x_result_required)
66: , DECODE(x_reason_required,FND_API.G_MISS_CHAR,NULL,x_reason_required)
67: , DECODE(x_result_id,FND_API.G_MISS_NUM,NULL,x_result_id)
68: , DECODE(x_reason_id,FND_API.G_MISS_NUM,NULL,x_reason_id)
69: , DECODE(x_outcome_id,FND_API.G_MISS_NUM,NULL,x_outcome_id)
70: , DECODE(x_action_activity_id,FND_API.G_MISS_NUM,NULL,x_action_activity_id)
71: , DECODE(x_object_id,FND_API.G_MISS_NUM,NULL,x_object_id)
64: , DECODE(x_outcome_required,FND_API.G_MISS_CHAR,NULL,x_outcome_required)
65: , DECODE(x_result_required,FND_API.G_MISS_CHAR,NULL,x_result_required)
66: , DECODE(x_reason_required,FND_API.G_MISS_CHAR,NULL,x_reason_required)
67: , DECODE(x_result_id,FND_API.G_MISS_NUM,NULL,x_result_id)
68: , DECODE(x_reason_id,FND_API.G_MISS_NUM,NULL,x_reason_id)
69: , DECODE(x_outcome_id,FND_API.G_MISS_NUM,NULL,x_outcome_id)
70: , DECODE(x_action_activity_id,FND_API.G_MISS_NUM,NULL,x_action_activity_id)
71: , DECODE(x_object_id,FND_API.G_MISS_NUM,NULL,x_object_id)
72: , DECODE(x_object_type,FND_API.G_MISS_CHAR,NULL,x_object_type)
65: , DECODE(x_result_required,FND_API.G_MISS_CHAR,NULL,x_result_required)
66: , DECODE(x_reason_required,FND_API.G_MISS_CHAR,NULL,x_reason_required)
67: , DECODE(x_result_id,FND_API.G_MISS_NUM,NULL,x_result_id)
68: , DECODE(x_reason_id,FND_API.G_MISS_NUM,NULL,x_reason_id)
69: , DECODE(x_outcome_id,FND_API.G_MISS_NUM,NULL,x_outcome_id)
70: , DECODE(x_action_activity_id,FND_API.G_MISS_NUM,NULL,x_action_activity_id)
71: , DECODE(x_object_id,FND_API.G_MISS_NUM,NULL,x_object_id)
72: , DECODE(x_object_type,FND_API.G_MISS_CHAR,NULL,x_object_type)
73: , DECODE(x_source_code_id,FND_API.G_MISS_NUM,NULL,x_source_code_id)
66: , DECODE(x_reason_required,FND_API.G_MISS_CHAR,NULL,x_reason_required)
67: , DECODE(x_result_id,FND_API.G_MISS_NUM,NULL,x_result_id)
68: , DECODE(x_reason_id,FND_API.G_MISS_NUM,NULL,x_reason_id)
69: , DECODE(x_outcome_id,FND_API.G_MISS_NUM,NULL,x_outcome_id)
70: , DECODE(x_action_activity_id,FND_API.G_MISS_NUM,NULL,x_action_activity_id)
71: , DECODE(x_object_id,FND_API.G_MISS_NUM,NULL,x_object_id)
72: , DECODE(x_object_type,FND_API.G_MISS_CHAR,NULL,x_object_type)
73: , DECODE(x_source_code_id,FND_API.G_MISS_NUM,NULL,x_source_code_id)
74: , DECODE(x_source_code,FND_API.G_MISS_CHAR,NULL,x_source_code)
67: , DECODE(x_result_id,FND_API.G_MISS_NUM,NULL,x_result_id)
68: , DECODE(x_reason_id,FND_API.G_MISS_NUM,NULL,x_reason_id)
69: , DECODE(x_outcome_id,FND_API.G_MISS_NUM,NULL,x_outcome_id)
70: , DECODE(x_action_activity_id,FND_API.G_MISS_NUM,NULL,x_action_activity_id)
71: , DECODE(x_object_id,FND_API.G_MISS_NUM,NULL,x_object_id)
72: , DECODE(x_object_type,FND_API.G_MISS_CHAR,NULL,x_object_type)
73: , DECODE(x_source_code_id,FND_API.G_MISS_NUM,NULL,x_source_code_id)
74: , DECODE(x_source_code,FND_API.G_MISS_CHAR,NULL,x_source_code)
75: , DECODE(x_start_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE, x_start_date)
68: , DECODE(x_reason_id,FND_API.G_MISS_NUM,NULL,x_reason_id)
69: , DECODE(x_outcome_id,FND_API.G_MISS_NUM,NULL,x_outcome_id)
70: , DECODE(x_action_activity_id,FND_API.G_MISS_NUM,NULL,x_action_activity_id)
71: , DECODE(x_object_id,FND_API.G_MISS_NUM,NULL,x_object_id)
72: , DECODE(x_object_type,FND_API.G_MISS_CHAR,NULL,x_object_type)
73: , DECODE(x_source_code_id,FND_API.G_MISS_NUM,NULL,x_source_code_id)
74: , DECODE(x_source_code,FND_API.G_MISS_CHAR,NULL,x_source_code)
75: , DECODE(x_start_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE, x_start_date)
76: , x_end_date
69: , DECODE(x_outcome_id,FND_API.G_MISS_NUM,NULL,x_outcome_id)
70: , DECODE(x_action_activity_id,FND_API.G_MISS_NUM,NULL,x_action_activity_id)
71: , DECODE(x_object_id,FND_API.G_MISS_NUM,NULL,x_object_id)
72: , DECODE(x_object_type,FND_API.G_MISS_CHAR,NULL,x_object_type)
73: , DECODE(x_source_code_id,FND_API.G_MISS_NUM,NULL,x_source_code_id)
74: , DECODE(x_source_code,FND_API.G_MISS_CHAR,NULL,x_source_code)
75: , DECODE(x_start_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE, x_start_date)
76: , x_end_date
77: , DECODE(x_wrap_up_level, FND_API.G_MISS_CHAR,'BOTH',NULL,'BOTH',x_wrap_up_level)
70: , DECODE(x_action_activity_id,FND_API.G_MISS_NUM,NULL,x_action_activity_id)
71: , DECODE(x_object_id,FND_API.G_MISS_NUM,NULL,x_object_id)
72: , DECODE(x_object_type,FND_API.G_MISS_CHAR,NULL,x_object_type)
73: , DECODE(x_source_code_id,FND_API.G_MISS_NUM,NULL,x_source_code_id)
74: , DECODE(x_source_code,FND_API.G_MISS_CHAR,NULL,x_source_code)
75: , DECODE(x_start_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE, x_start_date)
76: , x_end_date
77: , DECODE(x_wrap_up_level, FND_API.G_MISS_CHAR,'BOTH',NULL,'BOTH',x_wrap_up_level)
78: );
71: , DECODE(x_object_id,FND_API.G_MISS_NUM,NULL,x_object_id)
72: , DECODE(x_object_type,FND_API.G_MISS_CHAR,NULL,x_object_type)
73: , DECODE(x_source_code_id,FND_API.G_MISS_NUM,NULL,x_source_code_id)
74: , DECODE(x_source_code,FND_API.G_MISS_CHAR,NULL,x_source_code)
75: , DECODE(x_start_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE, x_start_date)
76: , x_end_date
77: , DECODE(x_wrap_up_level, FND_API.G_MISS_CHAR,'BOTH',NULL,'BOTH',x_wrap_up_level)
78: );
79:
73: , DECODE(x_source_code_id,FND_API.G_MISS_NUM,NULL,x_source_code_id)
74: , DECODE(x_source_code,FND_API.G_MISS_CHAR,NULL,x_source_code)
75: , DECODE(x_start_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE, x_start_date)
76: , x_end_date
77: , DECODE(x_wrap_up_level, FND_API.G_MISS_CHAR,'BOTH',NULL,'BOTH',x_wrap_up_level)
78: );
79:
80: OPEN l_insert;
81: FETCH l_insert INTO x_rowid;