APPS.AMS_IBA_PL_PARAMETERS_B_PKG dependencies on FND_API

Line 72: DECODE( px_parameter_id, FND_API.g_miss_num, NULL, px_parameter_id),

68: last_update_date,
69: last_update_login,
70: object_version_number
71: ) VALUES (
72: DECODE( px_parameter_id, FND_API.g_miss_num, NULL, px_parameter_id),
73: DECODE( p_site_id, FND_API.g_miss_num, NULL, p_site_id),
74: DECODE( p_site_ref_code, FND_API.g_miss_char, NULL, p_site_ref_code),
75: DECODE( p_parameter_ref_code, FND_API.g_miss_char, NULL, p_parameter_ref_code),
76: DECODE( p_execution_order, FND_API.g_miss_num, NULL, p_execution_order),

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

69: last_update_login,
70: object_version_number
71: ) VALUES (
72: DECODE( px_parameter_id, FND_API.g_miss_num, NULL, px_parameter_id),
73: DECODE( p_site_id, FND_API.g_miss_num, NULL, p_site_id),
74: DECODE( p_site_ref_code, FND_API.g_miss_char, NULL, p_site_ref_code),
75: DECODE( p_parameter_ref_code, FND_API.g_miss_char, NULL, p_parameter_ref_code),
76: DECODE( p_execution_order, FND_API.g_miss_num, NULL, p_execution_order),
77: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),

Line 74: DECODE( p_site_ref_code, FND_API.g_miss_char, NULL, p_site_ref_code),

70: object_version_number
71: ) VALUES (
72: DECODE( px_parameter_id, FND_API.g_miss_num, NULL, px_parameter_id),
73: DECODE( p_site_id, FND_API.g_miss_num, NULL, p_site_id),
74: DECODE( p_site_ref_code, FND_API.g_miss_char, NULL, p_site_ref_code),
75: DECODE( p_parameter_ref_code, FND_API.g_miss_char, NULL, p_parameter_ref_code),
76: DECODE( p_execution_order, FND_API.g_miss_num, NULL, p_execution_order),
77: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
78: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),

Line 75: DECODE( p_parameter_ref_code, FND_API.g_miss_char, NULL, p_parameter_ref_code),

71: ) VALUES (
72: DECODE( px_parameter_id, FND_API.g_miss_num, NULL, px_parameter_id),
73: DECODE( p_site_id, FND_API.g_miss_num, NULL, p_site_id),
74: DECODE( p_site_ref_code, FND_API.g_miss_char, NULL, p_site_ref_code),
75: DECODE( p_parameter_ref_code, FND_API.g_miss_char, NULL, p_parameter_ref_code),
76: DECODE( p_execution_order, FND_API.g_miss_num, NULL, p_execution_order),
77: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
78: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
79: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),

Line 76: DECODE( p_execution_order, FND_API.g_miss_num, NULL, p_execution_order),

72: DECODE( px_parameter_id, FND_API.g_miss_num, NULL, px_parameter_id),
73: DECODE( p_site_id, FND_API.g_miss_num, NULL, p_site_id),
74: DECODE( p_site_ref_code, FND_API.g_miss_char, NULL, p_site_ref_code),
75: DECODE( p_parameter_ref_code, FND_API.g_miss_char, NULL, p_parameter_ref_code),
76: DECODE( p_execution_order, FND_API.g_miss_num, NULL, p_execution_order),
77: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
78: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
79: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
80: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),

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

73: DECODE( p_site_id, FND_API.g_miss_num, NULL, p_site_id),
74: DECODE( p_site_ref_code, FND_API.g_miss_char, NULL, p_site_ref_code),
75: DECODE( p_parameter_ref_code, FND_API.g_miss_char, NULL, p_parameter_ref_code),
76: DECODE( p_execution_order, FND_API.g_miss_num, NULL, p_execution_order),
77: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
78: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
79: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
80: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
81: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),

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

74: DECODE( p_site_ref_code, FND_API.g_miss_char, NULL, p_site_ref_code),
75: DECODE( p_parameter_ref_code, FND_API.g_miss_char, NULL, p_parameter_ref_code),
76: DECODE( p_execution_order, FND_API.g_miss_num, NULL, p_execution_order),
77: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
78: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
79: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
80: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
81: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
82: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number));

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

75: DECODE( p_parameter_ref_code, FND_API.g_miss_char, NULL, p_parameter_ref_code),
76: DECODE( p_execution_order, FND_API.g_miss_num, NULL, p_execution_order),
77: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
78: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
79: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
80: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
81: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
82: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number));
83:

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

76: DECODE( p_execution_order, FND_API.g_miss_num, NULL, p_execution_order),
77: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
78: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
79: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
80: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
81: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
82: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number));
83:
84: insert into AMS_IBA_PL_PARAMETERS_TL (

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

77: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
78: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
79: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
80: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
81: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
82: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number));
83:
84: insert into AMS_IBA_PL_PARAMETERS_TL (
85: PARAMETER_ID,

Line 82: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number));

78: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
79: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
80: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
81: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
82: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number));
83:
84: insert into AMS_IBA_PL_PARAMETERS_TL (
85: PARAMETER_ID,
86: NAME,

Line 97: DECODE( px_parameter_id, FND_API.g_miss_num, NULL, px_parameter_id),

93: OBJECT_VERSION_NUMBER,
94: LANGUAGE,
95: SOURCE_LANG
96: ) select
97: DECODE( px_parameter_id, FND_API.g_miss_num, NULL, px_parameter_id),
98: DECODE( p_name, FND_API.g_miss_char, NULL, p_name),
99: DECODE( p_description, FND_API.g_miss_char, NULL, p_description),
100: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
101: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),

Line 98: DECODE( p_name, FND_API.g_miss_char, NULL, p_name),

94: LANGUAGE,
95: SOURCE_LANG
96: ) select
97: DECODE( px_parameter_id, FND_API.g_miss_num, NULL, px_parameter_id),
98: DECODE( p_name, FND_API.g_miss_char, NULL, p_name),
99: DECODE( p_description, FND_API.g_miss_char, NULL, p_description),
100: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
101: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
102: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),

Line 99: DECODE( p_description, FND_API.g_miss_char, NULL, p_description),

95: SOURCE_LANG
96: ) select
97: DECODE( px_parameter_id, FND_API.g_miss_num, NULL, px_parameter_id),
98: DECODE( p_name, FND_API.g_miss_char, NULL, p_name),
99: DECODE( p_description, FND_API.g_miss_char, NULL, p_description),
100: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
101: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
102: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
103: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),

Line 100: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),

96: ) select
97: DECODE( px_parameter_id, FND_API.g_miss_num, NULL, px_parameter_id),
98: DECODE( p_name, FND_API.g_miss_char, NULL, p_name),
99: DECODE( p_description, FND_API.g_miss_char, NULL, p_description),
100: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
101: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
102: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
103: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
104: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),

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

97: DECODE( px_parameter_id, FND_API.g_miss_num, NULL, px_parameter_id),
98: DECODE( p_name, FND_API.g_miss_char, NULL, p_name),
99: DECODE( p_description, FND_API.g_miss_char, NULL, p_description),
100: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
101: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
102: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
103: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
104: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
105: l.language_code,

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

98: DECODE( p_name, FND_API.g_miss_char, NULL, p_name),
99: DECODE( p_description, FND_API.g_miss_char, NULL, p_description),
100: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
101: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
102: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
103: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
104: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
105: l.language_code,
106: USERENV('LANG')

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

99: DECODE( p_description, FND_API.g_miss_char, NULL, p_description),
100: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
101: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
102: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
103: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
104: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
105: l.language_code,
106: USERENV('LANG')
107: from FND_LANGUAGES L

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

100: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
101: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
102: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
103: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
104: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
105: l.language_code,
106: USERENV('LANG')
107: from FND_LANGUAGES L
108: where L.INSTALLED_FLAG in ('I', 'B')

Line 112: where T.PARAMETER_ID = DECODE( px_parameter_id, FND_API.g_miss_num, NULL, px_parameter_id)

108: where L.INSTALLED_FLAG in ('I', 'B')
109: and not exists
110: (select NULL
111: from AMS_IBA_PL_PARAMETERS_TL T
112: where T.PARAMETER_ID = DECODE( px_parameter_id, FND_API.g_miss_num, NULL, px_parameter_id)
113: and T.LANGUAGE = L.LANGUAGE_CODE);
114:
115: END Insert_Row;
116:

Line 154: site_id = DECODE( p_site_id, FND_API.g_miss_num, site_id, p_site_id),

150: IS
151: BEGIN
152: Update AMS_IBA_PL_PARAMETERS_B
153: SET
154: site_id = DECODE( p_site_id, FND_API.g_miss_num, site_id, p_site_id),
155: site_ref_code = DECODE( p_site_ref_code, FND_API.g_miss_char, site_ref_code, p_site_ref_code),
156: parameter_ref_code = DECODE( p_parameter_ref_code, FND_API.g_miss_char, parameter_ref_code, p_parameter_ref_code),
157: execution_order = DECODE( p_execution_order, FND_API.g_miss_num, execution_order, p_execution_order),
158: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),

Line 155: site_ref_code = DECODE( p_site_ref_code, FND_API.g_miss_char, site_ref_code, p_site_ref_code),

151: BEGIN
152: Update AMS_IBA_PL_PARAMETERS_B
153: SET
154: site_id = DECODE( p_site_id, FND_API.g_miss_num, site_id, p_site_id),
155: site_ref_code = DECODE( p_site_ref_code, FND_API.g_miss_char, site_ref_code, p_site_ref_code),
156: parameter_ref_code = DECODE( p_parameter_ref_code, FND_API.g_miss_char, parameter_ref_code, p_parameter_ref_code),
157: execution_order = DECODE( p_execution_order, FND_API.g_miss_num, execution_order, p_execution_order),
158: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
159: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),

Line 156: parameter_ref_code = DECODE( p_parameter_ref_code, FND_API.g_miss_char, parameter_ref_code, p_parameter_ref_code),

152: Update AMS_IBA_PL_PARAMETERS_B
153: SET
154: site_id = DECODE( p_site_id, FND_API.g_miss_num, site_id, p_site_id),
155: site_ref_code = DECODE( p_site_ref_code, FND_API.g_miss_char, site_ref_code, p_site_ref_code),
156: parameter_ref_code = DECODE( p_parameter_ref_code, FND_API.g_miss_char, parameter_ref_code, p_parameter_ref_code),
157: execution_order = DECODE( p_execution_order, FND_API.g_miss_num, execution_order, p_execution_order),
158: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
159: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
160: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),

Line 157: execution_order = DECODE( p_execution_order, FND_API.g_miss_num, execution_order, p_execution_order),

153: SET
154: site_id = DECODE( p_site_id, FND_API.g_miss_num, site_id, p_site_id),
155: site_ref_code = DECODE( p_site_ref_code, FND_API.g_miss_char, site_ref_code, p_site_ref_code),
156: parameter_ref_code = DECODE( p_parameter_ref_code, FND_API.g_miss_char, parameter_ref_code, p_parameter_ref_code),
157: execution_order = DECODE( p_execution_order, FND_API.g_miss_num, execution_order, p_execution_order),
158: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
159: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
160: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
161: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number)

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

154: site_id = DECODE( p_site_id, FND_API.g_miss_num, site_id, p_site_id),
155: site_ref_code = DECODE( p_site_ref_code, FND_API.g_miss_char, site_ref_code, p_site_ref_code),
156: parameter_ref_code = DECODE( p_parameter_ref_code, FND_API.g_miss_char, parameter_ref_code, p_parameter_ref_code),
157: execution_order = DECODE( p_execution_order, FND_API.g_miss_num, execution_order, p_execution_order),
158: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
159: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
160: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
161: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number)
162: WHERE PARAMETER_ID = p_PARAMETER_ID

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

155: site_ref_code = DECODE( p_site_ref_code, FND_API.g_miss_char, site_ref_code, p_site_ref_code),
156: parameter_ref_code = DECODE( p_parameter_ref_code, FND_API.g_miss_char, parameter_ref_code, p_parameter_ref_code),
157: execution_order = DECODE( p_execution_order, FND_API.g_miss_num, execution_order, p_execution_order),
158: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
159: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
160: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
161: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number)
162: WHERE PARAMETER_ID = p_PARAMETER_ID
163: AND object_version_number = p_object_version_number;

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

156: parameter_ref_code = DECODE( p_parameter_ref_code, FND_API.g_miss_char, parameter_ref_code, p_parameter_ref_code),
157: execution_order = DECODE( p_execution_order, FND_API.g_miss_num, execution_order, p_execution_order),
158: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
159: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
160: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
161: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number)
162: WHERE PARAMETER_ID = p_PARAMETER_ID
163: AND object_version_number = p_object_version_number;
164:

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

157: execution_order = DECODE( p_execution_order, FND_API.g_miss_num, execution_order, p_execution_order),
158: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
159: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
160: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
161: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number)
162: WHERE PARAMETER_ID = p_PARAMETER_ID
163: AND object_version_number = p_object_version_number;
164:
165: IF (SQL%NOTFOUND) THEN

Line 171: name = DECODE(p_name,FND_API.g_miss_char,name,p_name),

167: END IF;
168:
169: UPDATE ams_iba_pl_parameters_tl
170: SET
171: name = DECODE(p_name,FND_API.g_miss_char,name,p_name),
172: description = DECODE(p_description,FND_API.g_miss_char,description,p_description),
173: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
174: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
175: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),

Line 172: description = DECODE(p_description,FND_API.g_miss_char,description,p_description),

168:
169: UPDATE ams_iba_pl_parameters_tl
170: SET
171: name = DECODE(p_name,FND_API.g_miss_char,name,p_name),
172: description = DECODE(p_description,FND_API.g_miss_char,description,p_description),
173: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
174: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
175: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
176: source_lang = userenv('LANG')

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

169: UPDATE ams_iba_pl_parameters_tl
170: SET
171: name = DECODE(p_name,FND_API.g_miss_char,name,p_name),
172: description = DECODE(p_description,FND_API.g_miss_char,description,p_description),
173: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
174: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
175: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
176: source_lang = userenv('LANG')
177: WHERE parameter_id = DECODE( p_parameter_id, FND_API.g_miss_num, parameter_id, p_parameter_id)

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

170: SET
171: name = DECODE(p_name,FND_API.g_miss_char,name,p_name),
172: description = DECODE(p_description,FND_API.g_miss_char,description,p_description),
173: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
174: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
175: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
176: source_lang = userenv('LANG')
177: WHERE parameter_id = DECODE( p_parameter_id, FND_API.g_miss_num, parameter_id, p_parameter_id)
178: AND USERENV('lang') IN (language, source_lang);

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

171: name = DECODE(p_name,FND_API.g_miss_char,name,p_name),
172: description = DECODE(p_description,FND_API.g_miss_char,description,p_description),
173: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
174: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
175: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
176: source_lang = userenv('LANG')
177: WHERE parameter_id = DECODE( p_parameter_id, FND_API.g_miss_num, parameter_id, p_parameter_id)
178: AND USERENV('lang') IN (language, source_lang);
179:

Line 177: WHERE parameter_id = DECODE( p_parameter_id, FND_API.g_miss_num, parameter_id, p_parameter_id)

173: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
174: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
175: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
176: source_lang = userenv('LANG')
177: WHERE parameter_id = DECODE( p_parameter_id, FND_API.g_miss_num, parameter_id, p_parameter_id)
178: AND USERENV('lang') IN (language, source_lang);
179:
180: IF (SQL%NOTFOUND) THEN
181: RAISE no_data_found;