APPS.CSI_EXT_CONTACTS_PKG SQL Statements

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

Line: 9

 SELECT Transaction_Type_Id
 FROM   CSI_Txn_Types
 WHERE  Source_Transaction_Type = 'IB_UI';

Line: 51

     select instance_party_id
     from csi_i_parties
     where instance_id=P_INSTANCE_ID
     and relationship_type_code='OWNER' ;

Line: 89

PROCEDURE Insert_Row(
	p_customer_product_id		IN NUMBER,
	p_contact_category              IN VARCHAR2,
	p_contact_type			IN VARCHAR2,
	p_contact_id			IN NUMBER,
	p_primary_flag			IN VARCHAR2,
	p_preferred_flag		IN VARCHAR2,
	p_svc_provider_flag		IN VARCHAR2,
	p_start_date_active		IN DATE,
	p_end_date_active		IN DATE,
	p_context			IN VARCHAR2,
	p_attribute1			IN VARCHAR2,
	p_attribute2			IN VARCHAR2,
	p_attribute3			IN VARCHAR2,
	p_attribute4			IN VARCHAR2,
	p_attribute5			IN VARCHAR2,
	p_attribute6			IN VARCHAR2,
	p_attribute7			IN VARCHAR2,
	p_attribute8			IN VARCHAR2,
	p_attribute9			IN VARCHAR2,
	p_attribute10			IN VARCHAR2,
	p_attribute11			IN VARCHAR2,
	p_attribute12			IN VARCHAR2,
	p_attribute13			IN VARCHAR2,
	p_attribute14			IN VARCHAR2,
	p_attribute15			IN VARCHAR2,
	x_cs_contact_id		        OUT NOCOPY NUMBER,
	x_return_status		        OUT NOCOPY VARCHAR,
	x_msg_count		 OUT NOCOPY NUMBER,
	x_msg_data		 OUT NOCOPY VARCHAR,
	x_object_version_number	        OUT NOCOPY NUMBER
	)
IS
      l_Party_Tbl  CSI_DATASTRUCTURES_PUB.Party_Tbl;

Line: 126

      l_api_name	CONSTANT	VARCHAR2(30)	:= 'Insert_Row';

Line: 190

   csi_item_instance_pub.update_item_instance(
      p_api_version           => 1.0,
      p_commit                => fnd_api.g_false,
      p_init_msg_list         => fnd_api.g_true,
      p_validation_level      => fnd_api.g_valid_level_full,
      p_instance_rec          => l_chg_instance_rec,
      p_ext_attrib_values_tbl => l_chg_ext_attrib_val_tbl,
      p_party_tbl             => l_Party_Tbl,
      p_account_tbl           => l_Party_Account_Tbl,
      p_pricing_attrib_tbl    => l_chg_pricing_attribs_tbl,
      p_org_assignments_tbl   => l_chg_org_units_tbl,
      p_txn_rec               => l_Txn_Rec,
      p_asset_assignment_tbl  => l_chg_inst_asset_tbl,
      x_instance_id_lst       => l_chg_inst_id_lst,
      x_return_status         => x_Return_Status,
      x_msg_count             => x_Msg_Count,
      x_msg_data              => x_Msg_Data);

Line: 244

END Insert_Row;

Line: 246

PROCEDURE Delete_Row(
	x_return_status OUT NOCOPY 	VARCHAR,
	x_msg_count	 OUT NOCOPY NUMBER,
	x_msg_data	 OUT NOCOPY VARCHAR,
	p_cs_contact_id 	IN	NUMBER,
        P_Object_Version_Number IN      NUMBER)
IS
      l_Party_Tbl  CSI_DATASTRUCTURES_PUB.Party_Tbl;

Line: 257

      l_Api_Name VARCHAR2(30) := 'Delete_Row';

Line: 315

 END DELETE_ROW;

Line: 348

		SELECT *
		FROM csi_i_parties
		WHERE instance_party_id  = p_cs_contact_id
		FOR UPDATE of instance_party_id NOWAIT;

Line: 359

		FND_MESSAGE.SET_NAME('CSI','FORM_RECORD_DELETED');

Line: 472

PROCEDURE Update_Row(
	p_cs_contact_id		IN NUMBER,
	p_customer_product_id		IN NUMBER,
	p_contact_category  	IN VARCHAR2,
	p_contact_type			IN VARCHAR2,
	p_contact_id			IN NUMBER,
	p_primary_flag			IN VARCHAR2,
	p_preferred_flag		IN VARCHAR2,
	p_svc_provider_flag		IN VARCHAR2,
	p_start_date_active		IN DATE,
	p_end_date_active		IN DATE,
	p_context			IN VARCHAR2,
	p_attribute1			IN VARCHAR2,
	p_attribute2			IN VARCHAR2,
	p_attribute3			IN VARCHAR2,
	p_attribute4			IN VARCHAR2,
	p_attribute5			IN VARCHAR2,
	p_attribute6			IN VARCHAR2,
	p_attribute7			IN VARCHAR2,
	p_attribute8			IN VARCHAR2,
	p_attribute9			IN VARCHAR2,
	p_attribute10			IN VARCHAR2,
	p_attribute11			IN VARCHAR2,
	p_attribute12			IN VARCHAR2,
	p_attribute13			IN VARCHAR2,
	p_attribute14			IN VARCHAR2,
	p_attribute15			IN VARCHAR2,
	p_object_version_number	IN NUMBER,
	x_return_status	 OUT NOCOPY VARCHAR,
	x_msg_count		 OUT NOCOPY NUMBER,
	x_msg_data		 OUT NOCOPY VARCHAR,
	x_object_version_number OUT NOCOPY NUMBER
	)
IS
	l_api_name	CONSTANT		VARCHAR2(30)	:= 'Update_Contact';

Line: 563

CSI_PARTY_RELATIONSHIPS_PUB.update_inst_party_relationship
 (    p_api_version                 =>     l_Api_Version,
      p_commit                      =>     l_Commit,
      p_init_msg_list               =>     l_Init_Msg_List,
      p_validation_level            =>     l_Validation_Level,
      p_Party_Tbl                   =>     l_party_tbl,
      p_party_account_tbl           =>     l_account_tbl,
      p_txn_rec                     =>     l_txn_rec,
      x_return_status               =>     x_Return_Status,
      x_msg_count                   =>     x_Msg_Count,
      x_msg_data                    =>     x_Msg_Data );

Line: 576

    csi_item_instance_pub.update_item_instance(
      p_api_version           => 1.0,
      p_commit                => fnd_api.g_false,
      p_init_msg_list         => fnd_api.g_true,
      p_validation_level      => fnd_api.g_valid_level_full,
      p_instance_rec          => l_chg_instance_rec,
      p_ext_attrib_values_tbl => l_chg_ext_attrib_val_tbl,
      p_party_tbl             => l_party_tbl,
      p_account_tbl           => l_account_tbl,
      p_pricing_attrib_tbl    => l_chg_pricing_attribs_tbl,
      p_org_assignments_tbl   => l_chg_org_units_tbl,
      p_txn_rec               => l_txn_rec,
      p_asset_assignment_tbl  => l_chg_inst_asset_tbl,
      x_instance_id_lst       => l_chg_inst_id_lst,
      x_return_status         => x_return_status,
      x_msg_count             => x_msg_count,
      x_msg_data              => x_msg_data);

Line: 629

END Update_Row;