APPS.CSF_DEBRIEF_CHARGES SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 53

select price_list_header_id
from   csd_repairs
where  repair_line_id = p_original_source_id;

Line: 107

PROCEDURE UPDATE_LAB_RS_LOC(
p_debrief_header_id IN NUMBER,
p_debrief_line_id   IN NUMBER,
p_labor_start_date  IN DATE,
X_RETURN_STATUS	   OUT NOCOPY varchar2,
X_MSG_COUNT	   OUT NOCOPY number,
X_MSG_DATA         OUT NOCOPY VARCHAR2) as
z_resource_id           number;

Line: 124

select  jta.resource_id,
                loc.geometry
into            z_resource_id,
                z_location
from            csf_debrief_lines     cdl,
                csf_debrief_headers csf,
                cs_transaction_types_vl  ctt,
                cs_txn_billing_types  ctbt,
                jtf_task_assignments jta,
                jtf_tasks_b    jtb,
                hz_party_sites p,
                hz_locations   loc
where   csf.debrief_header_id      =  p_debrief_header_id
and             debrief_line_id            =  p_debrief_line_id
and             jta.task_id                        =     jtb.task_id
and             jta.task_assignment_id     =   csf.task_assignment_id
and             jtb.address_id             =    p.party_site_id
and             p.location_id              =     loc.location_id
and             csf.debrief_header_id      =   cdl.debrief_header_id
and             ctt.transaction_type_id    =   ctbt.transaction_type_id
and             cdl.txn_Billing_Type_Id    =   ctbt.txn_billing_type_id
and             ctbt.billing_type          =   'L';

Line: 148

select  max(actual_start_date)
into            z_start_date
from            jtf_task_assignments
where   resource_id = z_resource_id;

Line: 155

   select       object_version_number
   into z_object_version_number
   from jtf_rs_resource_extns
   where        resource_id             =       z_resource_id;

Line: 163

 jtf_rs_resource_pub.update_resource
    (P_API_VERSION      => 1,
   --  P_INIT_MSG_LIST    => fnd_api.g_false,
   --  P_COMMIT           => fnd_api.g_false,
     P_RESOURCE_ID      => z_resource_id,
     P_RESOURCE_NUMBER  => null,
     P_LOCATION                 => z_location,
     P_object_version_num =>  z_object_version_number,
     X_RETURN_STATUS      =>  x_return_status,
     X_MSG_COUNT          =>  x_msg_count,
     X_MSG_DATA           =>  x_msg_data);

Line: 182

PROCEDURE UPDATE_CHARGES (
SOURCE_CODE         IN   VARCHAR2,
SOURCE_ID           IN   NUMBER,
INVENTORY_ITEM_ID	IN	NUMBER	,
UNIT_OF_MEASURE_CODE IN  VARCHAR2	,
QUANTITY_REQUIRED    IN  NUMBER	,
TXN_BILLING_TYPE     IN  NUMBER    ,
OUT_X_Return_Status     OUT NOCOPY  VARCHAR2,
OUT_X_Msg_Count         OUT NOCOPY  NUMBER,
OUT_X_Msg_Data          OUT NOCOPY  VARCHAR2
) AS

Cursor c_estimate_detail(p_source_id NUMBER,p_source_code Varchar2) IS
  select estimate_detail_id
  FROM   cs_estimate_details
  WHERE  source_id = p_source_id
  AND    source_code = p_source_code;

Line: 216

Cs_Charge_Details_Pub.Update_Charge_Details (
			p_API_VERSION	     => 1.0,
			p_INIT_MSG_LIST     => FND_API.G_TRUE,
			p_COMMIT            => FND_API.G_FALSE,
			p_VALIDATION_LEVEL	=> FND_API.G_VALID_LEVEL_FULL,
			X_Return_Status     => OUT_X_Return_status,
			X_Msg_Count         => OUT_X_Msg_Count,
			X_Object_Version_Number => l_object_version_number,
		     X_MSG_DATA          => OUT_X_MSG_DATA,
			p_resp_appl_id      => NULL,
               p_resp_id           => NULL,
			p_user_id           => NULL,
			p_login_id          => NULL,
               p_transaction_control => FND_API.G_TRUE,
               p_charges_rec        => l_charges_rec);

Line: 231

END UPDATE_CHARGES;

Line: 233

PROCEDURE DELETE_CHARGES (SOURCE_ID IN NUMBER,
					 SOURCE_CODE IN  VARCHAR2,
					 OUT_X_Return_status OUT NOCOPY VARCHAR2,
					 OUT_X_Msg_Count OUT NOCOPY NUMBER,
					 OUT_X_MSG_DATA OUT NOCOPY VARCHAR2 ) IS

Cursor c_estimate_detail(p_source_id NUMBER,p_source_code Varchar2) IS
  select estimate_detail_id
  FROM   cs_estimate_details
  WHERE  source_id = p_source_id
  AND    source_code = p_source_code;

Line: 251

Cs_Charge_Details_pub.Delete_Charge_Details (
			p_API_VERSION	     => 1.0,
			p_INIT_MSG_LIST     => FND_API.G_TRUE,
			p_COMMIT            => FND_API.G_FALSE,
			p_VALIDATION_LEVEL	=> FND_API.G_VALID_LEVEL_FULL,
			X_Return_Status     => OUT_X_Return_status,
			X_Msg_Count         => OUT_X_Msg_Count,
		     X_MSG_DATA          => OUT_X_MSG_DATA,
			p_TRANSACTION_CONTROL =>  FND_API.G_TRUE,
			p_ESTIMATE_DETAIL_ID => l_Estimate_Detail_ID);

Line: 261

END  DELETE_CHARGES;