2: /* $Header: PACIACPS.pls 120.0 2005/06/03 13:30:35 appldev noship $ */
3:
4: PROCEDURE CREATE_CI_ACTION (
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_max_msg_count IN NUMBER := FND_API.g_miss_num,
10: P_CI_ACTION_ID out NOCOPY NUMBER,
3:
4: PROCEDURE CREATE_CI_ACTION (
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_max_msg_count IN NUMBER := FND_API.g_miss_num,
10: P_CI_ACTION_ID out NOCOPY NUMBER,
11: P_CI_ID in NUMBER DEFAULT FND_API.G_MISS_NUM,
4: PROCEDURE CREATE_CI_ACTION (
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_max_msg_count IN NUMBER := FND_API.g_miss_num,
10: P_CI_ACTION_ID out NOCOPY NUMBER,
11: P_CI_ID in NUMBER DEFAULT FND_API.G_MISS_NUM,
12: P_TYPE_CODE in VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
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_max_msg_count IN NUMBER := FND_API.g_miss_num,
10: P_CI_ACTION_ID out NOCOPY NUMBER,
11: P_CI_ID in NUMBER DEFAULT FND_API.G_MISS_NUM,
12: P_TYPE_CODE in VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
13: P_ASSIGNED_TO in NUMBER DEFAULT FND_API.G_MISS_NUM,
7: p_commit IN VARCHAR2 := FND_API.g_false,
8: p_validate_only IN VARCHAR2 := FND_API.g_true,
9: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
10: P_CI_ACTION_ID out NOCOPY NUMBER,
11: P_CI_ID in NUMBER DEFAULT FND_API.G_MISS_NUM,
12: P_TYPE_CODE in VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
13: P_ASSIGNED_TO in NUMBER DEFAULT FND_API.G_MISS_NUM,
14: P_RESOURCE_TYPE_ID in NUMBER DEFAULT FND_API.G_MISS_NUM,
15: P_ASSIGNED_TO_NAME in VARCHAR DEFAULT FND_API.G_MISS_CHAR,
8: p_validate_only IN VARCHAR2 := FND_API.g_true,
9: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
10: P_CI_ACTION_ID out NOCOPY NUMBER,
11: P_CI_ID in NUMBER DEFAULT FND_API.G_MISS_NUM,
12: P_TYPE_CODE in VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
13: P_ASSIGNED_TO in NUMBER DEFAULT FND_API.G_MISS_NUM,
14: P_RESOURCE_TYPE_ID in NUMBER DEFAULT FND_API.G_MISS_NUM,
15: P_ASSIGNED_TO_NAME in VARCHAR DEFAULT FND_API.G_MISS_CHAR,
16: P_DATE_REQUIRED in DATE DEFAULT FND_API.G_MISS_DATE,
9: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
10: P_CI_ACTION_ID out NOCOPY NUMBER,
11: P_CI_ID in NUMBER DEFAULT FND_API.G_MISS_NUM,
12: P_TYPE_CODE in VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
13: P_ASSIGNED_TO in NUMBER DEFAULT FND_API.G_MISS_NUM,
14: P_RESOURCE_TYPE_ID in NUMBER DEFAULT FND_API.G_MISS_NUM,
15: P_ASSIGNED_TO_NAME in VARCHAR DEFAULT FND_API.G_MISS_CHAR,
16: P_DATE_REQUIRED in DATE DEFAULT FND_API.G_MISS_DATE,
17: P_SIGN_OFF_REQUIRED_FLAG in VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
10: P_CI_ACTION_ID out NOCOPY NUMBER,
11: P_CI_ID in NUMBER DEFAULT FND_API.G_MISS_NUM,
12: P_TYPE_CODE in VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
13: P_ASSIGNED_TO in NUMBER DEFAULT FND_API.G_MISS_NUM,
14: P_RESOURCE_TYPE_ID in NUMBER DEFAULT FND_API.G_MISS_NUM,
15: P_ASSIGNED_TO_NAME in VARCHAR DEFAULT FND_API.G_MISS_CHAR,
16: P_DATE_REQUIRED in DATE DEFAULT FND_API.G_MISS_DATE,
17: P_SIGN_OFF_REQUIRED_FLAG in VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
18: P_COMMENT_TEXT in VARCHAR2,
11: P_CI_ID in NUMBER DEFAULT FND_API.G_MISS_NUM,
12: P_TYPE_CODE in VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
13: P_ASSIGNED_TO in NUMBER DEFAULT FND_API.G_MISS_NUM,
14: P_RESOURCE_TYPE_ID in NUMBER DEFAULT FND_API.G_MISS_NUM,
15: P_ASSIGNED_TO_NAME in VARCHAR DEFAULT FND_API.G_MISS_CHAR,
16: P_DATE_REQUIRED in DATE DEFAULT FND_API.G_MISS_DATE,
17: P_SIGN_OFF_REQUIRED_FLAG in VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
18: P_COMMENT_TEXT in VARCHAR2,
19: P_SOURCE_CI_ACTION_ID in NUMBER DEFAULT FND_API.G_MISS_NUM,
12: P_TYPE_CODE in VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
13: P_ASSIGNED_TO in NUMBER DEFAULT FND_API.G_MISS_NUM,
14: P_RESOURCE_TYPE_ID in NUMBER DEFAULT FND_API.G_MISS_NUM,
15: P_ASSIGNED_TO_NAME in VARCHAR DEFAULT FND_API.G_MISS_CHAR,
16: P_DATE_REQUIRED in DATE DEFAULT FND_API.G_MISS_DATE,
17: P_SIGN_OFF_REQUIRED_FLAG in VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
18: P_COMMENT_TEXT in VARCHAR2,
19: P_SOURCE_CI_ACTION_ID in NUMBER DEFAULT FND_API.G_MISS_NUM,
20: P_CREATED_BY in NUMBER default fnd_global.user_id,
13: P_ASSIGNED_TO in NUMBER DEFAULT FND_API.G_MISS_NUM,
14: P_RESOURCE_TYPE_ID in NUMBER DEFAULT FND_API.G_MISS_NUM,
15: P_ASSIGNED_TO_NAME in VARCHAR DEFAULT FND_API.G_MISS_CHAR,
16: P_DATE_REQUIRED in DATE DEFAULT FND_API.G_MISS_DATE,
17: P_SIGN_OFF_REQUIRED_FLAG in VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
18: P_COMMENT_TEXT in VARCHAR2,
19: P_SOURCE_CI_ACTION_ID in NUMBER DEFAULT FND_API.G_MISS_NUM,
20: P_CREATED_BY in NUMBER default fnd_global.user_id,
21: P_CREATION_DATE in DATE default sysdate,
15: P_ASSIGNED_TO_NAME in VARCHAR DEFAULT FND_API.G_MISS_CHAR,
16: P_DATE_REQUIRED in DATE DEFAULT FND_API.G_MISS_DATE,
17: P_SIGN_OFF_REQUIRED_FLAG in VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
18: P_COMMENT_TEXT in VARCHAR2,
19: P_SOURCE_CI_ACTION_ID in NUMBER DEFAULT FND_API.G_MISS_NUM,
20: P_CREATED_BY in NUMBER default fnd_global.user_id,
21: P_CREATION_DATE in DATE default sysdate,
22: P_LAST_UPDATED_BY in NUMBER default fnd_global.user_id,
23: P_LAST_UPDATE_DATE in DATE default sysdate,
27: x_msg_data OUT NOCOPY VARCHAR2
28: );
29: PROCEDURE CANCEL_CI_ACTION (
30: p_api_version IN NUMBER := 1.0,
31: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
32: p_commit IN VARCHAR2 := FND_API.g_false,
33: p_validate_only IN VARCHAR2 := FND_API.g_true,
34: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
35: P_CI_ACTION_ID in NUMBER DEFAULT FND_API.G_MISS_NUM,
28: );
29: PROCEDURE CANCEL_CI_ACTION (
30: p_api_version IN NUMBER := 1.0,
31: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
32: p_commit IN VARCHAR2 := FND_API.g_false,
33: p_validate_only IN VARCHAR2 := FND_API.g_true,
34: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
35: P_CI_ACTION_ID in NUMBER DEFAULT FND_API.G_MISS_NUM,
36: P_RECORD_VERSION_NUMBER in NUMBER,
29: PROCEDURE CANCEL_CI_ACTION (
30: p_api_version IN NUMBER := 1.0,
31: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
32: p_commit IN VARCHAR2 := FND_API.g_false,
33: p_validate_only IN VARCHAR2 := FND_API.g_true,
34: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
35: P_CI_ACTION_ID in NUMBER DEFAULT FND_API.G_MISS_NUM,
36: P_RECORD_VERSION_NUMBER in NUMBER,
37: P_CANCEL_COMMENT in VARCHAR2,
30: p_api_version IN NUMBER := 1.0,
31: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
32: p_commit IN VARCHAR2 := FND_API.g_false,
33: p_validate_only IN VARCHAR2 := FND_API.g_true,
34: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
35: P_CI_ACTION_ID in NUMBER DEFAULT FND_API.G_MISS_NUM,
36: P_RECORD_VERSION_NUMBER in NUMBER,
37: P_CANCEL_COMMENT in VARCHAR2,
38: P_LAST_UPDATED_BY in NUMBER default fnd_global.user_id,
31: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
32: p_commit IN VARCHAR2 := FND_API.g_false,
33: p_validate_only IN VARCHAR2 := FND_API.g_true,
34: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
35: P_CI_ACTION_ID in NUMBER DEFAULT FND_API.G_MISS_NUM,
36: P_RECORD_VERSION_NUMBER in NUMBER,
37: P_CANCEL_COMMENT in VARCHAR2,
38: P_LAST_UPDATED_BY in NUMBER default fnd_global.user_id,
39: P_LAST_UPDATE_DATE in DATE default sysdate,
43: x_msg_data OUT NOCOPY VARCHAR2);
44:
45: PROCEDURE CLOSE_CI_ACTION (
46: p_api_version IN NUMBER := 1.0,
47: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
48: p_commit IN VARCHAR2 := FND_API.g_false,
49: p_validate_only IN VARCHAR2 := FND_API.g_true,
50: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
51: P_CI_ACTION_ID in NUMBER DEFAULT FND_API.G_MISS_NUM,
44:
45: PROCEDURE CLOSE_CI_ACTION (
46: p_api_version IN NUMBER := 1.0,
47: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
48: p_commit IN VARCHAR2 := FND_API.g_false,
49: p_validate_only IN VARCHAR2 := FND_API.g_true,
50: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
51: P_CI_ACTION_ID in NUMBER DEFAULT FND_API.G_MISS_NUM,
52: P_SIGN_OFF_FLAG in VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
45: PROCEDURE CLOSE_CI_ACTION (
46: p_api_version IN NUMBER := 1.0,
47: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
48: p_commit IN VARCHAR2 := FND_API.g_false,
49: p_validate_only IN VARCHAR2 := FND_API.g_true,
50: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
51: P_CI_ACTION_ID in NUMBER DEFAULT FND_API.G_MISS_NUM,
52: P_SIGN_OFF_FLAG in VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
53: P_RECORD_VERSION_NUMBER in NUMBER DEFAULT FND_API.G_MISS_NUM,
46: p_api_version IN NUMBER := 1.0,
47: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
48: p_commit IN VARCHAR2 := FND_API.g_false,
49: p_validate_only IN VARCHAR2 := FND_API.g_true,
50: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
51: P_CI_ACTION_ID in NUMBER DEFAULT FND_API.G_MISS_NUM,
52: P_SIGN_OFF_FLAG in VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
53: P_RECORD_VERSION_NUMBER in NUMBER DEFAULT FND_API.G_MISS_NUM,
54: P_COMMENT_TEXT in VARCHAR2,
47: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
48: p_commit IN VARCHAR2 := FND_API.g_false,
49: p_validate_only IN VARCHAR2 := FND_API.g_true,
50: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
51: P_CI_ACTION_ID in NUMBER DEFAULT FND_API.G_MISS_NUM,
52: P_SIGN_OFF_FLAG in VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
53: P_RECORD_VERSION_NUMBER in NUMBER DEFAULT FND_API.G_MISS_NUM,
54: P_COMMENT_TEXT in VARCHAR2,
55: P_LAST_UPDATED_BY in NUMBER default fnd_global.user_id,
48: p_commit IN VARCHAR2 := FND_API.g_false,
49: p_validate_only IN VARCHAR2 := FND_API.g_true,
50: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
51: P_CI_ACTION_ID in NUMBER DEFAULT FND_API.G_MISS_NUM,
52: P_SIGN_OFF_FLAG in VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
53: P_RECORD_VERSION_NUMBER in NUMBER DEFAULT FND_API.G_MISS_NUM,
54: P_COMMENT_TEXT in VARCHAR2,
55: P_LAST_UPDATED_BY in NUMBER default fnd_global.user_id,
56: P_LAST_UPDATE_DATE in DATE default sysdate,
49: p_validate_only IN VARCHAR2 := FND_API.g_true,
50: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
51: P_CI_ACTION_ID in NUMBER DEFAULT FND_API.G_MISS_NUM,
52: P_SIGN_OFF_FLAG in VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
53: P_RECORD_VERSION_NUMBER in NUMBER DEFAULT FND_API.G_MISS_NUM,
54: P_COMMENT_TEXT in VARCHAR2,
55: P_LAST_UPDATED_BY in NUMBER default fnd_global.user_id,
56: P_LAST_UPDATE_DATE in DATE default sysdate,
57: P_LAST_UPDATE_LOGIN in NUMBER default fnd_global.user_id,
61: );
62:
63: PROCEDURE REASSIGN_CI_ACTION (
64: p_api_version IN NUMBER := 1.0,
65: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
66: p_commit IN VARCHAR2 := FND_API.g_false,
67: p_validate_only IN VARCHAR2 := FND_API.g_true,
68: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
69: P_CI_ACTION_ID in NUMBER DEFAULT FND_API.G_MISS_NUM,
62:
63: PROCEDURE REASSIGN_CI_ACTION (
64: p_api_version IN NUMBER := 1.0,
65: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
66: p_commit IN VARCHAR2 := FND_API.g_false,
67: p_validate_only IN VARCHAR2 := FND_API.g_true,
68: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
69: P_CI_ACTION_ID in NUMBER DEFAULT FND_API.G_MISS_NUM,
70: P_SIGN_OFF_FLAG in VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
63: PROCEDURE REASSIGN_CI_ACTION (
64: p_api_version IN NUMBER := 1.0,
65: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
66: p_commit IN VARCHAR2 := FND_API.g_false,
67: p_validate_only IN VARCHAR2 := FND_API.g_true,
68: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
69: P_CI_ACTION_ID in NUMBER DEFAULT FND_API.G_MISS_NUM,
70: P_SIGN_OFF_FLAG in VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
71: P_RECORD_VERSION_NUMBER in NUMBER DEFAULT FND_API.G_MISS_NUM,
64: p_api_version IN NUMBER := 1.0,
65: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
66: p_commit IN VARCHAR2 := FND_API.g_false,
67: p_validate_only IN VARCHAR2 := FND_API.g_true,
68: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
69: P_CI_ACTION_ID in NUMBER DEFAULT FND_API.G_MISS_NUM,
70: P_SIGN_OFF_FLAG in VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
71: P_RECORD_VERSION_NUMBER in NUMBER DEFAULT FND_API.G_MISS_NUM,
72: P_RESOURCE_TYPE_ID in NUMBER DEFAULT FND_API.G_MISS_NUM,
65: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
66: p_commit IN VARCHAR2 := FND_API.g_false,
67: p_validate_only IN VARCHAR2 := FND_API.g_true,
68: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
69: P_CI_ACTION_ID in NUMBER DEFAULT FND_API.G_MISS_NUM,
70: P_SIGN_OFF_FLAG in VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
71: P_RECORD_VERSION_NUMBER in NUMBER DEFAULT FND_API.G_MISS_NUM,
72: P_RESOURCE_TYPE_ID in NUMBER DEFAULT FND_API.G_MISS_NUM,
73: P_ASSIGNED_TO in NUMBER DEFAULT FND_API.G_MISS_NUM,
66: p_commit IN VARCHAR2 := FND_API.g_false,
67: p_validate_only IN VARCHAR2 := FND_API.g_true,
68: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
69: P_CI_ACTION_ID in NUMBER DEFAULT FND_API.G_MISS_NUM,
70: P_SIGN_OFF_FLAG in VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
71: P_RECORD_VERSION_NUMBER in NUMBER DEFAULT FND_API.G_MISS_NUM,
72: P_RESOURCE_TYPE_ID in NUMBER DEFAULT FND_API.G_MISS_NUM,
73: P_ASSIGNED_TO in NUMBER DEFAULT FND_API.G_MISS_NUM,
74: P_ASSIGNED_TO_NAME in VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
67: p_validate_only IN VARCHAR2 := FND_API.g_true,
68: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
69: P_CI_ACTION_ID in NUMBER DEFAULT FND_API.G_MISS_NUM,
70: P_SIGN_OFF_FLAG in VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
71: P_RECORD_VERSION_NUMBER in NUMBER DEFAULT FND_API.G_MISS_NUM,
72: P_RESOURCE_TYPE_ID in NUMBER DEFAULT FND_API.G_MISS_NUM,
73: P_ASSIGNED_TO in NUMBER DEFAULT FND_API.G_MISS_NUM,
74: P_ASSIGNED_TO_NAME in VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
75: P_DATE_REQUIRED in DATE DEFAULT FND_API.G_MISS_DATE,
68: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
69: P_CI_ACTION_ID in NUMBER DEFAULT FND_API.G_MISS_NUM,
70: P_SIGN_OFF_FLAG in VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
71: P_RECORD_VERSION_NUMBER in NUMBER DEFAULT FND_API.G_MISS_NUM,
72: P_RESOURCE_TYPE_ID in NUMBER DEFAULT FND_API.G_MISS_NUM,
73: P_ASSIGNED_TO in NUMBER DEFAULT FND_API.G_MISS_NUM,
74: P_ASSIGNED_TO_NAME in VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
75: P_DATE_REQUIRED in DATE DEFAULT FND_API.G_MISS_DATE,
76: P_COMMENT_TEXT in VARCHAR2,
69: P_CI_ACTION_ID in NUMBER DEFAULT FND_API.G_MISS_NUM,
70: P_SIGN_OFF_FLAG in VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
71: P_RECORD_VERSION_NUMBER in NUMBER DEFAULT FND_API.G_MISS_NUM,
72: P_RESOURCE_TYPE_ID in NUMBER DEFAULT FND_API.G_MISS_NUM,
73: P_ASSIGNED_TO in NUMBER DEFAULT FND_API.G_MISS_NUM,
74: P_ASSIGNED_TO_NAME in VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
75: P_DATE_REQUIRED in DATE DEFAULT FND_API.G_MISS_DATE,
76: P_COMMENT_TEXT in VARCHAR2,
77: P_CLOSURE_COMMENT in VARCHAR2,
70: P_SIGN_OFF_FLAG in VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
71: P_RECORD_VERSION_NUMBER in NUMBER DEFAULT FND_API.G_MISS_NUM,
72: P_RESOURCE_TYPE_ID in NUMBER DEFAULT FND_API.G_MISS_NUM,
73: P_ASSIGNED_TO in NUMBER DEFAULT FND_API.G_MISS_NUM,
74: P_ASSIGNED_TO_NAME in VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
75: P_DATE_REQUIRED in DATE DEFAULT FND_API.G_MISS_DATE,
76: P_COMMENT_TEXT in VARCHAR2,
77: P_CLOSURE_COMMENT in VARCHAR2,
78: P_CREATED_BY in NUMBER default fnd_global.user_id,
71: P_RECORD_VERSION_NUMBER in NUMBER DEFAULT FND_API.G_MISS_NUM,
72: P_RESOURCE_TYPE_ID in NUMBER DEFAULT FND_API.G_MISS_NUM,
73: P_ASSIGNED_TO in NUMBER DEFAULT FND_API.G_MISS_NUM,
74: P_ASSIGNED_TO_NAME in VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
75: P_DATE_REQUIRED in DATE DEFAULT FND_API.G_MISS_DATE,
76: P_COMMENT_TEXT in VARCHAR2,
77: P_CLOSURE_COMMENT in VARCHAR2,
78: P_CREATED_BY in NUMBER default fnd_global.user_id,
79: P_CREATION_DATE in DATE default sysdate,
86: );
87:
88: PROCEDURE ADD_CI_COMMENT(
89: p_api_version IN NUMBER := 1.0,
90: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
91: p_commit IN VARCHAR2 := FND_API.g_false,
92: p_validate_only IN VARCHAR2 := FND_API.g_true,
93: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
94: x_ci_comment_id out NOCOPY NUMBER,
87:
88: PROCEDURE ADD_CI_COMMENT(
89: p_api_version IN NUMBER := 1.0,
90: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
91: p_commit IN VARCHAR2 := FND_API.g_false,
92: p_validate_only IN VARCHAR2 := FND_API.g_true,
93: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
94: x_ci_comment_id out NOCOPY NUMBER,
95: p_ci_id IN NUMBER,
88: PROCEDURE ADD_CI_COMMENT(
89: p_api_version IN NUMBER := 1.0,
90: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
91: p_commit IN VARCHAR2 := FND_API.g_false,
92: p_validate_only IN VARCHAR2 := FND_API.g_true,
93: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
94: x_ci_comment_id out NOCOPY NUMBER,
95: p_ci_id IN NUMBER,
96: p_type_code IN VARCHAR2,
89: p_api_version IN NUMBER := 1.0,
90: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
91: p_commit IN VARCHAR2 := FND_API.g_false,
92: p_validate_only IN VARCHAR2 := FND_API.g_true,
93: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
94: x_ci_comment_id out NOCOPY NUMBER,
95: p_ci_id IN NUMBER,
96: p_type_code IN VARCHAR2,
97: p_comment_text IN VARCHAR2,
106: x_msg_data OUT NOCOPY VARCHAR2);
107:
108: PROCEDURE UPDATE_CI_COMMENT(
109: p_api_version IN NUMBER := 1.0,
110: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
111: p_commit IN VARCHAR2 := FND_API.g_false,
112: p_validate_only IN VARCHAR2 := FND_API.g_true,
113: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
114: p_ci_comment_id IN NUMBER,
107:
108: PROCEDURE UPDATE_CI_COMMENT(
109: p_api_version IN NUMBER := 1.0,
110: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
111: p_commit IN VARCHAR2 := FND_API.g_false,
112: p_validate_only IN VARCHAR2 := FND_API.g_true,
113: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
114: p_ci_comment_id IN NUMBER,
115: p_comment_text IN VARCHAR2,
108: PROCEDURE UPDATE_CI_COMMENT(
109: p_api_version IN NUMBER := 1.0,
110: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
111: p_commit IN VARCHAR2 := FND_API.g_false,
112: p_validate_only IN VARCHAR2 := FND_API.g_true,
113: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
114: p_ci_comment_id IN NUMBER,
115: p_comment_text IN VARCHAR2,
116: p_record_version_number IN NUMBER,
109: p_api_version IN NUMBER := 1.0,
110: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
111: p_commit IN VARCHAR2 := FND_API.g_false,
112: p_validate_only IN VARCHAR2 := FND_API.g_true,
113: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
114: p_ci_comment_id IN NUMBER,
115: p_comment_text IN VARCHAR2,
116: p_record_version_number IN NUMBER,
117: P_LAST_UPDATED_BY in NUMBER default fnd_global.user_id,