APPS.AMS_LIST_IMPORT_PUB dependencies on AMS_IMP_SOURCE_LINES

Line 2152: UPDATE ams_imp_source_lines

2148: if i_party_id is not null then
2149: p_party_id := i_party_id ;
2150: end if;
2151: if i_party_id is not null and p_import_list_header_id is not null then
2152: UPDATE ams_imp_source_lines
2153: SET party_id = i_party_id,
2154: organization_id = x_org_party_id,
2155: load_status = 'SUCCESS',
2156: contact_point_id = l_phone_id,

Line 2909: UPDATE ams_imp_source_lines

2905: end if;
2906:
2907:
2908: if x_per_party_id is not null and p_import_list_header_id is not null then
2909: UPDATE ams_imp_source_lines
2910: SET party_id = x_per_party_id,
2911: load_status = 'SUCCESS',
2912: contact_point_id = l_phone_id,
2913: location_id = x_location_id,

Line 3339: update ams_imp_source_lines

3335: open c_imp_type;
3336: fetch c_imp_type into l_imp_type, l_batch_id, L_ERROR_THRESHOLD;
3337: close c_imp_type;
3338: if p_import_source_line_id is not null then
3339: update ams_imp_source_lines
3340: set load_status = 'ERROR' , ENABLED_FLAG = null
3341: where import_list_header_id = p_import_list_header_id
3342: and import_source_line_id = p_import_source_line_id;
3343:

Line 3489: update ams_imp_source_lines

3485: end if; -- --if p_component_name <> 'EVENTSUB' then
3486:
3487: if p_component_name = 'EVENTSUB' then
3488: if p_import_source_line_id is not null then
3489: update ams_imp_source_lines
3490: set load_status = 'ERROR' , ENABLED_FLAG = null
3491: where import_list_header_id = p_import_list_header_id
3492: and import_source_line_id = p_import_source_line_id;
3493: end if;

Line 4330: from ams_imp_source_lines line,

4326: LINE.COL247,
4327: LINE.COL248,
4328: LINE.COL249,
4329: LINE.COL250
4330: from ams_imp_source_lines line,
4331: ams_imp_list_headers_all header
4332: where line.import_source_line_id = p_import_source_line_id
4333: and line.import_list_header_id = p_import_list_header_id
4334: and line.import_list_header_id = header.import_list_header_id;