APPS.CSF_DEBRIEF_UPDATE_PKG dependencies on CSF_DEBRIEF_LINES

Line 32: from csf_debrief_lines

28: Begin
29: x_return_status := FND_API.G_RET_STS_SUCCESS;
30: select charge_upload_status,ib_update_status,spare_update_status
31: into l_charge_upload_status,l_ib_update_status,l_spare_update_status
32: from csf_debrief_lines
33: where debrief_line_id = p_debrief_line_id
34: for update nowait;
35: Exception
36: WHEN RECORD_LOCK_EXCEPTION THEN

Line 187: from csf_debrief_lines cdl

183: cdl.return_reason_code,
184: cdl.instance_id,
185: cdl.status_of_received_part, --added for bug 3192060
186: cdl.item_operational_status_code
187: from csf_debrief_lines cdl
188: where cdl.debrief_header_id = p_debrief_header_id
189: and nvl(cdl.quantity,-1) <> 0 ;
190:
191: cursor c_header (p_header_id Number) is

Line 787: csf_debrief_lines_pkg.update_row(

783:
784: if l_charges_interface_status <> 'FAILED' then
785: l_charges_interface_status := fnd_api.g_miss_char;
786: end if;
787: csf_debrief_lines_pkg.update_row(
788: p_debrief_line_id => l_debrief_line_id,
789: p_error_text => substr(l_msg_data,1,2000),
790: p_charge_upload_status => l_charges_interface_status,
791: p_last_updated_by => fnd_global.user_id,

Line 798: csf_debrief_lines_pkg.update_row(

794: else
795:
796: if l_charges_interface_status = 'SUCCEEDED' Then --it means we tried to update Charges and it was succ
797:
798: csf_debrief_lines_pkg.update_row(
799: p_debrief_line_id => l_debrief_line_id,
800: p_error_text => null,
801: p_charge_upload_status => l_charges_interface_status,
802: p_last_updated_by => fnd_global.user_id,

Line 891: csf_debrief_lines_pkg.update_row(

887: end if;
888: if l_ib_interface_status <> 'FAILED' then
889: l_ib_interface_status := fnd_api.g_miss_char;
890: end if;
891: csf_debrief_lines_pkg.update_row(
892: p_debrief_line_id => l_debrief_line_id,
893: p_error_text => substr(l_msg_data,1,2000),
894: p_charge_upload_status => l_charges_interface_status,
895: p_ib_update_status => l_ib_interface_status,

Line 907: csf_debrief_lines_pkg.update_row(

903:
904: if l_line_category_code <> 'RETURN' then
905: l_instance_id := l_new_instance_id;
906: end if;
907: csf_debrief_lines_pkg.update_row(
908: p_debrief_line_id => l_debrief_line_id,
909: p_error_text => null,
910: p_instance_id => l_instance_id,
911: p_ib_update_status => l_ib_interface_status,

Line 1047: csf_debrief_lines_pkg.update_row(

1043: p_Cost_Rec => l_cost_rec);
1044: if l_RETURN_STATUS = 'S' then -- success
1045: l_charges_interface_status := 'SUCCEEDED';
1046: l_msg_data := null;
1047: csf_debrief_lines_pkg.update_row(
1048: p_debrief_line_id => l_debrief_line_id,
1049: p_error_text => substr(l_msg_data,1,2000),
1050: p_charge_upload_status => l_charges_interface_status,
1051: p_last_updated_by => fnd_global.user_id,

Line 1083: csf_debrief_lines_pkg.update_row(

1079: end if;
1080: if l_inv_interface_status <> 'FAILED' then
1081: l_inv_interface_status := fnd_api.g_miss_char;
1082: end if;
1083: csf_debrief_lines_pkg.update_row(
1084: p_debrief_line_id => l_debrief_line_id,
1085: p_error_text => substr(l_msg_data,1,2000),
1086: p_charge_upload_status => l_charges_interface_status,
1087: p_ib_update_status => l_ib_interface_status,

Line 1100: csf_debrief_lines_pkg.update_row(

1096: and ( (l_ib_interface_status = 'SUCCEEDED' and l_trackable='Y')
1097: or (l_ib_update_status = 'SUCCEEDED' and l_trackable ='Y')
1098: or l_trackable ='N' or l_trackable is null ) then
1099: --we tried to update inventory
1100: csf_debrief_lines_pkg.update_row(
1101: p_debrief_line_id => l_debrief_line_id,
1102: p_error_text => null,
1103: p_spare_update_status => l_inv_interface_status,
1104: p_last_updated_by => fnd_global.user_id,

Line 1162: csf_debrief_lines_pkg.update_row(

1158: else
1159: l_msg_data := null;
1160: end if;
1161:
1162: csf_debrief_lines_pkg.update_row(
1163: p_debrief_line_id => l_debrief_line_id,
1164: p_error_text => substr(l_msg_data,1,2000));
1165:
1166: end if; -- end of charges status check