[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT AMS_IMP_SOURCE_LINES_s.NEXTVAL
FROM dual;
SELECT 1
FROM AMS_IMP_SOURCE_LINES
WHERE IMPORT_SOURCE_LINE_ID = l_id;
AMS_IMP_SOURCE_LINES_PKG.Insert_Row(
px_import_source_line_id => l_import_source_line_id,
px_object_version_number => l_object_version_number,
p_last_update_date => SYSDATE,
p_last_updated_by => FND_GLOBAL.USER_ID,
p_creation_date => SYSDATE,
p_created_by => FND_GLOBAL.USER_ID,
p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
p_import_list_header_id => p_is_line_rec.import_list_header_id,
p_import_successful_flag => p_is_line_rec.import_successful_flag,
p_enabled_flag => p_is_line_rec.enabled_flag,
p_import_failure_reason => p_is_line_rec.import_failure_reason,
p_re_import_last_done_date => p_is_line_rec.re_import_last_done_date,
p_party_id => p_is_line_rec.party_id,
p_dedupe_key => p_is_line_rec.dedupe_key,
p_col1 => p_is_line_rec.col1,
p_col2 => p_is_line_rec.col2,
p_col3 => p_is_line_rec.col3,
p_col4 => p_is_line_rec.col4,
p_col5 => p_is_line_rec.col5,
p_col6 => p_is_line_rec.col6,
p_col7 => p_is_line_rec.col7,
p_col8 => p_is_line_rec.col8,
p_col9 => p_is_line_rec.col9,
p_col10 => p_is_line_rec.col10,
p_col11 => p_is_line_rec.col11,
p_col12 => p_is_line_rec.col12,
p_col13 => p_is_line_rec.col13,
p_col14 => p_is_line_rec.col14,
p_col15 => p_is_line_rec.col15,
p_col16 => p_is_line_rec.col16,
p_col17 => p_is_line_rec.col17,
p_col18 => p_is_line_rec.col18,
p_col19 => p_is_line_rec.col19,
p_col20 => p_is_line_rec.col20,
p_col21 => p_is_line_rec.col21,
p_col22 => p_is_line_rec.col22,
p_col23 => p_is_line_rec.col23,
p_col24 => p_is_line_rec.col24,
p_col25 => p_is_line_rec.col25,
p_col26 => p_is_line_rec.col26,
p_col27 => p_is_line_rec.col27,
p_col28 => p_is_line_rec.col28,
p_col29 => p_is_line_rec.col29,
p_col30 => p_is_line_rec.col30,
p_col31 => p_is_line_rec.col31,
p_col32 => p_is_line_rec.col32,
p_col33 => p_is_line_rec.col33,
p_col34 => p_is_line_rec.col34,
p_col35 => p_is_line_rec.col35,
p_col36 => p_is_line_rec.col36,
p_col37 => p_is_line_rec.col37,
p_col38 => p_is_line_rec.col38,
p_col39 => p_is_line_rec.col39,
p_col40 => p_is_line_rec.col40,
p_col41 => p_is_line_rec.col41,
p_col42 => p_is_line_rec.col42,
p_col43 => p_is_line_rec.col43,
p_col44 => p_is_line_rec.col44,
p_col45 => p_is_line_rec.col45,
p_col46 => p_is_line_rec.col46,
p_col47 => p_is_line_rec.col47,
p_col48 => p_is_line_rec.col48,
p_col49 => p_is_line_rec.col49,
p_col50 => p_is_line_rec.col50,
p_col51 => p_is_line_rec.col51,
p_col52 => p_is_line_rec.col52,
p_col53 => p_is_line_rec.col53,
p_col54 => p_is_line_rec.col54,
p_col55 => p_is_line_rec.col55,
p_col56 => p_is_line_rec.col56,
p_col57 => p_is_line_rec.col57,
p_col58 => p_is_line_rec.col58,
p_col59 => p_is_line_rec.col59,
p_col60 => p_is_line_rec.col60,
p_col61 => p_is_line_rec.col61,
p_col62 => p_is_line_rec.col62,
p_col63 => p_is_line_rec.col63,
p_col64 => p_is_line_rec.col64,
p_col65 => p_is_line_rec.col65,
p_col66 => p_is_line_rec.col66,
p_col67 => p_is_line_rec.col67,
p_col68 => p_is_line_rec.col68,
p_col69 => p_is_line_rec.col69,
p_col70 => p_is_line_rec.col70,
p_col71 => p_is_line_rec.col71,
p_col72 => p_is_line_rec.col72,
p_col73 => p_is_line_rec.col73,
p_col74 => p_is_line_rec.col74,
p_col75 => p_is_line_rec.col75,
p_col76 => p_is_line_rec.col76,
p_col77 => p_is_line_rec.col77,
p_col78 => p_is_line_rec.col78,
p_col79 => p_is_line_rec.col79,
p_col80 => p_is_line_rec.col80,
p_col81 => p_is_line_rec.col81,
p_col82 => p_is_line_rec.col82,
p_col83 => p_is_line_rec.col83,
p_col84 => p_is_line_rec.col84,
p_col85 => p_is_line_rec.col85,
p_col86 => p_is_line_rec.col86,
p_col87 => p_is_line_rec.col87,
p_col88 => p_is_line_rec.col88,
p_col89 => p_is_line_rec.col89,
p_col90 => p_is_line_rec.col90,
p_col91 => p_is_line_rec.col91,
p_col92 => p_is_line_rec.col92,
p_col93 => p_is_line_rec.col93,
p_col94 => p_is_line_rec.col94,
p_col95 => p_is_line_rec.col95,
p_col96 => p_is_line_rec.col96,
p_col97 => p_is_line_rec.col97,
p_col98 => p_is_line_rec.col98,
p_col99 => p_is_line_rec.col99,
p_col100 => p_is_line_rec.col100,
p_col101 => p_is_line_rec.col101,
p_col102 => p_is_line_rec.col102,
p_col103 => p_is_line_rec.col103,
p_col104 => p_is_line_rec.col104,
p_col105 => p_is_line_rec.col105,
p_col106 => p_is_line_rec.col106,
p_col107 => p_is_line_rec.col107,
p_col108 => p_is_line_rec.col108,
p_col109 => p_is_line_rec.col109,
p_col110 => p_is_line_rec.col110,
p_col111 => p_is_line_rec.col111,
p_col112 => p_is_line_rec.col112,
p_col113 => p_is_line_rec.col113,
p_col114 => p_is_line_rec.col114,
p_col115 => p_is_line_rec.col115,
p_col116 => p_is_line_rec.col116,
p_col117 => p_is_line_rec.col117,
p_col118 => p_is_line_rec.col118,
p_col119 => p_is_line_rec.col119,
p_col120 => p_is_line_rec.col120,
p_col121 => p_is_line_rec.col121,
p_col122 => p_is_line_rec.col122,
p_col123 => p_is_line_rec.col123,
p_col124 => p_is_line_rec.col124,
p_col125 => p_is_line_rec.col125,
p_col126 => p_is_line_rec.col126,
p_col127 => p_is_line_rec.col127,
p_col128 => p_is_line_rec.col128,
p_col129 => p_is_line_rec.col129,
p_col130 => p_is_line_rec.col130,
p_col131 => p_is_line_rec.col131,
p_col132 => p_is_line_rec.col132,
p_col133 => p_is_line_rec.col133,
p_col134 => p_is_line_rec.col134,
p_col135 => p_is_line_rec.col135,
p_col136 => p_is_line_rec.col136,
p_col137 => p_is_line_rec.col137,
p_col138 => p_is_line_rec.col138,
p_col139 => p_is_line_rec.col139,
p_col140 => p_is_line_rec.col140,
p_col141 => p_is_line_rec.col141,
p_col142 => p_is_line_rec.col142,
p_col143 => p_is_line_rec.col143,
p_col144 => p_is_line_rec.col144,
p_col145 => p_is_line_rec.col145,
p_col146 => p_is_line_rec.col146,
p_col147 => p_is_line_rec.col147,
p_col148 => p_is_line_rec.col148,
p_col149 => p_is_line_rec.col149,
p_col150 => p_is_line_rec.col150,
p_col151 => p_is_line_rec.col151,
p_col152 => p_is_line_rec.col152,
p_col153 => p_is_line_rec.col153,
p_col154 => p_is_line_rec.col154,
p_col155 => p_is_line_rec.col155,
p_col156 => p_is_line_rec.col156,
p_col157 => p_is_line_rec.col157,
p_col158 => p_is_line_rec.col158,
p_col159 => p_is_line_rec.col159,
p_col160 => p_is_line_rec.col160,
p_col161 => p_is_line_rec.col161,
p_col162 => p_is_line_rec.col162,
p_col163 => p_is_line_rec.col163,
p_col164 => p_is_line_rec.col164,
p_col165 => p_is_line_rec.col165,
p_col166 => p_is_line_rec.col166,
p_col167 => p_is_line_rec.col167,
p_col168 => p_is_line_rec.col168,
p_col169 => p_is_line_rec.col169,
p_col170 => p_is_line_rec.col170,
p_col171 => p_is_line_rec.col171,
p_col172 => p_is_line_rec.col172,
p_col173 => p_is_line_rec.col173,
p_col174 => p_is_line_rec.col174,
p_col175 => p_is_line_rec.col175,
p_col176 => p_is_line_rec.col176,
p_col177 => p_is_line_rec.col177,
p_col178 => p_is_line_rec.col178,
p_col179 => p_is_line_rec.col179,
p_col180 => p_is_line_rec.col180,
p_col181 => p_is_line_rec.col181,
p_col182 => p_is_line_rec.col182,
p_col183 => p_is_line_rec.col183,
p_col184 => p_is_line_rec.col184,
p_col185 => p_is_line_rec.col185,
p_col186 => p_is_line_rec.col186,
p_col187 => p_is_line_rec.col187,
p_col188 => p_is_line_rec.col188,
p_col189 => p_is_line_rec.col189,
p_col190 => p_is_line_rec.col190,
p_col191 => p_is_line_rec.col191,
p_col192 => p_is_line_rec.col192,
p_col193 => p_is_line_rec.col193,
p_col194 => p_is_line_rec.col194,
p_col195 => p_is_line_rec.col195,
p_col196 => p_is_line_rec.col196,
p_col197 => p_is_line_rec.col197,
p_col198 => p_is_line_rec.col198,
p_col199 => p_is_line_rec.col199,
p_col200 => p_is_line_rec.col200,
p_col201 => p_is_line_rec.col201,
p_col202 => p_is_line_rec.col202,
p_col203 => p_is_line_rec.col203,
p_col204 => p_is_line_rec.col204,
p_col205 => p_is_line_rec.col205,
p_col206 => p_is_line_rec.col206,
p_col207 => p_is_line_rec.col207,
p_col208 => p_is_line_rec.col208,
p_col209 => p_is_line_rec.col209,
p_col210 => p_is_line_rec.col210,
p_col211 => p_is_line_rec.col211,
p_col212 => p_is_line_rec.col212,
p_col213 => p_is_line_rec.col213,
p_col214 => p_is_line_rec.col214,
p_col215 => p_is_line_rec.col215,
p_col216 => p_is_line_rec.col216,
p_col217 => p_is_line_rec.col217,
p_col218 => p_is_line_rec.col218,
p_col219 => p_is_line_rec.col219,
p_col220 => p_is_line_rec.col220,
p_col221 => p_is_line_rec.col221,
p_col222 => p_is_line_rec.col222,
p_col223 => p_is_line_rec.col223,
p_col224 => p_is_line_rec.col224,
p_col225 => p_is_line_rec.col225,
p_col226 => p_is_line_rec.col226,
p_col227 => p_is_line_rec.col227,
p_col228 => p_is_line_rec.col228,
p_col229 => p_is_line_rec.col229,
p_col230 => p_is_line_rec.col230,
p_col231 => p_is_line_rec.col231,
p_col232 => p_is_line_rec.col232,
p_col233 => p_is_line_rec.col233,
p_col234 => p_is_line_rec.col234,
p_col235 => p_is_line_rec.col235,
p_col236 => p_is_line_rec.col236,
p_col237 => p_is_line_rec.col237,
p_col238 => p_is_line_rec.col238,
p_col239 => p_is_line_rec.col239,
p_col240 => p_is_line_rec.col240,
p_col241 => p_is_line_rec.col241,
p_col242 => p_is_line_rec.col242,
p_col243 => p_is_line_rec.col243,
p_col244 => p_is_line_rec.col244,
p_col245 => p_is_line_rec.col245,
p_col246 => p_is_line_rec.col246,
p_col247 => p_is_line_rec.col247,
p_col248 => p_is_line_rec.col248,
p_col249 => p_is_line_rec.col249,
p_col250 => p_is_line_rec.col250,
p_duplicate_flag => p_is_line_rec.duplicate_flag,
p_current_usage => p_is_line_rec.current_usage,
p_notes => p_is_line_rec.notes,
p_sales_agent_email_address => p_is_line_rec.sales_agent_email_address,
p_vehicle_response_code => p_is_line_rec.vehicle_response_code,
p_custom_column1 => p_is_line_rec.custom_column1,
p_custom_column2 => p_is_line_rec.custom_column2,
p_custom_column3 => p_is_line_rec.custom_column3,
p_custom_column4 => p_is_line_rec.custom_column4,
p_custom_column5 => p_is_line_rec.custom_column5,
p_custom_column6 => p_is_line_rec.custom_column6,
p_custom_column7 => p_is_line_rec.custom_column7,
p_custom_column8 => p_is_line_rec.custom_column8,
p_custom_column9 => p_is_line_rec.custom_column9,
p_custom_column10 => p_is_line_rec.custom_column10,
p_custom_column11 => p_is_line_rec.custom_column11,
p_custom_column12 => p_is_line_rec.custom_column12,
p_custom_column13 => p_is_line_rec.custom_column13,
p_custom_column14 => p_is_line_rec.custom_column14,
p_custom_column15 => p_is_line_rec.custom_column15,
p_custom_column16 => p_is_line_rec.custom_column16,
p_custom_column17 => p_is_line_rec.custom_column17,
p_custom_column18 => p_is_line_rec.custom_column18,
p_custom_column19 => p_is_line_rec.custom_column19,
p_custom_column20 => p_is_line_rec.custom_column20,
p_custom_column21 => p_is_line_rec.custom_column21,
p_custom_column22 => p_is_line_rec.custom_column22,
p_custom_column23 => p_is_line_rec.custom_column23,
p_custom_column24 => p_is_line_rec.custom_column24,
p_custom_column25 => p_is_line_rec.custom_column25
);
PROCEDURE Update_Is_Line(
p_api_version_number IN NUMBER,
p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
p_commit IN VARCHAR2 := FND_API.G_FALSE,
p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_is_line_rec IN is_line_rec_type,
x_object_version_number OUT NOCOPY NUMBER
)
IS
CURSOR c_get_is_line(import_source_line_id NUMBER) IS
SELECT *
FROM AMS_IMP_SOURCE_LINES
where import_source_line_id=p_is_line_rec.import_source_line_id;
SELECT AS_IMPORT_INTERFACE_S.NEXTVAL
FROM DUAL;
L_API_NAME CONSTANT VARCHAR2(30) := 'Update_Is_Line';
SAVEPOINT UPDATE_Is_Line_PVT;
AMS_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');
AMS_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
p_token_name => 'INFO',
p_token_value => 'Is_Line') ;
AMS_UTILITY_PVT.debug_message('Private API: Calling update table handler');
AMS_IMP_SOURCE_LINES_PKG.Update_Row(
p_import_source_line_id => p_is_line_rec.import_source_line_id,
p_object_version_number => p_is_line_rec.object_version_number,
p_last_update_date => SYSDATE,
p_last_updated_by => FND_GLOBAL.USER_ID,
p_creation_date => SYSDATE,
p_created_by => FND_GLOBAL.USER_ID,
p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
p_import_list_header_id => p_is_line_rec.import_list_header_id,
p_import_successful_flag => p_is_line_rec.import_successful_flag,
p_enabled_flag => p_is_line_rec.enabled_flag,
p_import_failure_reason => p_is_line_rec.import_failure_reason,
p_re_import_last_done_date => p_is_line_rec.re_import_last_done_date,
p_party_id => p_is_line_rec.party_id,
p_dedupe_key => p_is_line_rec.dedupe_key,
p_col1 => p_is_line_rec.col1,
p_col2 => p_is_line_rec.col2,
p_col3 => p_is_line_rec.col3,
p_col4 => p_is_line_rec.col4,
p_col5 => p_is_line_rec.col5,
p_col6 => p_is_line_rec.col6,
p_col7 => p_is_line_rec.col7,
p_col8 => p_is_line_rec.col8,
p_col9 => p_is_line_rec.col9,
p_col10 => p_is_line_rec.col10,
p_col11 => p_is_line_rec.col11,
p_col12 => p_is_line_rec.col12,
p_col13 => p_is_line_rec.col13,
p_col14 => p_is_line_rec.col14,
p_col15 => p_is_line_rec.col15,
p_col16 => p_is_line_rec.col16,
p_col17 => p_is_line_rec.col17,
p_col18 => p_is_line_rec.col18,
p_col19 => p_is_line_rec.col19,
p_col20 => p_is_line_rec.col20,
p_col21 => p_is_line_rec.col21,
p_col22 => p_is_line_rec.col22,
p_col23 => p_is_line_rec.col23,
p_col24 => p_is_line_rec.col24,
p_col25 => p_is_line_rec.col25,
p_col26 => p_is_line_rec.col26,
p_col27 => p_is_line_rec.col27,
p_col28 => p_is_line_rec.col28,
p_col29 => p_is_line_rec.col29,
p_col30 => p_is_line_rec.col30,
p_col31 => p_is_line_rec.col31,
p_col32 => p_is_line_rec.col32,
p_col33 => p_is_line_rec.col33,
p_col34 => p_is_line_rec.col34,
p_col35 => p_is_line_rec.col35,
p_col36 => p_is_line_rec.col36,
p_col37 => p_is_line_rec.col37,
p_col38 => p_is_line_rec.col38,
p_col39 => p_is_line_rec.col39,
p_col40 => p_is_line_rec.col40,
p_col41 => p_is_line_rec.col41,
p_col42 => p_is_line_rec.col42,
p_col43 => p_is_line_rec.col43,
p_col44 => p_is_line_rec.col44,
p_col45 => p_is_line_rec.col45,
p_col46 => p_is_line_rec.col46,
p_col47 => p_is_line_rec.col47,
p_col48 => p_is_line_rec.col48,
p_col49 => p_is_line_rec.col49,
p_col50 => p_is_line_rec.col50,
p_col51 => p_is_line_rec.col51,
p_col52 => p_is_line_rec.col52,
p_col53 => p_is_line_rec.col53,
p_col54 => p_is_line_rec.col54,
p_col55 => p_is_line_rec.col55,
p_col56 => p_is_line_rec.col56,
p_col57 => p_is_line_rec.col57,
p_col58 => p_is_line_rec.col58,
p_col59 => p_is_line_rec.col59,
p_col60 => p_is_line_rec.col60,
p_col61 => p_is_line_rec.col61,
p_col62 => p_is_line_rec.col62,
p_col63 => p_is_line_rec.col63,
p_col64 => p_is_line_rec.col64,
p_col65 => p_is_line_rec.col65,
p_col66 => p_is_line_rec.col66,
p_col67 => p_is_line_rec.col67,
p_col68 => p_is_line_rec.col68,
p_col69 => p_is_line_rec.col69,
p_col70 => p_is_line_rec.col70,
p_col71 => p_is_line_rec.col71,
p_col72 => p_is_line_rec.col72,
p_col73 => p_is_line_rec.col73,
p_col74 => p_is_line_rec.col74,
p_col75 => p_is_line_rec.col75,
p_col76 => p_is_line_rec.col76,
p_col77 => p_is_line_rec.col77,
p_col78 => p_is_line_rec.col78,
p_col79 => p_is_line_rec.col79,
p_col80 => p_is_line_rec.col80,
p_col81 => p_is_line_rec.col81,
p_col82 => p_is_line_rec.col82,
p_col83 => p_is_line_rec.col83,
p_col84 => p_is_line_rec.col84,
p_col85 => p_is_line_rec.col85,
p_col86 => p_is_line_rec.col86,
p_col87 => p_is_line_rec.col87,
p_col88 => p_is_line_rec.col88,
p_col89 => p_is_line_rec.col89,
p_col90 => p_is_line_rec.col90,
p_col91 => p_is_line_rec.col91,
p_col92 => p_is_line_rec.col92,
p_col93 => p_is_line_rec.col93,
p_col94 => p_is_line_rec.col94,
p_col95 => p_is_line_rec.col95,
p_col96 => p_is_line_rec.col96,
p_col97 => p_is_line_rec.col97,
p_col98 => p_is_line_rec.col98,
p_col99 => p_is_line_rec.col99,
p_col100 => p_is_line_rec.col100,
p_col101 => p_is_line_rec.col101,
p_col102 => p_is_line_rec.col102,
p_col103 => p_is_line_rec.col103,
p_col104 => p_is_line_rec.col104,
p_col105 => p_is_line_rec.col105,
p_col106 => p_is_line_rec.col106,
p_col107 => p_is_line_rec.col107,
p_col108 => p_is_line_rec.col108,
p_col109 => p_is_line_rec.col109,
p_col110 => p_is_line_rec.col110,
p_col111 => p_is_line_rec.col111,
p_col112 => p_is_line_rec.col112,
p_col113 => p_is_line_rec.col113,
p_col114 => p_is_line_rec.col114,
p_col115 => p_is_line_rec.col115,
p_col116 => p_is_line_rec.col116,
p_col117 => p_is_line_rec.col117,
p_col118 => p_is_line_rec.col118,
p_col119 => p_is_line_rec.col119,
p_col120 => p_is_line_rec.col120,
p_col121 => p_is_line_rec.col121,
p_col122 => p_is_line_rec.col122,
p_col123 => p_is_line_rec.col123,
p_col124 => p_is_line_rec.col124,
p_col125 => p_is_line_rec.col125,
p_col126 => p_is_line_rec.col126,
p_col127 => p_is_line_rec.col127,
p_col128 => p_is_line_rec.col128,
p_col129 => p_is_line_rec.col129,
p_col130 => p_is_line_rec.col130,
p_col131 => p_is_line_rec.col131,
p_col132 => p_is_line_rec.col132,
p_col133 => p_is_line_rec.col133,
p_col134 => p_is_line_rec.col134,
p_col135 => p_is_line_rec.col135,
p_col136 => p_is_line_rec.col136,
p_col137 => p_is_line_rec.col137,
p_col138 => p_is_line_rec.col138,
p_col139 => p_is_line_rec.col139,
p_col140 => p_is_line_rec.col140,
p_col141 => p_is_line_rec.col141,
p_col142 => p_is_line_rec.col142,
p_col143 => p_is_line_rec.col143,
p_col144 => p_is_line_rec.col144,
p_col145 => p_is_line_rec.col145,
p_col146 => p_is_line_rec.col146,
p_col147 => p_is_line_rec.col147,
p_col148 => p_is_line_rec.col148,
p_col149 => p_is_line_rec.col149,
p_col150 => p_is_line_rec.col150,
p_col151 => p_is_line_rec.col151,
p_col152 => p_is_line_rec.col152,
p_col153 => p_is_line_rec.col153,
p_col154 => p_is_line_rec.col154,
p_col155 => p_is_line_rec.col155,
p_col156 => p_is_line_rec.col156,
p_col157 => p_is_line_rec.col157,
p_col158 => p_is_line_rec.col158,
p_col159 => p_is_line_rec.col159,
p_col160 => p_is_line_rec.col160,
p_col161 => p_is_line_rec.col161,
p_col162 => p_is_line_rec.col162,
p_col163 => p_is_line_rec.col163,
p_col164 => p_is_line_rec.col164,
p_col165 => p_is_line_rec.col165,
p_col166 => p_is_line_rec.col166,
p_col167 => p_is_line_rec.col167,
p_col168 => p_is_line_rec.col168,
p_col169 => p_is_line_rec.col169,
p_col170 => p_is_line_rec.col170,
p_col171 => p_is_line_rec.col171,
p_col172 => p_is_line_rec.col172,
p_col173 => p_is_line_rec.col173,
p_col174 => p_is_line_rec.col174,
p_col175 => p_is_line_rec.col175,
p_col176 => p_is_line_rec.col176,
p_col177 => p_is_line_rec.col177,
p_col178 => p_is_line_rec.col178,
p_col179 => p_is_line_rec.col179,
p_col180 => p_is_line_rec.col180,
p_col181 => p_is_line_rec.col181,
p_col182 => p_is_line_rec.col182,
p_col183 => p_is_line_rec.col183,
p_col184 => p_is_line_rec.col184,
p_col185 => p_is_line_rec.col185,
p_col186 => p_is_line_rec.col186,
p_col187 => p_is_line_rec.col187,
p_col188 => p_is_line_rec.col188,
p_col189 => p_is_line_rec.col189,
p_col190 => p_is_line_rec.col190,
p_col191 => p_is_line_rec.col191,
p_col192 => p_is_line_rec.col192,
p_col193 => p_is_line_rec.col193,
p_col194 => p_is_line_rec.col194,
p_col195 => p_is_line_rec.col195,
p_col196 => p_is_line_rec.col196,
p_col197 => p_is_line_rec.col197,
p_col198 => p_is_line_rec.col198,
p_col199 => p_is_line_rec.col199,
p_col200 => p_is_line_rec.col200,
p_col201 => p_is_line_rec.col201,
p_col202 => p_is_line_rec.col202,
p_col203 => p_is_line_rec.col203,
p_col204 => p_is_line_rec.col204,
p_col205 => p_is_line_rec.col205,
p_col206 => p_is_line_rec.col206,
p_col207 => p_is_line_rec.col207,
p_col208 => p_is_line_rec.col208,
p_col209 => p_is_line_rec.col209,
p_col210 => p_is_line_rec.col210,
p_col211 => p_is_line_rec.col211,
p_col212 => p_is_line_rec.col212,
p_col213 => p_is_line_rec.col213,
p_col214 => p_is_line_rec.col214,
p_col215 => p_is_line_rec.col215,
p_col216 => p_is_line_rec.col216,
p_col217 => p_is_line_rec.col217,
p_col218 => p_is_line_rec.col218,
p_col219 => p_is_line_rec.col219,
p_col220 => p_is_line_rec.col220,
p_col221 => p_is_line_rec.col221,
p_col222 => p_is_line_rec.col222,
p_col223 => p_is_line_rec.col223,
p_col224 => p_is_line_rec.col224,
p_col225 => p_is_line_rec.col225,
p_col226 => p_is_line_rec.col226,
p_col227 => p_is_line_rec.col227,
p_col228 => p_is_line_rec.col228,
p_col229 => p_is_line_rec.col229,
p_col230 => p_is_line_rec.col230,
p_col231 => p_is_line_rec.col231,
p_col232 => p_is_line_rec.col232,
p_col233 => p_is_line_rec.col233,
p_col234 => p_is_line_rec.col234,
p_col235 => p_is_line_rec.col235,
p_col236 => p_is_line_rec.col236,
p_col237 => p_is_line_rec.col237,
p_col238 => p_is_line_rec.col238,
p_col239 => p_is_line_rec.col239,
p_col240 => p_is_line_rec.col240,
p_col241 => p_is_line_rec.col241,
p_col242 => p_is_line_rec.col242,
p_col243 => p_is_line_rec.col243,
p_col244 => p_is_line_rec.col244,
p_col245 => p_is_line_rec.col245,
p_col246 => p_is_line_rec.col246,
p_col247 => p_is_line_rec.col247,
p_col248 => p_is_line_rec.col248,
p_col249 => p_is_line_rec.col249,
p_col250 => p_is_line_rec.col250,
-- p_duplicate_flag => p_is_line_rec.duplicate_flag,
p_duplicate_flag => l_tar_is_line_rec.duplicate_flag,
p_current_usage => p_is_line_rec.current_usage,
p_load_status => 'RELOAD',
p_notes => p_is_line_rec.notes,
p_sales_agent_email_address => p_is_line_rec.sales_agent_email_address,
p_vehicle_response_code => p_is_line_rec.vehicle_response_code,
p_custom_column1 => p_is_line_rec.custom_column1,
p_custom_column2 => p_is_line_rec.custom_column2,
p_custom_column3 => p_is_line_rec.custom_column3,
p_custom_column4 => p_is_line_rec.custom_column4,
p_custom_column5 => p_is_line_rec.custom_column5,
p_custom_column6 => p_is_line_rec.custom_column6,
p_custom_column7 => p_is_line_rec.custom_column7,
p_custom_column8 => p_is_line_rec.custom_column8,
p_custom_column9 => p_is_line_rec.custom_column9,
p_custom_column10 => p_is_line_rec.custom_column10,
p_custom_column11 => p_is_line_rec.custom_column11,
p_custom_column12 => p_is_line_rec.custom_column12,
p_custom_column13 => p_is_line_rec.custom_column13,
p_custom_column14 => p_is_line_rec.custom_column14,
p_custom_column15 => p_is_line_rec.custom_column15,
p_custom_column16 => p_is_line_rec.custom_column16,
p_custom_column17 => p_is_line_rec.custom_column17,
p_custom_column18 => p_is_line_rec.custom_column18,
p_custom_column19 => p_is_line_rec.custom_column19,
p_custom_column20 => p_is_line_rec.custom_column20,
p_custom_column21 => p_is_line_rec.custom_column21,
p_custom_column22 => p_is_line_rec.custom_column22,
p_custom_column23 => p_is_line_rec.custom_column23,
p_custom_column24 => p_is_line_rec.custom_column24,
p_custom_column25 => p_is_line_rec.custom_column25
); --For Error handling and Correction Update LOAD_STATUS = 'RELOAD'
SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
system_status_code = 'STAGED';
UPDATE ams_imp_list_headers_all
SET
-- batch_id =l_batchId
-- , status_code = 'STAGED'
execute_mode = 'R'
-- , user_status_id = l_user_status_id
WHERE import_list_header_id=p_is_line_rec.import_list_header_id
--AND STATUS_CODE <> 'STAGED'
--AND user_status_id <> l_user_status_id;
ROLLBACK TO UPDATE_Is_Line_PVT;
ROLLBACK TO UPDATE_Is_Line_PVT;
ROLLBACK TO UPDATE_Is_Line_PVT;
End Update_Is_Line;
PROCEDURE Delete_Is_Line(
p_api_version_number IN NUMBER,
p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
p_commit IN VARCHAR2 := FND_API.G_FALSE,
p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_import_source_line_id IN NUMBER,
p_object_version_number IN NUMBER
)
IS
L_API_NAME CONSTANT VARCHAR2(30) := 'Delete_Is_Line';
SAVEPOINT DELETE_Is_Line_PVT;
AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
AMS_IMP_SOURCE_LINES_PKG.Delete_Row(
p_IMPORT_SOURCE_LINE_ID => p_IMPORT_SOURCE_LINE_ID);
ROLLBACK TO DELETE_Is_Line_PVT;
ROLLBACK TO DELETE_Is_Line_PVT;
ROLLBACK TO DELETE_Is_Line_PVT;
End Delete_Is_Line;
SELECT IMPORT_SOURCE_LINE_ID
FROM AMS_IMP_SOURCE_LINES
WHERE IMPORT_SOURCE_LINE_ID = p_IMPORT_SOURCE_LINE_ID
AND object_version_number = p_object_version
FOR UPDATE NOWAIT;
IF p_is_line_rec.last_update_date = FND_API.g_miss_date OR p_is_line_rec.last_update_date IS NULL THEN
AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_is_line_NO_last_update_date');
IF p_is_line_rec.last_updated_by = FND_API.g_miss_num OR p_is_line_rec.last_updated_by IS NULL THEN
AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_is_line_NO_last_updated_by');
IF p_is_line_rec.last_update_login = FND_API.g_miss_num OR p_is_line_rec.last_update_login IS NULL THEN
AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_is_line_NO_last_update_login');
IF p_is_line_rec.last_update_date IS NULL THEN
AMS_Utility_PVT.Error_Message(p_message_name => 'NO_last_update_date');
IF p_is_line_rec.last_updated_by IS NULL THEN
AMS_Utility_PVT.Error_Message(p_message_name => 'NO_last_updated_by');
IF p_is_line_rec.last_update_login IS NULL THEN
AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_is_line_NO_last_update_login');
SELECT *
FROM ams_imp_source_lines
WHERE import_source_line_id = p_is_line_rec.import_source_line_id;
IF p_is_line_rec.last_update_date = FND_API.g_miss_date THEN
x_complete_rec.last_update_date := l_is_line_rec.last_update_date;
IF p_is_line_rec.last_updated_by = FND_API.g_miss_num THEN
x_complete_rec.last_updated_by := l_is_line_rec.last_updated_by;
IF p_is_line_rec.last_update_login = FND_API.g_miss_num THEN
x_complete_rec.last_update_login := l_is_line_rec.last_update_login;
p_validation_mode => JTF_PLSQL_API.g_update,
x_return_status => x_return_status
);