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_LIST_SRC_TYPE_ASSOCS_PKG dependencies on FND_API

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

78: enabled_flag,
79: description,
80: master_source_type_pk_column
81: ) VALUES (
82: DECODE( px_list_source_type_assoc_id, FND_API.g_miss_num, NULL, px_list_source_type_assoc_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: description,
80: master_source_type_pk_column
81: ) VALUES (
82: DECODE( px_list_source_type_assoc_id, FND_API.g_miss_num, NULL, px_list_source_type_assoc_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: master_source_type_pk_column
81: ) VALUES (
82: DECODE( px_list_source_type_assoc_id, FND_API.g_miss_num, NULL, px_list_source_type_assoc_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: 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_list_source_type_assoc_id, FND_API.g_miss_num, NULL, px_list_source_type_assoc_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: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
89: DECODE( p_master_source_type_id, FND_API.g_miss_num, NULL, p_master_source_type_id),

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

82: DECODE( px_list_source_type_assoc_id, FND_API.g_miss_num, NULL, px_list_source_type_assoc_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: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
89: DECODE( p_master_source_type_id, FND_API.g_miss_num, NULL, p_master_source_type_id),
90: DECODE( p_sub_source_type_id, FND_API.g_miss_num, NULL, p_sub_source_type_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: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
89: DECODE( p_master_source_type_id, FND_API.g_miss_num, NULL, p_master_source_type_id),
90: DECODE( p_sub_source_type_id, FND_API.g_miss_num, NULL, p_sub_source_type_id),
91: DECODE( p_sub_source_type_pk_column, FND_API.g_miss_char, NULL, p_sub_source_type_pk_column),

Line 88: 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: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
89: DECODE( p_master_source_type_id, FND_API.g_miss_num, NULL, p_master_source_type_id),
90: DECODE( p_sub_source_type_id, FND_API.g_miss_num, NULL, p_sub_source_type_id),
91: DECODE( p_sub_source_type_pk_column, FND_API.g_miss_char, NULL, p_sub_source_type_pk_column),
92: DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag),

Line 89: DECODE( p_master_source_type_id, FND_API.g_miss_num, NULL, p_master_source_type_id),

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: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
89: DECODE( p_master_source_type_id, FND_API.g_miss_num, NULL, p_master_source_type_id),
90: DECODE( p_sub_source_type_id, FND_API.g_miss_num, NULL, p_sub_source_type_id),
91: DECODE( p_sub_source_type_pk_column, FND_API.g_miss_char, NULL, p_sub_source_type_pk_column),
92: DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag),
93: DECODE( p_description, FND_API.g_miss_char, NULL, p_description),

Line 90: DECODE( p_sub_source_type_id, FND_API.g_miss_num, NULL, p_sub_source_type_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: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
89: DECODE( p_master_source_type_id, FND_API.g_miss_num, NULL, p_master_source_type_id),
90: DECODE( p_sub_source_type_id, FND_API.g_miss_num, NULL, p_sub_source_type_id),
91: DECODE( p_sub_source_type_pk_column, FND_API.g_miss_char, NULL, p_sub_source_type_pk_column),
92: DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag),
93: DECODE( p_description, FND_API.g_miss_char, NULL, p_description),
94: DECODE( p_master_source_type_pk_column, FND_API.g_miss_char, NULL, p_master_source_type_pk_column));

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

87: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
88: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
89: DECODE( p_master_source_type_id, FND_API.g_miss_num, NULL, p_master_source_type_id),
90: DECODE( p_sub_source_type_id, FND_API.g_miss_num, NULL, p_sub_source_type_id),
91: DECODE( p_sub_source_type_pk_column, FND_API.g_miss_char, NULL, p_sub_source_type_pk_column),
92: DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag),
93: DECODE( p_description, FND_API.g_miss_char, NULL, p_description),
94: DECODE( p_master_source_type_pk_column, FND_API.g_miss_char, NULL, p_master_source_type_pk_column));
95: END Insert_Row;

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

88: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
89: DECODE( p_master_source_type_id, FND_API.g_miss_num, NULL, p_master_source_type_id),
90: DECODE( p_sub_source_type_id, FND_API.g_miss_num, NULL, p_sub_source_type_id),
91: DECODE( p_sub_source_type_pk_column, FND_API.g_miss_char, NULL, p_sub_source_type_pk_column),
92: DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag),
93: DECODE( p_description, FND_API.g_miss_char, NULL, p_description),
94: DECODE( p_master_source_type_pk_column, FND_API.g_miss_char, NULL, p_master_source_type_pk_column));
95: END Insert_Row;
96:

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

89: DECODE( p_master_source_type_id, FND_API.g_miss_num, NULL, p_master_source_type_id),
90: DECODE( p_sub_source_type_id, FND_API.g_miss_num, NULL, p_sub_source_type_id),
91: DECODE( p_sub_source_type_pk_column, FND_API.g_miss_char, NULL, p_sub_source_type_pk_column),
92: DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag),
93: DECODE( p_description, FND_API.g_miss_char, NULL, p_description),
94: DECODE( p_master_source_type_pk_column, FND_API.g_miss_char, NULL, p_master_source_type_pk_column));
95: END Insert_Row;
96:
97:

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

90: DECODE( p_sub_source_type_id, FND_API.g_miss_num, NULL, p_sub_source_type_id),
91: DECODE( p_sub_source_type_pk_column, FND_API.g_miss_char, NULL, p_sub_source_type_pk_column),
92: DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag),
93: DECODE( p_description, FND_API.g_miss_char, NULL, p_description),
94: DECODE( p_master_source_type_pk_column, FND_API.g_miss_char, NULL, p_master_source_type_pk_column));
95: END Insert_Row;
96:
97:
98: ----------------------------------------------------------

Line 133: list_source_type_assoc_id = DECODE( p_list_source_type_assoc_id, FND_API.g_miss_num, list_source_type_assoc_id, p_list_source_type_assoc_id),

129: IS
130: BEGIN
131: Update AMS_LIST_SRC_TYPE_ASSOCS
132: SET
133: list_source_type_assoc_id = DECODE( p_list_source_type_assoc_id, FND_API.g_miss_num, list_source_type_assoc_id, p_list_source_type_assoc_id),
134: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
135: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
136: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
137: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),

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

130: BEGIN
131: Update AMS_LIST_SRC_TYPE_ASSOCS
132: SET
133: list_source_type_assoc_id = DECODE( p_list_source_type_assoc_id, FND_API.g_miss_num, list_source_type_assoc_id, p_list_source_type_assoc_id),
134: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
135: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
136: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
137: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
138: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),

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

131: Update AMS_LIST_SRC_TYPE_ASSOCS
132: SET
133: list_source_type_assoc_id = DECODE( p_list_source_type_assoc_id, FND_API.g_miss_num, list_source_type_assoc_id, p_list_source_type_assoc_id),
134: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
135: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
136: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
137: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
138: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
139: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),

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

132: SET
133: list_source_type_assoc_id = DECODE( p_list_source_type_assoc_id, FND_API.g_miss_num, list_source_type_assoc_id, p_list_source_type_assoc_id),
134: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
135: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
136: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
137: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
138: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
139: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
140: master_source_type_id = DECODE( p_master_source_type_id, FND_API.g_miss_num, master_source_type_id, p_master_source_type_id),

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

133: list_source_type_assoc_id = DECODE( p_list_source_type_assoc_id, FND_API.g_miss_num, list_source_type_assoc_id, p_list_source_type_assoc_id),
134: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
135: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
136: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
137: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
138: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
139: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
140: master_source_type_id = DECODE( p_master_source_type_id, FND_API.g_miss_num, master_source_type_id, p_master_source_type_id),
141: sub_source_type_id = DECODE( p_sub_source_type_id, FND_API.g_miss_num, sub_source_type_id, p_sub_source_type_id),

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

134: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
135: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
136: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
137: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
138: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
139: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
140: master_source_type_id = DECODE( p_master_source_type_id, FND_API.g_miss_num, master_source_type_id, p_master_source_type_id),
141: sub_source_type_id = DECODE( p_sub_source_type_id, FND_API.g_miss_num, sub_source_type_id, p_sub_source_type_id),
142: sub_source_type_pk_column = DECODE( p_sub_source_type_pk_column, FND_API.g_miss_char, sub_source_type_pk_column, p_sub_source_type_pk_column),

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

135: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
136: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
137: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
138: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
139: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
140: master_source_type_id = DECODE( p_master_source_type_id, FND_API.g_miss_num, master_source_type_id, p_master_source_type_id),
141: sub_source_type_id = DECODE( p_sub_source_type_id, FND_API.g_miss_num, sub_source_type_id, p_sub_source_type_id),
142: sub_source_type_pk_column = DECODE( p_sub_source_type_pk_column, FND_API.g_miss_char, sub_source_type_pk_column, p_sub_source_type_pk_column),
143: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag),

Line 140: master_source_type_id = DECODE( p_master_source_type_id, FND_API.g_miss_num, master_source_type_id, p_master_source_type_id),

136: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
137: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
138: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
139: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
140: master_source_type_id = DECODE( p_master_source_type_id, FND_API.g_miss_num, master_source_type_id, p_master_source_type_id),
141: sub_source_type_id = DECODE( p_sub_source_type_id, FND_API.g_miss_num, sub_source_type_id, p_sub_source_type_id),
142: sub_source_type_pk_column = DECODE( p_sub_source_type_pk_column, FND_API.g_miss_char, sub_source_type_pk_column, p_sub_source_type_pk_column),
143: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag),
144: description = DECODE( p_description, FND_API.g_miss_char, description, p_description),

Line 141: sub_source_type_id = DECODE( p_sub_source_type_id, FND_API.g_miss_num, sub_source_type_id, p_sub_source_type_id),

137: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
138: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
139: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
140: master_source_type_id = DECODE( p_master_source_type_id, FND_API.g_miss_num, master_source_type_id, p_master_source_type_id),
141: sub_source_type_id = DECODE( p_sub_source_type_id, FND_API.g_miss_num, sub_source_type_id, p_sub_source_type_id),
142: sub_source_type_pk_column = DECODE( p_sub_source_type_pk_column, FND_API.g_miss_char, sub_source_type_pk_column, p_sub_source_type_pk_column),
143: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag),
144: description = DECODE( p_description, FND_API.g_miss_char, description, p_description),
145: master_source_type_pk_column= DECODE( p_master_source_type_pk_column, FND_API.g_miss_char, master_source_type_pk_column, p_master_source_type_pk_column)

Line 142: sub_source_type_pk_column = DECODE( p_sub_source_type_pk_column, FND_API.g_miss_char, sub_source_type_pk_column, p_sub_source_type_pk_column),

138: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
139: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
140: master_source_type_id = DECODE( p_master_source_type_id, FND_API.g_miss_num, master_source_type_id, p_master_source_type_id),
141: sub_source_type_id = DECODE( p_sub_source_type_id, FND_API.g_miss_num, sub_source_type_id, p_sub_source_type_id),
142: sub_source_type_pk_column = DECODE( p_sub_source_type_pk_column, FND_API.g_miss_char, sub_source_type_pk_column, p_sub_source_type_pk_column),
143: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag),
144: description = DECODE( p_description, FND_API.g_miss_char, description, p_description),
145: master_source_type_pk_column= DECODE( p_master_source_type_pk_column, FND_API.g_miss_char, master_source_type_pk_column, p_master_source_type_pk_column)
146: WHERE LIST_SOURCE_TYPE_ASSOC_ID = p_LIST_SOURCE_TYPE_ASSOC_ID

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

139: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
140: master_source_type_id = DECODE( p_master_source_type_id, FND_API.g_miss_num, master_source_type_id, p_master_source_type_id),
141: sub_source_type_id = DECODE( p_sub_source_type_id, FND_API.g_miss_num, sub_source_type_id, p_sub_source_type_id),
142: sub_source_type_pk_column = DECODE( p_sub_source_type_pk_column, FND_API.g_miss_char, sub_source_type_pk_column, p_sub_source_type_pk_column),
143: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag),
144: description = DECODE( p_description, FND_API.g_miss_char, description, p_description),
145: master_source_type_pk_column= DECODE( p_master_source_type_pk_column, FND_API.g_miss_char, master_source_type_pk_column, p_master_source_type_pk_column)
146: WHERE LIST_SOURCE_TYPE_ASSOC_ID = p_LIST_SOURCE_TYPE_ASSOC_ID
147: AND object_version_number = p_object_version_number;

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

140: master_source_type_id = DECODE( p_master_source_type_id, FND_API.g_miss_num, master_source_type_id, p_master_source_type_id),
141: sub_source_type_id = DECODE( p_sub_source_type_id, FND_API.g_miss_num, sub_source_type_id, p_sub_source_type_id),
142: sub_source_type_pk_column = DECODE( p_sub_source_type_pk_column, FND_API.g_miss_char, sub_source_type_pk_column, p_sub_source_type_pk_column),
143: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag),
144: description = DECODE( p_description, FND_API.g_miss_char, description, p_description),
145: master_source_type_pk_column= DECODE( p_master_source_type_pk_column, FND_API.g_miss_char, master_source_type_pk_column, p_master_source_type_pk_column)
146: WHERE LIST_SOURCE_TYPE_ASSOC_ID = p_LIST_SOURCE_TYPE_ASSOC_ID
147: AND object_version_number = p_object_version_number;
148:

Line 145: master_source_type_pk_column= DECODE( p_master_source_type_pk_column, FND_API.g_miss_char, master_source_type_pk_column, p_master_source_type_pk_column)

141: sub_source_type_id = DECODE( p_sub_source_type_id, FND_API.g_miss_num, sub_source_type_id, p_sub_source_type_id),
142: sub_source_type_pk_column = DECODE( p_sub_source_type_pk_column, FND_API.g_miss_char, sub_source_type_pk_column, p_sub_source_type_pk_column),
143: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag),
144: description = DECODE( p_description, FND_API.g_miss_char, description, p_description),
145: master_source_type_pk_column= DECODE( p_master_source_type_pk_column, FND_API.g_miss_char, master_source_type_pk_column, p_master_source_type_pk_column)
146: WHERE LIST_SOURCE_TYPE_ASSOC_ID = p_LIST_SOURCE_TYPE_ASSOC_ID
147: AND object_version_number = p_object_version_number;
148:
149: IF (SQL%NOTFOUND) THEN

Line 150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

146: WHERE LIST_SOURCE_TYPE_ASSOC_ID = p_LIST_SOURCE_TYPE_ASSOC_ID
147: AND object_version_number = p_object_version_number;
148:
149: IF (SQL%NOTFOUND) THEN
150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
151: END IF;
152: END Update_Row;
153:
154:

Line 178: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

174: BEGIN
175: DELETE FROM AMS_LIST_SRC_TYPE_ASSOCS
176: WHERE LIST_SOURCE_TYPE_ASSOC_ID = p_LIST_SOURCE_TYPE_ASSOC_ID;
177: If (SQL%NOTFOUND) then
178: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
179: End If;
180: END Delete_Row ;
181:
182: