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.AMS_IBA_PS_CNDCLSES_B_PKG dependencies on FND_API

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

65: cnd_clause_ref_code,
66: cnd_comp_operator,
67: cnd_default_value
68: ) VALUES (
69: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
70: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
71: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
72: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
73: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),

Line 70: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),

66: cnd_comp_operator,
67: cnd_default_value
68: ) VALUES (
69: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
70: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
71: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
72: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
73: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
74: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),

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

67: cnd_default_value
68: ) VALUES (
69: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
70: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
71: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
72: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
73: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
74: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
75: DECODE( px_cnd_clause_id, FND_API.g_miss_num, NULL, px_cnd_clause_id),

Line 72: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),

68: ) VALUES (
69: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
70: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
71: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
72: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
73: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
74: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
75: DECODE( px_cnd_clause_id, FND_API.g_miss_num, NULL, px_cnd_clause_id),
76: DECODE( p_cnd_clause_datatype, FND_API.g_miss_char, NULL, p_cnd_clause_datatype),

Line 73: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),

69: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
70: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
71: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
72: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
73: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
74: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
75: DECODE( px_cnd_clause_id, FND_API.g_miss_num, NULL, px_cnd_clause_id),
76: DECODE( p_cnd_clause_datatype, FND_API.g_miss_char, NULL, p_cnd_clause_datatype),
77: DECODE( p_cnd_clause_ref_code, FND_API.g_miss_char, NULL, p_cnd_clause_ref_code),

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

70: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
71: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
72: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
73: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
74: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
75: DECODE( px_cnd_clause_id, FND_API.g_miss_num, NULL, px_cnd_clause_id),
76: DECODE( p_cnd_clause_datatype, FND_API.g_miss_char, NULL, p_cnd_clause_datatype),
77: DECODE( p_cnd_clause_ref_code, FND_API.g_miss_char, NULL, p_cnd_clause_ref_code),
78: DECODE( p_cnd_comp_operator, FND_API.g_miss_char, NULL, p_cnd_comp_operator),

Line 75: DECODE( px_cnd_clause_id, FND_API.g_miss_num, NULL, px_cnd_clause_id),

71: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
72: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
73: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
74: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
75: DECODE( px_cnd_clause_id, FND_API.g_miss_num, NULL, px_cnd_clause_id),
76: DECODE( p_cnd_clause_datatype, FND_API.g_miss_char, NULL, p_cnd_clause_datatype),
77: DECODE( p_cnd_clause_ref_code, FND_API.g_miss_char, NULL, p_cnd_clause_ref_code),
78: DECODE( p_cnd_comp_operator, FND_API.g_miss_char, NULL, p_cnd_comp_operator),
79: DECODE( p_cnd_default_value, FND_API.g_miss_char, NULL, p_cnd_default_value));

Line 76: DECODE( p_cnd_clause_datatype, FND_API.g_miss_char, NULL, p_cnd_clause_datatype),

72: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
73: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
74: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
75: DECODE( px_cnd_clause_id, FND_API.g_miss_num, NULL, px_cnd_clause_id),
76: DECODE( p_cnd_clause_datatype, FND_API.g_miss_char, NULL, p_cnd_clause_datatype),
77: DECODE( p_cnd_clause_ref_code, FND_API.g_miss_char, NULL, p_cnd_clause_ref_code),
78: DECODE( p_cnd_comp_operator, FND_API.g_miss_char, NULL, p_cnd_comp_operator),
79: DECODE( p_cnd_default_value, FND_API.g_miss_char, NULL, p_cnd_default_value));
80:

Line 77: DECODE( p_cnd_clause_ref_code, FND_API.g_miss_char, NULL, p_cnd_clause_ref_code),

73: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
74: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
75: DECODE( px_cnd_clause_id, FND_API.g_miss_num, NULL, px_cnd_clause_id),
76: DECODE( p_cnd_clause_datatype, FND_API.g_miss_char, NULL, p_cnd_clause_datatype),
77: DECODE( p_cnd_clause_ref_code, FND_API.g_miss_char, NULL, p_cnd_clause_ref_code),
78: DECODE( p_cnd_comp_operator, FND_API.g_miss_char, NULL, p_cnd_comp_operator),
79: DECODE( p_cnd_default_value, FND_API.g_miss_char, NULL, p_cnd_default_value));
80:
81: INSERT INTO ams_iba_ps_cndclses_tl (

Line 78: DECODE( p_cnd_comp_operator, FND_API.g_miss_char, NULL, p_cnd_comp_operator),

74: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
75: DECODE( px_cnd_clause_id, FND_API.g_miss_num, NULL, px_cnd_clause_id),
76: DECODE( p_cnd_clause_datatype, FND_API.g_miss_char, NULL, p_cnd_clause_datatype),
77: DECODE( p_cnd_clause_ref_code, FND_API.g_miss_char, NULL, p_cnd_clause_ref_code),
78: DECODE( p_cnd_comp_operator, FND_API.g_miss_char, NULL, p_cnd_comp_operator),
79: DECODE( p_cnd_default_value, FND_API.g_miss_char, NULL, p_cnd_default_value));
80:
81: INSERT INTO ams_iba_ps_cndclses_tl (
82: created_by,

Line 79: DECODE( p_cnd_default_value, FND_API.g_miss_char, NULL, p_cnd_default_value));

75: DECODE( px_cnd_clause_id, FND_API.g_miss_num, NULL, px_cnd_clause_id),
76: DECODE( p_cnd_clause_datatype, FND_API.g_miss_char, NULL, p_cnd_clause_datatype),
77: DECODE( p_cnd_clause_ref_code, FND_API.g_miss_char, NULL, p_cnd_clause_ref_code),
78: DECODE( p_cnd_comp_operator, FND_API.g_miss_char, NULL, p_cnd_comp_operator),
79: DECODE( p_cnd_default_value, FND_API.g_miss_char, NULL, p_cnd_default_value));
80:
81: INSERT INTO ams_iba_ps_cndclses_tl (
82: created_by,
83: creation_date,

Line 99: DECODE( px_cnd_clause_id, FND_API.g_miss_num, NULL, px_cnd_clause_id),

95: SYSDATE,
96: FND_GLOBAL.user_id,
97: SYSDATE,
98: FND_GLOBAL.conc_login_id,
99: DECODE( px_cnd_clause_id, FND_API.g_miss_num, NULL, px_cnd_clause_id),
100: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
101:
102: DECODE( p_CND_CLAUSE_NAME, FND_API.G_MISS_CHAR, NULL, p_CND_CLAUSE_NAME),
103: DECODE( p_CND_CLAUSE_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_CND_CLAUSE_DESCRIPTION),

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

96: FND_GLOBAL.user_id,
97: SYSDATE,
98: FND_GLOBAL.conc_login_id,
99: DECODE( px_cnd_clause_id, FND_API.g_miss_num, NULL, px_cnd_clause_id),
100: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
101:
102: DECODE( p_CND_CLAUSE_NAME, FND_API.G_MISS_CHAR, NULL, p_CND_CLAUSE_NAME),
103: DECODE( p_CND_CLAUSE_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_CND_CLAUSE_DESCRIPTION),
104: l.language_code,

Line 102: DECODE( p_CND_CLAUSE_NAME, FND_API.G_MISS_CHAR, NULL, p_CND_CLAUSE_NAME),

98: FND_GLOBAL.conc_login_id,
99: DECODE( px_cnd_clause_id, FND_API.g_miss_num, NULL, px_cnd_clause_id),
100: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
101:
102: DECODE( p_CND_CLAUSE_NAME, FND_API.G_MISS_CHAR, NULL, p_CND_CLAUSE_NAME),
103: DECODE( p_CND_CLAUSE_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_CND_CLAUSE_DESCRIPTION),
104: l.language_code,
105: USERENV('LANG')
106: FROM fnd_languages l

Line 103: DECODE( p_CND_CLAUSE_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_CND_CLAUSE_DESCRIPTION),

99: DECODE( px_cnd_clause_id, FND_API.g_miss_num, NULL, px_cnd_clause_id),
100: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
101:
102: DECODE( p_CND_CLAUSE_NAME, FND_API.G_MISS_CHAR, NULL, p_CND_CLAUSE_NAME),
103: DECODE( p_CND_CLAUSE_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_CND_CLAUSE_DESCRIPTION),
104: l.language_code,
105: USERENV('LANG')
106: FROM fnd_languages l
107: WHERE l.installed_flag IN ('I', 'B')

Line 111: WHERE t.cnd_clause_id = DECODE( px_cnd_clause_id, FND_API.g_miss_num, NULL, px_cnd_clause_id)

107: WHERE l.installed_flag IN ('I', 'B')
108: AND NOT EXISTS
109: (SELECT null
110: FROM ams_iba_ps_cndclses_tl t
111: WHERE t.cnd_clause_id = DECODE( px_cnd_clause_id, FND_API.g_miss_num, NULL, px_cnd_clause_id)
112: AND t.language = l.language_code);
113:
114: END Insert_Row;
115:

Line 152: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),

148: IS
149: BEGIN
150: Update AMS_IBA_PS_CNDCLSES_B
151: SET
152: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
153: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
154: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
155: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
156: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),

Line 153: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),

149: BEGIN
150: Update AMS_IBA_PS_CNDCLSES_B
151: SET
152: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
153: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
154: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
155: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
156: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
157: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),

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

150: Update AMS_IBA_PS_CNDCLSES_B
151: SET
152: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
153: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
154: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
155: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
156: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
157: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
158: cnd_clause_id = DECODE( p_cnd_clause_id, FND_API.g_miss_num, cnd_clause_id, p_cnd_clause_id),

Line 155: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),

151: SET
152: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
153: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
154: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
155: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
156: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
157: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
158: cnd_clause_id = DECODE( p_cnd_clause_id, FND_API.g_miss_num, cnd_clause_id, p_cnd_clause_id),
159: cnd_clause_datatype = DECODE( p_cnd_clause_datatype, FND_API.g_miss_char, cnd_clause_datatype, p_cnd_clause_datatype),

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

152: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
153: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
154: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
155: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
156: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
157: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
158: cnd_clause_id = DECODE( p_cnd_clause_id, FND_API.g_miss_num, cnd_clause_id, p_cnd_clause_id),
159: cnd_clause_datatype = DECODE( p_cnd_clause_datatype, FND_API.g_miss_char, cnd_clause_datatype, p_cnd_clause_datatype),
160: cnd_clause_ref_code = DECODE( p_cnd_clause_ref_code, FND_API.g_miss_char, cnd_clause_ref_code, p_cnd_clause_ref_code),

Line 157: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),

153: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
154: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
155: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
156: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
157: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
158: cnd_clause_id = DECODE( p_cnd_clause_id, FND_API.g_miss_num, cnd_clause_id, p_cnd_clause_id),
159: cnd_clause_datatype = DECODE( p_cnd_clause_datatype, FND_API.g_miss_char, cnd_clause_datatype, p_cnd_clause_datatype),
160: cnd_clause_ref_code = DECODE( p_cnd_clause_ref_code, FND_API.g_miss_char, cnd_clause_ref_code, p_cnd_clause_ref_code),
161: cnd_comp_operator = DECODE( p_cnd_comp_operator, FND_API.g_miss_char, cnd_comp_operator, p_cnd_comp_operator),

Line 158: cnd_clause_id = DECODE( p_cnd_clause_id, FND_API.g_miss_num, cnd_clause_id, p_cnd_clause_id),

154: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
155: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
156: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
157: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
158: cnd_clause_id = DECODE( p_cnd_clause_id, FND_API.g_miss_num, cnd_clause_id, p_cnd_clause_id),
159: cnd_clause_datatype = DECODE( p_cnd_clause_datatype, FND_API.g_miss_char, cnd_clause_datatype, p_cnd_clause_datatype),
160: cnd_clause_ref_code = DECODE( p_cnd_clause_ref_code, FND_API.g_miss_char, cnd_clause_ref_code, p_cnd_clause_ref_code),
161: cnd_comp_operator = DECODE( p_cnd_comp_operator, FND_API.g_miss_char, cnd_comp_operator, p_cnd_comp_operator),
162: cnd_default_value = DECODE( p_cnd_default_value, FND_API.g_miss_char, cnd_default_value, p_cnd_default_value)

Line 159: cnd_clause_datatype = DECODE( p_cnd_clause_datatype, FND_API.g_miss_char, cnd_clause_datatype, p_cnd_clause_datatype),

155: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
156: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
157: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
158: cnd_clause_id = DECODE( p_cnd_clause_id, FND_API.g_miss_num, cnd_clause_id, p_cnd_clause_id),
159: cnd_clause_datatype = DECODE( p_cnd_clause_datatype, FND_API.g_miss_char, cnd_clause_datatype, p_cnd_clause_datatype),
160: cnd_clause_ref_code = DECODE( p_cnd_clause_ref_code, FND_API.g_miss_char, cnd_clause_ref_code, p_cnd_clause_ref_code),
161: cnd_comp_operator = DECODE( p_cnd_comp_operator, FND_API.g_miss_char, cnd_comp_operator, p_cnd_comp_operator),
162: cnd_default_value = DECODE( p_cnd_default_value, FND_API.g_miss_char, cnd_default_value, p_cnd_default_value)
163: WHERE CND_CLAUSE_ID = p_CND_CLAUSE_ID

Line 160: cnd_clause_ref_code = DECODE( p_cnd_clause_ref_code, FND_API.g_miss_char, cnd_clause_ref_code, p_cnd_clause_ref_code),

156: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
157: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
158: cnd_clause_id = DECODE( p_cnd_clause_id, FND_API.g_miss_num, cnd_clause_id, p_cnd_clause_id),
159: cnd_clause_datatype = DECODE( p_cnd_clause_datatype, FND_API.g_miss_char, cnd_clause_datatype, p_cnd_clause_datatype),
160: cnd_clause_ref_code = DECODE( p_cnd_clause_ref_code, FND_API.g_miss_char, cnd_clause_ref_code, p_cnd_clause_ref_code),
161: cnd_comp_operator = DECODE( p_cnd_comp_operator, FND_API.g_miss_char, cnd_comp_operator, p_cnd_comp_operator),
162: cnd_default_value = DECODE( p_cnd_default_value, FND_API.g_miss_char, cnd_default_value, p_cnd_default_value)
163: WHERE CND_CLAUSE_ID = p_CND_CLAUSE_ID
164: AND object_version_number = p_object_version_number;

Line 161: cnd_comp_operator = DECODE( p_cnd_comp_operator, FND_API.g_miss_char, cnd_comp_operator, p_cnd_comp_operator),

157: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
158: cnd_clause_id = DECODE( p_cnd_clause_id, FND_API.g_miss_num, cnd_clause_id, p_cnd_clause_id),
159: cnd_clause_datatype = DECODE( p_cnd_clause_datatype, FND_API.g_miss_char, cnd_clause_datatype, p_cnd_clause_datatype),
160: cnd_clause_ref_code = DECODE( p_cnd_clause_ref_code, FND_API.g_miss_char, cnd_clause_ref_code, p_cnd_clause_ref_code),
161: cnd_comp_operator = DECODE( p_cnd_comp_operator, FND_API.g_miss_char, cnd_comp_operator, p_cnd_comp_operator),
162: cnd_default_value = DECODE( p_cnd_default_value, FND_API.g_miss_char, cnd_default_value, p_cnd_default_value)
163: WHERE CND_CLAUSE_ID = p_CND_CLAUSE_ID
164: AND object_version_number = p_object_version_number;
165:

Line 162: cnd_default_value = DECODE( p_cnd_default_value, FND_API.g_miss_char, cnd_default_value, p_cnd_default_value)

158: cnd_clause_id = DECODE( p_cnd_clause_id, FND_API.g_miss_num, cnd_clause_id, p_cnd_clause_id),
159: cnd_clause_datatype = DECODE( p_cnd_clause_datatype, FND_API.g_miss_char, cnd_clause_datatype, p_cnd_clause_datatype),
160: cnd_clause_ref_code = DECODE( p_cnd_clause_ref_code, FND_API.g_miss_char, cnd_clause_ref_code, p_cnd_clause_ref_code),
161: cnd_comp_operator = DECODE( p_cnd_comp_operator, FND_API.g_miss_char, cnd_comp_operator, p_cnd_comp_operator),
162: cnd_default_value = DECODE( p_cnd_default_value, FND_API.g_miss_char, cnd_default_value, p_cnd_default_value)
163: WHERE CND_CLAUSE_ID = p_CND_CLAUSE_ID
164: AND object_version_number = p_object_version_number;
165:
166: IF (SQL%NOTFOUND) THEN

Line 167: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

163: WHERE CND_CLAUSE_ID = p_CND_CLAUSE_ID
164: AND object_version_number = p_object_version_number;
165:
166: IF (SQL%NOTFOUND) THEN
167: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
168: END IF;
169:
170: UPDATE ams_iba_ps_cndclses_tl SET
171: cnd_clause_name = DECODE( p_CND_CLAUSE_NAME, FND_API.G_MISS_CHAR, cnd_clause_name, p_CND_CLAUSE_NAME),

Line 171: cnd_clause_name = DECODE( p_CND_CLAUSE_NAME, FND_API.G_MISS_CHAR, cnd_clause_name, p_CND_CLAUSE_NAME),

167: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
168: END IF;
169:
170: UPDATE ams_iba_ps_cndclses_tl SET
171: cnd_clause_name = DECODE( p_CND_CLAUSE_NAME, FND_API.G_MISS_CHAR, cnd_clause_name, p_CND_CLAUSE_NAME),
172: cnd_clause_description = DECODE( p_CND_CLAUSE_DESCRIPTION, FND_API.G_MISS_CHAR, cnd_clause_description, p_CND_CLAUSE_DESCRIPTION),
173: last_update_date = SYSDATE,
174: last_updated_by = FND_GLOBAL.user_id,
175: last_update_login = FND_GLOBAL.conc_login_id,

Line 172: cnd_clause_description = DECODE( p_CND_CLAUSE_DESCRIPTION, FND_API.G_MISS_CHAR, cnd_clause_description, p_CND_CLAUSE_DESCRIPTION),

168: END IF;
169:
170: UPDATE ams_iba_ps_cndclses_tl SET
171: cnd_clause_name = DECODE( p_CND_CLAUSE_NAME, FND_API.G_MISS_CHAR, cnd_clause_name, p_CND_CLAUSE_NAME),
172: cnd_clause_description = DECODE( p_CND_CLAUSE_DESCRIPTION, FND_API.G_MISS_CHAR, cnd_clause_description, p_CND_CLAUSE_DESCRIPTION),
173: last_update_date = SYSDATE,
174: last_updated_by = FND_GLOBAL.user_id,
175: last_update_login = FND_GLOBAL.conc_login_id,
176: source_lang = USERENV('LANG')

Line 209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

205: BEGIN
206: DELETE FROM AMS_IBA_PS_CNDCLSES_B
207: WHERE CND_CLAUSE_ID = p_CND_CLAUSE_ID;
208: If (SQL%NOTFOUND) then
209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
210: End If;
211:
212: DELETE FROM AMS_IBA_PS_CNDCLSES_TL
213: WHERE CND_CLAUSE_ID = p_CND_CLAUSE_ID;

Line 215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

211:
212: DELETE FROM AMS_IBA_PS_CNDCLSES_TL
213: WHERE CND_CLAUSE_ID = p_CND_CLAUSE_ID;
214: If (SQL%NOTFOUND) then
215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
216: End If;
217:
218: END Delete_Row ;
219: