APPS.AMS_LIST_IMPORT_PUB dependencies on AMS_IMP_SOURCE_LINES

Line 2148: UPDATE ams_imp_source_lines

2144: if i_party_id is not null then
2145: p_party_id := i_party_id ;
2146: end if;
2147: if i_party_id is not null and p_import_list_header_id is not null then
2148: UPDATE ams_imp_source_lines
2149: SET party_id = i_party_id,
2150: organization_id = x_org_party_id,
2151: load_status = 'SUCCESS',
2152: contact_point_id = l_phone_id,

Line 2902: UPDATE ams_imp_source_lines

2898: end if;
2899:
2900:
2901: if x_per_party_id is not null and p_import_list_header_id is not null then
2902: UPDATE ams_imp_source_lines
2903: SET party_id = x_per_party_id,
2904: load_status = 'SUCCESS',
2905: contact_point_id = l_phone_id,
2906: location_id = x_location_id,

Line 3332: update ams_imp_source_lines

3328: open c_imp_type;
3329: fetch c_imp_type into l_imp_type, l_batch_id, L_ERROR_THRESHOLD;
3330: close c_imp_type;
3331: if p_import_source_line_id is not null then
3332: update ams_imp_source_lines
3333: set load_status = 'ERROR' , ENABLED_FLAG = null
3334: where import_list_header_id = p_import_list_header_id
3335: and import_source_line_id = p_import_source_line_id;
3336:

Line 3482: update ams_imp_source_lines

3478: end if; -- --if p_component_name <> 'EVENTSUB' then
3479:
3480: if p_component_name = 'EVENTSUB' then
3481: if p_import_source_line_id is not null then
3482: update ams_imp_source_lines
3483: set load_status = 'ERROR' , ENABLED_FLAG = null
3484: where import_list_header_id = p_import_list_header_id
3485: and import_source_line_id = p_import_source_line_id;
3486: end if;

Line 4323: from ams_imp_source_lines line,

4319: LINE.COL247,
4320: LINE.COL248,
4321: LINE.COL249,
4322: LINE.COL250
4323: from ams_imp_source_lines line,
4324: ams_imp_list_headers_all header
4325: where line.import_source_line_id = p_import_source_line_id
4326: and line.import_list_header_id = p_import_list_header_id
4327: and line.import_list_header_id = header.import_list_header_id;