APPS.AMS_MET_TPL_HEADERS_B_PKG dependencies on FND_API

Line 82: DECODE( px_metric_tpl_header_id, FND_API.g_miss_num, NULL, px_metric_tpl_header_id),

78: association_type,
79: used_by_id,
80: used_by_code
81: ) VALUES (
82: DECODE( px_metric_tpl_header_id, FND_API.g_miss_num, NULL, px_metric_tpl_header_id),
83: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
84: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
85: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
86: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),

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

79: used_by_id,
80: used_by_code
81: ) VALUES (
82: DECODE( px_metric_tpl_header_id, FND_API.g_miss_num, NULL, px_metric_tpl_header_id),
83: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
84: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
85: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
86: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
87: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),

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

80: used_by_code
81: ) VALUES (
82: DECODE( px_metric_tpl_header_id, FND_API.g_miss_num, NULL, px_metric_tpl_header_id),
83: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
84: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
85: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
86: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
87: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
88: 1, --DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),

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

81: ) VALUES (
82: DECODE( px_metric_tpl_header_id, FND_API.g_miss_num, NULL, px_metric_tpl_header_id),
83: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
84: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
85: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
86: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
87: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
88: 1, --DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
89: DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag),

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

82: DECODE( px_metric_tpl_header_id, FND_API.g_miss_num, NULL, px_metric_tpl_header_id),
83: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
84: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
85: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
86: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
87: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
88: 1, --DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
89: DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag),
90: DECODE( p_application_id, FND_API.g_miss_num, NULL, p_application_id),

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

83: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
84: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
85: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
86: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
87: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
88: 1, --DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
89: DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag),
90: DECODE( p_application_id, FND_API.g_miss_num, NULL, p_application_id),
91: DECODE( p_object_type, FND_API.g_miss_char, NULL, p_object_type),

Line 88: 1, --DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),

84: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
85: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
86: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
87: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
88: 1, --DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
89: DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag),
90: DECODE( p_application_id, FND_API.g_miss_num, NULL, p_application_id),
91: DECODE( p_object_type, FND_API.g_miss_char, NULL, p_object_type),
92: DECODE( p_association_type, FND_API.g_miss_char, NULL, p_association_type),

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

85: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
86: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
87: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
88: 1, --DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
89: DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag),
90: DECODE( p_application_id, FND_API.g_miss_num, NULL, p_application_id),
91: DECODE( p_object_type, FND_API.g_miss_char, NULL, p_object_type),
92: DECODE( p_association_type, FND_API.g_miss_char, NULL, p_association_type),
93: DECODE( p_used_by_id, FND_API.g_miss_num, NULL, p_used_by_id),

Line 90: DECODE( p_application_id, FND_API.g_miss_num, NULL, p_application_id),

86: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
87: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
88: 1, --DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
89: DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag),
90: DECODE( p_application_id, FND_API.g_miss_num, NULL, p_application_id),
91: DECODE( p_object_type, FND_API.g_miss_char, NULL, p_object_type),
92: DECODE( p_association_type, FND_API.g_miss_char, NULL, p_association_type),
93: DECODE( p_used_by_id, FND_API.g_miss_num, NULL, p_used_by_id),
94: DECODE( p_used_by_code, FND_API.g_miss_char, NULL, p_used_by_code));

Line 91: DECODE( p_object_type, FND_API.g_miss_char, NULL, p_object_type),

87: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
88: 1, --DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
89: DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag),
90: DECODE( p_application_id, FND_API.g_miss_num, NULL, p_application_id),
91: DECODE( p_object_type, FND_API.g_miss_char, NULL, p_object_type),
92: DECODE( p_association_type, FND_API.g_miss_char, NULL, p_association_type),
93: DECODE( p_used_by_id, FND_API.g_miss_num, NULL, p_used_by_id),
94: DECODE( p_used_by_code, FND_API.g_miss_char, NULL, p_used_by_code));
95:

Line 92: DECODE( p_association_type, FND_API.g_miss_char, NULL, p_association_type),

88: 1, --DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
89: DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag),
90: DECODE( p_application_id, FND_API.g_miss_num, NULL, p_application_id),
91: DECODE( p_object_type, FND_API.g_miss_char, NULL, p_object_type),
92: DECODE( p_association_type, FND_API.g_miss_char, NULL, p_association_type),
93: DECODE( p_used_by_id, FND_API.g_miss_num, NULL, p_used_by_id),
94: DECODE( p_used_by_code, FND_API.g_miss_char, NULL, p_used_by_code));
95:
96:

Line 93: DECODE( p_used_by_id, FND_API.g_miss_num, NULL, p_used_by_id),

89: DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag),
90: DECODE( p_application_id, FND_API.g_miss_num, NULL, p_application_id),
91: DECODE( p_object_type, FND_API.g_miss_char, NULL, p_object_type),
92: DECODE( p_association_type, FND_API.g_miss_char, NULL, p_association_type),
93: DECODE( p_used_by_id, FND_API.g_miss_num, NULL, p_used_by_id),
94: DECODE( p_used_by_code, FND_API.g_miss_char, NULL, p_used_by_code));
95:
96:
97: INSERT INTO AMS_MET_TPL_HEADERS_TL (

Line 94: DECODE( p_used_by_code, FND_API.g_miss_char, NULL, p_used_by_code));

90: DECODE( p_application_id, FND_API.g_miss_num, NULL, p_application_id),
91: DECODE( p_object_type, FND_API.g_miss_char, NULL, p_object_type),
92: DECODE( p_association_type, FND_API.g_miss_char, NULL, p_association_type),
93: DECODE( p_used_by_id, FND_API.g_miss_num, NULL, p_used_by_id),
94: DECODE( p_used_by_code, FND_API.g_miss_char, NULL, p_used_by_code));
95:
96:
97: INSERT INTO AMS_MET_TPL_HEADERS_TL (
98: METRIC_TPL_HEADER_ID ,

Line 109: DECODE( px_metric_tpl_header_id, FND_API.g_miss_num, NULL, px_metric_tpl_header_id),

105: SOURCE_LANG ,
106: METRIC_TPL_HEADER_NAME ,
107: DESCRIPTION
108: ) SELECT
109: DECODE( px_metric_tpl_header_id, FND_API.g_miss_num, NULL, px_metric_tpl_header_id),
110: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
111: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
112: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
113: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),

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

106: METRIC_TPL_HEADER_NAME ,
107: DESCRIPTION
108: ) SELECT
109: DECODE( px_metric_tpl_header_id, FND_API.g_miss_num, NULL, px_metric_tpl_header_id),
110: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
111: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
112: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
113: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
114: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),

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

107: DESCRIPTION
108: ) SELECT
109: DECODE( px_metric_tpl_header_id, FND_API.g_miss_num, NULL, px_metric_tpl_header_id),
110: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
111: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
112: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
113: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
114: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
115: L.LANGUAGE_CODE,

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

108: ) SELECT
109: DECODE( px_metric_tpl_header_id, FND_API.g_miss_num, NULL, px_metric_tpl_header_id),
110: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
111: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
112: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
113: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
114: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
115: L.LANGUAGE_CODE,
116: USERENV('LANG'),

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

109: DECODE( px_metric_tpl_header_id, FND_API.g_miss_num, NULL, px_metric_tpl_header_id),
110: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
111: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
112: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
113: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
114: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
115: L.LANGUAGE_CODE,
116: USERENV('LANG'),
117: DECODE( p_metric_tpl_header_name, FND_API.g_miss_char, NULL, p_metric_tpl_header_name),

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

110: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
111: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
112: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
113: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
114: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
115: L.LANGUAGE_CODE,
116: USERENV('LANG'),
117: DECODE( p_metric_tpl_header_name, FND_API.g_miss_char, NULL, p_metric_tpl_header_name),
118: DECODE( p_description, FND_API.g_miss_char, NULL, p_description)

Line 117: DECODE( p_metric_tpl_header_name, FND_API.g_miss_char, NULL, p_metric_tpl_header_name),

113: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
114: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
115: L.LANGUAGE_CODE,
116: USERENV('LANG'),
117: DECODE( p_metric_tpl_header_name, FND_API.g_miss_char, NULL, p_metric_tpl_header_name),
118: DECODE( p_description, FND_API.g_miss_char, NULL, p_description)
119: FROM FND_LANGUAGES L
120: WHERE L.INSTALLED_FLAG IN ('I', 'B')
121: AND NOT EXISTS

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

114: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
115: L.LANGUAGE_CODE,
116: USERENV('LANG'),
117: DECODE( p_metric_tpl_header_name, FND_API.g_miss_char, NULL, p_metric_tpl_header_name),
118: DECODE( p_description, FND_API.g_miss_char, NULL, p_description)
119: FROM FND_LANGUAGES L
120: WHERE L.INSTALLED_FLAG IN ('I', 'B')
121: AND NOT EXISTS
122: (SELECT NULL

Line 163: p_metric_tpl_header_id = FND_API.g_miss_num OR

159:
160: IS
161: BEGIN
162: IF p_metric_tpl_header_id IS NULL OR
163: p_metric_tpl_header_id = FND_API.g_miss_num OR
164: p_object_version_number IS NULL OR
165: p_object_version_number = FND_API.g_miss_num THEN
166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
167: END IF;

Line 165: p_object_version_number = FND_API.g_miss_num THEN

161: BEGIN
162: IF p_metric_tpl_header_id IS NULL OR
163: p_metric_tpl_header_id = FND_API.g_miss_num OR
164: p_object_version_number IS NULL OR
165: p_object_version_number = FND_API.g_miss_num THEN
166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
167: END IF;
168:
169: UPDATE AMS_MET_TPL_HEADERS_B

Line 166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

162: IF p_metric_tpl_header_id IS NULL OR
163: p_metric_tpl_header_id = FND_API.g_miss_num OR
164: p_object_version_number IS NULL OR
165: p_object_version_number = FND_API.g_miss_num THEN
166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
167: END IF;
168:
169: UPDATE AMS_MET_TPL_HEADERS_B
170: SET

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

167: END IF;
168:
169: UPDATE AMS_MET_TPL_HEADERS_B
170: SET
171: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
172: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
173: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
174: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag),
175: application_id = DECODE( p_application_id, FND_API.g_miss_num, application_id, p_application_id),

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

168:
169: UPDATE AMS_MET_TPL_HEADERS_B
170: SET
171: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
172: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
173: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
174: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag),
175: application_id = DECODE( p_application_id, FND_API.g_miss_num, application_id, p_application_id),
176: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),

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

169: UPDATE AMS_MET_TPL_HEADERS_B
170: SET
171: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
172: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
173: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
174: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag),
175: application_id = DECODE( p_application_id, FND_API.g_miss_num, application_id, p_application_id),
176: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
177: object_type = DECODE( p_object_type, FND_API.g_miss_char, object_type, p_object_type),

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

170: SET
171: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
172: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
173: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
174: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag),
175: application_id = DECODE( p_application_id, FND_API.g_miss_num, application_id, p_application_id),
176: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
177: object_type = DECODE( p_object_type, FND_API.g_miss_char, object_type, p_object_type),
178: association_type = DECODE( p_association_type, FND_API.g_miss_char, association_type, p_association_type),

Line 175: application_id = DECODE( p_application_id, FND_API.g_miss_num, application_id, p_application_id),

171: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
172: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
173: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
174: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag),
175: application_id = DECODE( p_application_id, FND_API.g_miss_num, application_id, p_application_id),
176: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
177: object_type = DECODE( p_object_type, FND_API.g_miss_char, object_type, p_object_type),
178: association_type = DECODE( p_association_type, FND_API.g_miss_char, association_type, p_association_type),
179: used_by_id = DECODE( p_used_by_id, FND_API.g_miss_num, used_by_id, p_used_by_id),

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

172: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
173: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
174: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag),
175: application_id = DECODE( p_application_id, FND_API.g_miss_num, application_id, p_application_id),
176: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
177: object_type = DECODE( p_object_type, FND_API.g_miss_char, object_type, p_object_type),
178: association_type = DECODE( p_association_type, FND_API.g_miss_char, association_type, p_association_type),
179: used_by_id = DECODE( p_used_by_id, FND_API.g_miss_num, used_by_id, p_used_by_id),
180: used_by_code = DECODE( p_used_by_code, FND_API.g_miss_char, used_by_code, p_used_by_code)

Line 177: object_type = DECODE( p_object_type, FND_API.g_miss_char, object_type, p_object_type),

173: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
174: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag),
175: application_id = DECODE( p_application_id, FND_API.g_miss_num, application_id, p_application_id),
176: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
177: object_type = DECODE( p_object_type, FND_API.g_miss_char, object_type, p_object_type),
178: association_type = DECODE( p_association_type, FND_API.g_miss_char, association_type, p_association_type),
179: used_by_id = DECODE( p_used_by_id, FND_API.g_miss_num, used_by_id, p_used_by_id),
180: used_by_code = DECODE( p_used_by_code, FND_API.g_miss_char, used_by_code, p_used_by_code)
181: WHERE METRIC_TPL_HEADER_ID = p_METRIC_TPL_HEADER_ID;

Line 178: association_type = DECODE( p_association_type, FND_API.g_miss_char, association_type, p_association_type),

174: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag),
175: application_id = DECODE( p_application_id, FND_API.g_miss_num, application_id, p_application_id),
176: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
177: object_type = DECODE( p_object_type, FND_API.g_miss_char, object_type, p_object_type),
178: association_type = DECODE( p_association_type, FND_API.g_miss_char, association_type, p_association_type),
179: used_by_id = DECODE( p_used_by_id, FND_API.g_miss_num, used_by_id, p_used_by_id),
180: used_by_code = DECODE( p_used_by_code, FND_API.g_miss_char, used_by_code, p_used_by_code)
181: WHERE METRIC_TPL_HEADER_ID = p_METRIC_TPL_HEADER_ID;
182: -- AND object_version_number = p_object_version_number;

Line 179: used_by_id = DECODE( p_used_by_id, FND_API.g_miss_num, used_by_id, p_used_by_id),

175: application_id = DECODE( p_application_id, FND_API.g_miss_num, application_id, p_application_id),
176: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
177: object_type = DECODE( p_object_type, FND_API.g_miss_char, object_type, p_object_type),
178: association_type = DECODE( p_association_type, FND_API.g_miss_char, association_type, p_association_type),
179: used_by_id = DECODE( p_used_by_id, FND_API.g_miss_num, used_by_id, p_used_by_id),
180: used_by_code = DECODE( p_used_by_code, FND_API.g_miss_char, used_by_code, p_used_by_code)
181: WHERE METRIC_TPL_HEADER_ID = p_METRIC_TPL_HEADER_ID;
182: -- AND object_version_number = p_object_version_number;
183:

Line 180: used_by_code = DECODE( p_used_by_code, FND_API.g_miss_char, used_by_code, p_used_by_code)

176: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
177: object_type = DECODE( p_object_type, FND_API.g_miss_char, object_type, p_object_type),
178: association_type = DECODE( p_association_type, FND_API.g_miss_char, association_type, p_association_type),
179: used_by_id = DECODE( p_used_by_id, FND_API.g_miss_num, used_by_id, p_used_by_id),
180: used_by_code = DECODE( p_used_by_code, FND_API.g_miss_char, used_by_code, p_used_by_code)
181: WHERE METRIC_TPL_HEADER_ID = p_METRIC_TPL_HEADER_ID;
182: -- AND object_version_number = p_object_version_number;
183:
184: IF (SQL%NOTFOUND) THEN

Line 185: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

181: WHERE METRIC_TPL_HEADER_ID = p_METRIC_TPL_HEADER_ID;
182: -- AND object_version_number = p_object_version_number;
183:
184: IF (SQL%NOTFOUND) THEN
185: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
186: END IF;
187:
188: UPDATE AMS_MET_TPL_HEADERS_TL SET
189: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),

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

185: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
186: END IF;
187:
188: UPDATE AMS_MET_TPL_HEADERS_TL SET
189: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
190: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
191: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
192: SOURCE_LANG = USERENV('LANG'),
193: metric_tpl_header_name = DECODE( p_metric_tpl_header_name, FND_API.g_miss_char, metric_tpl_header_name, p_metric_tpl_header_name),

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

186: END IF;
187:
188: UPDATE AMS_MET_TPL_HEADERS_TL SET
189: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
190: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
191: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
192: SOURCE_LANG = USERENV('LANG'),
193: metric_tpl_header_name = DECODE( p_metric_tpl_header_name, FND_API.g_miss_char, metric_tpl_header_name, p_metric_tpl_header_name),
194: description = DECODE( p_description, FND_API.g_miss_char, description, p_description)

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

187:
188: UPDATE AMS_MET_TPL_HEADERS_TL SET
189: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
190: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
191: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
192: SOURCE_LANG = USERENV('LANG'),
193: metric_tpl_header_name = DECODE( p_metric_tpl_header_name, FND_API.g_miss_char, metric_tpl_header_name, p_metric_tpl_header_name),
194: description = DECODE( p_description, FND_API.g_miss_char, description, p_description)
195: WHERE METRIC_TPL_HEADER_ID = p_METRIC_TPL_HEADER_ID

Line 193: metric_tpl_header_name = DECODE( p_metric_tpl_header_name, FND_API.g_miss_char, metric_tpl_header_name, p_metric_tpl_header_name),

189: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
190: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
191: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
192: SOURCE_LANG = USERENV('LANG'),
193: metric_tpl_header_name = DECODE( p_metric_tpl_header_name, FND_API.g_miss_char, metric_tpl_header_name, p_metric_tpl_header_name),
194: description = DECODE( p_description, FND_API.g_miss_char, description, p_description)
195: WHERE METRIC_TPL_HEADER_ID = p_METRIC_TPL_HEADER_ID
196: AND USERENV('LANG') IN (LANGUAGE, SOURCE_LANG);
197:

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

190: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
191: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
192: SOURCE_LANG = USERENV('LANG'),
193: metric_tpl_header_name = DECODE( p_metric_tpl_header_name, FND_API.g_miss_char, metric_tpl_header_name, p_metric_tpl_header_name),
194: description = DECODE( p_description, FND_API.g_miss_char, description, p_description)
195: WHERE METRIC_TPL_HEADER_ID = p_METRIC_TPL_HEADER_ID
196: AND USERENV('LANG') IN (LANGUAGE, SOURCE_LANG);
197:
198: IF (SQL%NOTFOUND) THEN

Line 199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

195: WHERE METRIC_TPL_HEADER_ID = p_METRIC_TPL_HEADER_ID
196: AND USERENV('LANG') IN (LANGUAGE, SOURCE_LANG);
197:
198: IF (SQL%NOTFOUND) THEN
199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
200: END IF;
201:
202: END Update_Row;
203:

Line 228: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

224: BEGIN
225: DELETE FROM AMS_MET_TPL_HEADERS_B
226: WHERE METRIC_TPL_HEADER_ID = p_METRIC_TPL_HEADER_ID;
227: IF (SQL%NOTFOUND) THEN
228: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
229: END IF;
230: DELETE FROM AMS_MET_TPL_HEADERS_TL
231: WHERE METRIC_TPL_HEADER_ID = p_METRIC_TPL_HEADER_ID;
232: IF (SQL%NOTFOUND) THEN

Line 233: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

229: END IF;
230: DELETE FROM AMS_MET_TPL_HEADERS_TL
231: WHERE METRIC_TPL_HEADER_ID = p_METRIC_TPL_HEADER_ID;
232: IF (SQL%NOTFOUND) THEN
233: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
234: END IF;
235: END Delete_Row ;
236:
237: