eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PV_STATUS_NOTIFICATIONS_PKG dependencies on FND_API

Line 40: DECODE ( px_status_notification_id,FND_API.g_miss_num,NULL,px_status_notification_id ),

36: last_updated_by,
37: last_update_login)
38: VALUES
39: (
40: DECODE ( px_status_notification_id,FND_API.g_miss_num,NULL,px_status_notification_id ),
41: DECODE ( px_object_version_number,FND_API.g_miss_num,NULL,px_object_version_number ),
42: DECODE ( p_status_type,FND_API.g_miss_char, NULL,p_status_type ),
43: DECODE ( p_status_code,FND_API.g_miss_char, NULL,p_status_code ),
44: DECODE ( p_enabled_flag,FND_API.g_miss_char, NULL,p_enabled_flag ),

Line 41: DECODE ( px_object_version_number,FND_API.g_miss_num,NULL,px_object_version_number ),

37: last_update_login)
38: VALUES
39: (
40: DECODE ( px_status_notification_id,FND_API.g_miss_num,NULL,px_status_notification_id ),
41: DECODE ( px_object_version_number,FND_API.g_miss_num,NULL,px_object_version_number ),
42: DECODE ( p_status_type,FND_API.g_miss_char, NULL,p_status_type ),
43: DECODE ( p_status_code,FND_API.g_miss_char, NULL,p_status_code ),
44: DECODE ( p_enabled_flag,FND_API.g_miss_char, NULL,p_enabled_flag ),
45: DECODE ( p_notify_pt_flag,FND_API.g_miss_char, NULL,p_notify_pt_flag ),

Line 42: DECODE ( p_status_type,FND_API.g_miss_char, NULL,p_status_type ),

38: VALUES
39: (
40: DECODE ( px_status_notification_id,FND_API.g_miss_num,NULL,px_status_notification_id ),
41: DECODE ( px_object_version_number,FND_API.g_miss_num,NULL,px_object_version_number ),
42: DECODE ( p_status_type,FND_API.g_miss_char, NULL,p_status_type ),
43: DECODE ( p_status_code,FND_API.g_miss_char, NULL,p_status_code ),
44: DECODE ( p_enabled_flag,FND_API.g_miss_char, NULL,p_enabled_flag ),
45: DECODE ( p_notify_pt_flag,FND_API.g_miss_char, NULL,p_notify_pt_flag ),
46: DECODE ( p_notify_cm_flag,FND_API.g_miss_char, NULL,p_notify_cm_flag ),

Line 43: DECODE ( p_status_code,FND_API.g_miss_char, NULL,p_status_code ),

39: (
40: DECODE ( px_status_notification_id,FND_API.g_miss_num,NULL,px_status_notification_id ),
41: DECODE ( px_object_version_number,FND_API.g_miss_num,NULL,px_object_version_number ),
42: DECODE ( p_status_type,FND_API.g_miss_char, NULL,p_status_type ),
43: DECODE ( p_status_code,FND_API.g_miss_char, NULL,p_status_code ),
44: DECODE ( p_enabled_flag,FND_API.g_miss_char, NULL,p_enabled_flag ),
45: DECODE ( p_notify_pt_flag,FND_API.g_miss_char, NULL,p_notify_pt_flag ),
46: DECODE ( p_notify_cm_flag,FND_API.g_miss_char, NULL,p_notify_cm_flag ),
47: DECODE ( p_notify_am_flag,FND_API.g_miss_char, NULL,p_notify_am_flag ),

Line 44: DECODE ( p_enabled_flag,FND_API.g_miss_char, NULL,p_enabled_flag ),

40: DECODE ( px_status_notification_id,FND_API.g_miss_num,NULL,px_status_notification_id ),
41: DECODE ( px_object_version_number,FND_API.g_miss_num,NULL,px_object_version_number ),
42: DECODE ( p_status_type,FND_API.g_miss_char, NULL,p_status_type ),
43: DECODE ( p_status_code,FND_API.g_miss_char, NULL,p_status_code ),
44: DECODE ( p_enabled_flag,FND_API.g_miss_char, NULL,p_enabled_flag ),
45: DECODE ( p_notify_pt_flag,FND_API.g_miss_char, NULL,p_notify_pt_flag ),
46: DECODE ( p_notify_cm_flag,FND_API.g_miss_char, NULL,p_notify_cm_flag ),
47: DECODE ( p_notify_am_flag,FND_API.g_miss_char, NULL,p_notify_am_flag ),
48: DECODE ( p_notify_others_flag,FND_API.g_miss_char, NULL,p_notify_others_flag ),

Line 45: DECODE ( p_notify_pt_flag,FND_API.g_miss_char, NULL,p_notify_pt_flag ),

41: DECODE ( px_object_version_number,FND_API.g_miss_num,NULL,px_object_version_number ),
42: DECODE ( p_status_type,FND_API.g_miss_char, NULL,p_status_type ),
43: DECODE ( p_status_code,FND_API.g_miss_char, NULL,p_status_code ),
44: DECODE ( p_enabled_flag,FND_API.g_miss_char, NULL,p_enabled_flag ),
45: DECODE ( p_notify_pt_flag,FND_API.g_miss_char, NULL,p_notify_pt_flag ),
46: DECODE ( p_notify_cm_flag,FND_API.g_miss_char, NULL,p_notify_cm_flag ),
47: DECODE ( p_notify_am_flag,FND_API.g_miss_char, NULL,p_notify_am_flag ),
48: DECODE ( p_notify_others_flag,FND_API.g_miss_char, NULL,p_notify_others_flag ),
49: DECODE ( p_creation_date,FND_API.g_miss_char, NULL,p_creation_date ),

Line 46: DECODE ( p_notify_cm_flag,FND_API.g_miss_char, NULL,p_notify_cm_flag ),

42: DECODE ( p_status_type,FND_API.g_miss_char, NULL,p_status_type ),
43: DECODE ( p_status_code,FND_API.g_miss_char, NULL,p_status_code ),
44: DECODE ( p_enabled_flag,FND_API.g_miss_char, NULL,p_enabled_flag ),
45: DECODE ( p_notify_pt_flag,FND_API.g_miss_char, NULL,p_notify_pt_flag ),
46: DECODE ( p_notify_cm_flag,FND_API.g_miss_char, NULL,p_notify_cm_flag ),
47: DECODE ( p_notify_am_flag,FND_API.g_miss_char, NULL,p_notify_am_flag ),
48: DECODE ( p_notify_others_flag,FND_API.g_miss_char, NULL,p_notify_others_flag ),
49: DECODE ( p_creation_date,FND_API.g_miss_char, NULL,p_creation_date ),
50: DECODE ( p_created_by,FND_API.g_miss_num,NULL,p_created_by ),

Line 47: DECODE ( p_notify_am_flag,FND_API.g_miss_char, NULL,p_notify_am_flag ),

43: DECODE ( p_status_code,FND_API.g_miss_char, NULL,p_status_code ),
44: DECODE ( p_enabled_flag,FND_API.g_miss_char, NULL,p_enabled_flag ),
45: DECODE ( p_notify_pt_flag,FND_API.g_miss_char, NULL,p_notify_pt_flag ),
46: DECODE ( p_notify_cm_flag,FND_API.g_miss_char, NULL,p_notify_cm_flag ),
47: DECODE ( p_notify_am_flag,FND_API.g_miss_char, NULL,p_notify_am_flag ),
48: DECODE ( p_notify_others_flag,FND_API.g_miss_char, NULL,p_notify_others_flag ),
49: DECODE ( p_creation_date,FND_API.g_miss_char, NULL,p_creation_date ),
50: DECODE ( p_created_by,FND_API.g_miss_num,NULL,p_created_by ),
51: DECODE ( p_last_update_date,FND_API.g_miss_char, NULL,p_last_update_date ),

Line 48: DECODE ( p_notify_others_flag,FND_API.g_miss_char, NULL,p_notify_others_flag ),

44: DECODE ( p_enabled_flag,FND_API.g_miss_char, NULL,p_enabled_flag ),
45: DECODE ( p_notify_pt_flag,FND_API.g_miss_char, NULL,p_notify_pt_flag ),
46: DECODE ( p_notify_cm_flag,FND_API.g_miss_char, NULL,p_notify_cm_flag ),
47: DECODE ( p_notify_am_flag,FND_API.g_miss_char, NULL,p_notify_am_flag ),
48: DECODE ( p_notify_others_flag,FND_API.g_miss_char, NULL,p_notify_others_flag ),
49: DECODE ( p_creation_date,FND_API.g_miss_char, NULL,p_creation_date ),
50: DECODE ( p_created_by,FND_API.g_miss_num,NULL,p_created_by ),
51: DECODE ( p_last_update_date,FND_API.g_miss_char, NULL,p_last_update_date ),
52: DECODE ( p_last_updated_by,FND_API.g_miss_num,NULL,p_last_updated_by ),

Line 49: DECODE ( p_creation_date,FND_API.g_miss_char, NULL,p_creation_date ),

45: DECODE ( p_notify_pt_flag,FND_API.g_miss_char, NULL,p_notify_pt_flag ),
46: DECODE ( p_notify_cm_flag,FND_API.g_miss_char, NULL,p_notify_cm_flag ),
47: DECODE ( p_notify_am_flag,FND_API.g_miss_char, NULL,p_notify_am_flag ),
48: DECODE ( p_notify_others_flag,FND_API.g_miss_char, NULL,p_notify_others_flag ),
49: DECODE ( p_creation_date,FND_API.g_miss_char, NULL,p_creation_date ),
50: DECODE ( p_created_by,FND_API.g_miss_num,NULL,p_created_by ),
51: DECODE ( p_last_update_date,FND_API.g_miss_char, NULL,p_last_update_date ),
52: DECODE ( p_last_updated_by,FND_API.g_miss_num,NULL,p_last_updated_by ),
53: DECODE ( p_last_update_login,FND_API.g_miss_num,NULL,p_last_update_login ));

Line 50: DECODE ( p_created_by,FND_API.g_miss_num,NULL,p_created_by ),

46: DECODE ( p_notify_cm_flag,FND_API.g_miss_char, NULL,p_notify_cm_flag ),
47: DECODE ( p_notify_am_flag,FND_API.g_miss_char, NULL,p_notify_am_flag ),
48: DECODE ( p_notify_others_flag,FND_API.g_miss_char, NULL,p_notify_others_flag ),
49: DECODE ( p_creation_date,FND_API.g_miss_char, NULL,p_creation_date ),
50: DECODE ( p_created_by,FND_API.g_miss_num,NULL,p_created_by ),
51: DECODE ( p_last_update_date,FND_API.g_miss_char, NULL,p_last_update_date ),
52: DECODE ( p_last_updated_by,FND_API.g_miss_num,NULL,p_last_updated_by ),
53: DECODE ( p_last_update_login,FND_API.g_miss_num,NULL,p_last_update_login ));
54:

Line 51: DECODE ( p_last_update_date,FND_API.g_miss_char, NULL,p_last_update_date ),

47: DECODE ( p_notify_am_flag,FND_API.g_miss_char, NULL,p_notify_am_flag ),
48: DECODE ( p_notify_others_flag,FND_API.g_miss_char, NULL,p_notify_others_flag ),
49: DECODE ( p_creation_date,FND_API.g_miss_char, NULL,p_creation_date ),
50: DECODE ( p_created_by,FND_API.g_miss_num,NULL,p_created_by ),
51: DECODE ( p_last_update_date,FND_API.g_miss_char, NULL,p_last_update_date ),
52: DECODE ( p_last_updated_by,FND_API.g_miss_num,NULL,p_last_updated_by ),
53: DECODE ( p_last_update_login,FND_API.g_miss_num,NULL,p_last_update_login ));
54:
55:

Line 52: DECODE ( p_last_updated_by,FND_API.g_miss_num,NULL,p_last_updated_by ),

48: DECODE ( p_notify_others_flag,FND_API.g_miss_char, NULL,p_notify_others_flag ),
49: DECODE ( p_creation_date,FND_API.g_miss_char, NULL,p_creation_date ),
50: DECODE ( p_created_by,FND_API.g_miss_num,NULL,p_created_by ),
51: DECODE ( p_last_update_date,FND_API.g_miss_char, NULL,p_last_update_date ),
52: DECODE ( p_last_updated_by,FND_API.g_miss_num,NULL,p_last_updated_by ),
53: DECODE ( p_last_update_login,FND_API.g_miss_num,NULL,p_last_update_login ));
54:
55:
56:

Line 53: DECODE ( p_last_update_login,FND_API.g_miss_num,NULL,p_last_update_login ));

49: DECODE ( p_creation_date,FND_API.g_miss_char, NULL,p_creation_date ),
50: DECODE ( p_created_by,FND_API.g_miss_num,NULL,p_created_by ),
51: DECODE ( p_last_update_date,FND_API.g_miss_char, NULL,p_last_update_date ),
52: DECODE ( p_last_updated_by,FND_API.g_miss_num,NULL,p_last_updated_by ),
53: DECODE ( p_last_update_login,FND_API.g_miss_num,NULL,p_last_update_login ));
54:
55:
56:
57: end INSERT_ROW;

Line 132: object_version_number = DECODE ( p_object_version_number,FND_API.g_miss_num,NULL,p_object_version_number+1 ) ,

128: ) IS
129: BEGIN
130: UPDATE pv_status_notifications
131: SET
132: object_version_number = DECODE ( p_object_version_number,FND_API.g_miss_num,NULL,p_object_version_number+1 ) ,
133: status_type = DECODE ( p_status_type,FND_API.g_miss_char, NULL,p_status_type ),
134: status_code = DECODE ( p_status_code,FND_API.g_miss_char, NULL,p_status_code ),
135: enabled_flag = DECODE ( p_enabled_flag,FND_API.g_miss_char, NULL,p_enabled_flag ),
136: notify_pt_flag = DECODE ( p_notify_pt_flag,FND_API.g_miss_char, NULL,p_notify_pt_flag ),

Line 133: status_type = DECODE ( p_status_type,FND_API.g_miss_char, NULL,p_status_type ),

129: BEGIN
130: UPDATE pv_status_notifications
131: SET
132: object_version_number = DECODE ( p_object_version_number,FND_API.g_miss_num,NULL,p_object_version_number+1 ) ,
133: status_type = DECODE ( p_status_type,FND_API.g_miss_char, NULL,p_status_type ),
134: status_code = DECODE ( p_status_code,FND_API.g_miss_char, NULL,p_status_code ),
135: enabled_flag = DECODE ( p_enabled_flag,FND_API.g_miss_char, NULL,p_enabled_flag ),
136: notify_pt_flag = DECODE ( p_notify_pt_flag,FND_API.g_miss_char, NULL,p_notify_pt_flag ),
137: notify_cm_flag = DECODE ( p_notify_cm_flag,FND_API.g_miss_char, NULL,p_notify_cm_flag ),

Line 134: status_code = DECODE ( p_status_code,FND_API.g_miss_char, NULL,p_status_code ),

130: UPDATE pv_status_notifications
131: SET
132: object_version_number = DECODE ( p_object_version_number,FND_API.g_miss_num,NULL,p_object_version_number+1 ) ,
133: status_type = DECODE ( p_status_type,FND_API.g_miss_char, NULL,p_status_type ),
134: status_code = DECODE ( p_status_code,FND_API.g_miss_char, NULL,p_status_code ),
135: enabled_flag = DECODE ( p_enabled_flag,FND_API.g_miss_char, NULL,p_enabled_flag ),
136: notify_pt_flag = DECODE ( p_notify_pt_flag,FND_API.g_miss_char, NULL,p_notify_pt_flag ),
137: notify_cm_flag = DECODE ( p_notify_cm_flag,FND_API.g_miss_char, NULL,p_notify_cm_flag ),
138: notify_am_flag = DECODE ( p_notify_am_flag,FND_API.g_miss_char, NULL,p_notify_am_flag ),

Line 135: enabled_flag = DECODE ( p_enabled_flag,FND_API.g_miss_char, NULL,p_enabled_flag ),

131: SET
132: object_version_number = DECODE ( p_object_version_number,FND_API.g_miss_num,NULL,p_object_version_number+1 ) ,
133: status_type = DECODE ( p_status_type,FND_API.g_miss_char, NULL,p_status_type ),
134: status_code = DECODE ( p_status_code,FND_API.g_miss_char, NULL,p_status_code ),
135: enabled_flag = DECODE ( p_enabled_flag,FND_API.g_miss_char, NULL,p_enabled_flag ),
136: notify_pt_flag = DECODE ( p_notify_pt_flag,FND_API.g_miss_char, NULL,p_notify_pt_flag ),
137: notify_cm_flag = DECODE ( p_notify_cm_flag,FND_API.g_miss_char, NULL,p_notify_cm_flag ),
138: notify_am_flag = DECODE ( p_notify_am_flag,FND_API.g_miss_char, NULL,p_notify_am_flag ),
139: notify_others_flag = DECODE ( p_notify_others_flag,FND_API.g_miss_char, NULL,p_notify_others_flag ),

Line 136: notify_pt_flag = DECODE ( p_notify_pt_flag,FND_API.g_miss_char, NULL,p_notify_pt_flag ),

132: object_version_number = DECODE ( p_object_version_number,FND_API.g_miss_num,NULL,p_object_version_number+1 ) ,
133: status_type = DECODE ( p_status_type,FND_API.g_miss_char, NULL,p_status_type ),
134: status_code = DECODE ( p_status_code,FND_API.g_miss_char, NULL,p_status_code ),
135: enabled_flag = DECODE ( p_enabled_flag,FND_API.g_miss_char, NULL,p_enabled_flag ),
136: notify_pt_flag = DECODE ( p_notify_pt_flag,FND_API.g_miss_char, NULL,p_notify_pt_flag ),
137: notify_cm_flag = DECODE ( p_notify_cm_flag,FND_API.g_miss_char, NULL,p_notify_cm_flag ),
138: notify_am_flag = DECODE ( p_notify_am_flag,FND_API.g_miss_char, NULL,p_notify_am_flag ),
139: notify_others_flag = DECODE ( p_notify_others_flag,FND_API.g_miss_char, NULL,p_notify_others_flag ),
140: last_update_date = DECODE ( p_last_update_date,FND_API.g_miss_char, NULL,p_last_update_date ),

Line 137: notify_cm_flag = DECODE ( p_notify_cm_flag,FND_API.g_miss_char, NULL,p_notify_cm_flag ),

133: status_type = DECODE ( p_status_type,FND_API.g_miss_char, NULL,p_status_type ),
134: status_code = DECODE ( p_status_code,FND_API.g_miss_char, NULL,p_status_code ),
135: enabled_flag = DECODE ( p_enabled_flag,FND_API.g_miss_char, NULL,p_enabled_flag ),
136: notify_pt_flag = DECODE ( p_notify_pt_flag,FND_API.g_miss_char, NULL,p_notify_pt_flag ),
137: notify_cm_flag = DECODE ( p_notify_cm_flag,FND_API.g_miss_char, NULL,p_notify_cm_flag ),
138: notify_am_flag = DECODE ( p_notify_am_flag,FND_API.g_miss_char, NULL,p_notify_am_flag ),
139: notify_others_flag = DECODE ( p_notify_others_flag,FND_API.g_miss_char, NULL,p_notify_others_flag ),
140: last_update_date = DECODE ( p_last_update_date,FND_API.g_miss_char, NULL,p_last_update_date ),
141: last_updated_by = DECODE ( p_last_updated_by,FND_API.g_miss_num,NULL,p_last_updated_by ),

Line 138: notify_am_flag = DECODE ( p_notify_am_flag,FND_API.g_miss_char, NULL,p_notify_am_flag ),

134: status_code = DECODE ( p_status_code,FND_API.g_miss_char, NULL,p_status_code ),
135: enabled_flag = DECODE ( p_enabled_flag,FND_API.g_miss_char, NULL,p_enabled_flag ),
136: notify_pt_flag = DECODE ( p_notify_pt_flag,FND_API.g_miss_char, NULL,p_notify_pt_flag ),
137: notify_cm_flag = DECODE ( p_notify_cm_flag,FND_API.g_miss_char, NULL,p_notify_cm_flag ),
138: notify_am_flag = DECODE ( p_notify_am_flag,FND_API.g_miss_char, NULL,p_notify_am_flag ),
139: notify_others_flag = DECODE ( p_notify_others_flag,FND_API.g_miss_char, NULL,p_notify_others_flag ),
140: last_update_date = DECODE ( p_last_update_date,FND_API.g_miss_char, NULL,p_last_update_date ),
141: last_updated_by = DECODE ( p_last_updated_by,FND_API.g_miss_num,NULL,p_last_updated_by ),
142: last_update_login = DECODE ( p_last_update_login,FND_API.g_miss_num,NULL,p_last_update_login )

Line 139: notify_others_flag = DECODE ( p_notify_others_flag,FND_API.g_miss_char, NULL,p_notify_others_flag ),

135: enabled_flag = DECODE ( p_enabled_flag,FND_API.g_miss_char, NULL,p_enabled_flag ),
136: notify_pt_flag = DECODE ( p_notify_pt_flag,FND_API.g_miss_char, NULL,p_notify_pt_flag ),
137: notify_cm_flag = DECODE ( p_notify_cm_flag,FND_API.g_miss_char, NULL,p_notify_cm_flag ),
138: notify_am_flag = DECODE ( p_notify_am_flag,FND_API.g_miss_char, NULL,p_notify_am_flag ),
139: notify_others_flag = DECODE ( p_notify_others_flag,FND_API.g_miss_char, NULL,p_notify_others_flag ),
140: last_update_date = DECODE ( p_last_update_date,FND_API.g_miss_char, NULL,p_last_update_date ),
141: last_updated_by = DECODE ( p_last_updated_by,FND_API.g_miss_num,NULL,p_last_updated_by ),
142: last_update_login = DECODE ( p_last_update_login,FND_API.g_miss_num,NULL,p_last_update_login )
143: WHERE status_notification_id = p_status_notification_id;

Line 140: last_update_date = DECODE ( p_last_update_date,FND_API.g_miss_char, NULL,p_last_update_date ),

136: notify_pt_flag = DECODE ( p_notify_pt_flag,FND_API.g_miss_char, NULL,p_notify_pt_flag ),
137: notify_cm_flag = DECODE ( p_notify_cm_flag,FND_API.g_miss_char, NULL,p_notify_cm_flag ),
138: notify_am_flag = DECODE ( p_notify_am_flag,FND_API.g_miss_char, NULL,p_notify_am_flag ),
139: notify_others_flag = DECODE ( p_notify_others_flag,FND_API.g_miss_char, NULL,p_notify_others_flag ),
140: last_update_date = DECODE ( p_last_update_date,FND_API.g_miss_char, NULL,p_last_update_date ),
141: last_updated_by = DECODE ( p_last_updated_by,FND_API.g_miss_num,NULL,p_last_updated_by ),
142: last_update_login = DECODE ( p_last_update_login,FND_API.g_miss_num,NULL,p_last_update_login )
143: WHERE status_notification_id = p_status_notification_id;
144:

Line 141: last_updated_by = DECODE ( p_last_updated_by,FND_API.g_miss_num,NULL,p_last_updated_by ),

137: notify_cm_flag = DECODE ( p_notify_cm_flag,FND_API.g_miss_char, NULL,p_notify_cm_flag ),
138: notify_am_flag = DECODE ( p_notify_am_flag,FND_API.g_miss_char, NULL,p_notify_am_flag ),
139: notify_others_flag = DECODE ( p_notify_others_flag,FND_API.g_miss_char, NULL,p_notify_others_flag ),
140: last_update_date = DECODE ( p_last_update_date,FND_API.g_miss_char, NULL,p_last_update_date ),
141: last_updated_by = DECODE ( p_last_updated_by,FND_API.g_miss_num,NULL,p_last_updated_by ),
142: last_update_login = DECODE ( p_last_update_login,FND_API.g_miss_num,NULL,p_last_update_login )
143: WHERE status_notification_id = p_status_notification_id;
144:
145: IF (SQL%NOTFOUND) THEN

Line 142: last_update_login = DECODE ( p_last_update_login,FND_API.g_miss_num,NULL,p_last_update_login )

138: notify_am_flag = DECODE ( p_notify_am_flag,FND_API.g_miss_char, NULL,p_notify_am_flag ),
139: notify_others_flag = DECODE ( p_notify_others_flag,FND_API.g_miss_char, NULL,p_notify_others_flag ),
140: last_update_date = DECODE ( p_last_update_date,FND_API.g_miss_char, NULL,p_last_update_date ),
141: last_updated_by = DECODE ( p_last_updated_by,FND_API.g_miss_num,NULL,p_last_updated_by ),
142: last_update_login = DECODE ( p_last_update_login,FND_API.g_miss_num,NULL,p_last_update_login )
143: WHERE status_notification_id = p_status_notification_id;
144:
145: IF (SQL%NOTFOUND) THEN
146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

142: last_update_login = DECODE ( p_last_update_login,FND_API.g_miss_num,NULL,p_last_update_login )
143: WHERE status_notification_id = p_status_notification_id;
144:
145: IF (SQL%NOTFOUND) THEN
146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
147: END IF;
148:
149: end UPDATE_ROW;
150:

Line 163: object_version_number = DECODE ( p_object_version_number,FND_API.g_miss_num,NULL,p_object_version_number+1 ),

159: ) IS
160: BEGIN
161: UPDATE pv_status_notifications
162: SET
163: object_version_number = DECODE ( p_object_version_number,FND_API.g_miss_num,NULL,p_object_version_number+1 ),
164: status_type = DECODE ( p_status_type,FND_API.g_miss_char, NULL,p_status_type ),
165: status_code = DECODE ( p_status_code,FND_API.g_miss_char, NULL,p_status_code ),
166: last_update_date = DECODE ( p_last_update_date,FND_API.g_miss_char, NULL,p_last_update_date ),
167: last_updated_by = DECODE ( p_last_updated_by,FND_API.g_miss_num,NULL,p_last_updated_by ),

Line 164: status_type = DECODE ( p_status_type,FND_API.g_miss_char, NULL,p_status_type ),

160: BEGIN
161: UPDATE pv_status_notifications
162: SET
163: object_version_number = DECODE ( p_object_version_number,FND_API.g_miss_num,NULL,p_object_version_number+1 ),
164: status_type = DECODE ( p_status_type,FND_API.g_miss_char, NULL,p_status_type ),
165: status_code = DECODE ( p_status_code,FND_API.g_miss_char, NULL,p_status_code ),
166: last_update_date = DECODE ( p_last_update_date,FND_API.g_miss_char, NULL,p_last_update_date ),
167: last_updated_by = DECODE ( p_last_updated_by,FND_API.g_miss_num,NULL,p_last_updated_by ),
168: last_update_login = DECODE ( p_last_update_login,FND_API.g_miss_num,NULL,p_last_update_login )

Line 165: status_code = DECODE ( p_status_code,FND_API.g_miss_char, NULL,p_status_code ),

161: UPDATE pv_status_notifications
162: SET
163: object_version_number = DECODE ( p_object_version_number,FND_API.g_miss_num,NULL,p_object_version_number+1 ),
164: status_type = DECODE ( p_status_type,FND_API.g_miss_char, NULL,p_status_type ),
165: status_code = DECODE ( p_status_code,FND_API.g_miss_char, NULL,p_status_code ),
166: last_update_date = DECODE ( p_last_update_date,FND_API.g_miss_char, NULL,p_last_update_date ),
167: last_updated_by = DECODE ( p_last_updated_by,FND_API.g_miss_num,NULL,p_last_updated_by ),
168: last_update_login = DECODE ( p_last_update_login,FND_API.g_miss_num,NULL,p_last_update_login )
169: WHERE status_notification_id = p_status_notification_id;

Line 166: last_update_date = DECODE ( p_last_update_date,FND_API.g_miss_char, NULL,p_last_update_date ),

162: SET
163: object_version_number = DECODE ( p_object_version_number,FND_API.g_miss_num,NULL,p_object_version_number+1 ),
164: status_type = DECODE ( p_status_type,FND_API.g_miss_char, NULL,p_status_type ),
165: status_code = DECODE ( p_status_code,FND_API.g_miss_char, NULL,p_status_code ),
166: last_update_date = DECODE ( p_last_update_date,FND_API.g_miss_char, NULL,p_last_update_date ),
167: last_updated_by = DECODE ( p_last_updated_by,FND_API.g_miss_num,NULL,p_last_updated_by ),
168: last_update_login = DECODE ( p_last_update_login,FND_API.g_miss_num,NULL,p_last_update_login )
169: WHERE status_notification_id = p_status_notification_id;
170:

Line 167: last_updated_by = DECODE ( p_last_updated_by,FND_API.g_miss_num,NULL,p_last_updated_by ),

163: object_version_number = DECODE ( p_object_version_number,FND_API.g_miss_num,NULL,p_object_version_number+1 ),
164: status_type = DECODE ( p_status_type,FND_API.g_miss_char, NULL,p_status_type ),
165: status_code = DECODE ( p_status_code,FND_API.g_miss_char, NULL,p_status_code ),
166: last_update_date = DECODE ( p_last_update_date,FND_API.g_miss_char, NULL,p_last_update_date ),
167: last_updated_by = DECODE ( p_last_updated_by,FND_API.g_miss_num,NULL,p_last_updated_by ),
168: last_update_login = DECODE ( p_last_update_login,FND_API.g_miss_num,NULL,p_last_update_login )
169: WHERE status_notification_id = p_status_notification_id;
170:
171: IF (SQL%NOTFOUND) THEN

Line 168: last_update_login = DECODE ( p_last_update_login,FND_API.g_miss_num,NULL,p_last_update_login )

164: status_type = DECODE ( p_status_type,FND_API.g_miss_char, NULL,p_status_type ),
165: status_code = DECODE ( p_status_code,FND_API.g_miss_char, NULL,p_status_code ),
166: last_update_date = DECODE ( p_last_update_date,FND_API.g_miss_char, NULL,p_last_update_date ),
167: last_updated_by = DECODE ( p_last_updated_by,FND_API.g_miss_num,NULL,p_last_updated_by ),
168: last_update_login = DECODE ( p_last_update_login,FND_API.g_miss_num,NULL,p_last_update_login )
169: WHERE status_notification_id = p_status_notification_id;
170:
171: IF (SQL%NOTFOUND) THEN
172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

168: last_update_login = DECODE ( p_last_update_login,FND_API.g_miss_num,NULL,p_last_update_login )
169: WHERE status_notification_id = p_status_notification_id;
170:
171: IF (SQL%NOTFOUND) THEN
172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
173: END IF;
174:
175: end SEED_UPDATE_ROW;
176:

Line 338: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

334: DELETE FROM pv_status_notifications
335: WHERE status_notification_id = p_status_notification_id;
336:
337: IF (SQL%NOTFOUND) THEN
338: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
339: END IF;
340:
341: END DELETE_ROW;
342: