eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSI_CUSTOMER_PRODUCTS_PKG SQL Statements

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

Line: 8


        SELECT Transaction_Type_ID
        FROM   CSI_Txn_Types
        WHERE  Source_Transaction_Type = 'IB_UI';

Line: 194


    SELECT ip_account_id
      FROM csi_ip_accounts
     WHERE party_account_id = p_customer_id
       AND instance_party_id = (SELECT instance_party_id
                                  FROM csi_i_parties
                                 WHERE instance_id = p_customer_product_id
                                   AND relationship_type_code = 'OWNER');

Line: 216


       Select Party_id
       Into   x_party_tbl(1).Party_Id
       From   Hz_Cust_Accounts
       Where  Cust_Account_Id = P_CUSTOMER_ID;

Line: 453


PROCEDURE Update_Row(
p_CUSTOMER_PRODUCT_ID	  IN NUMBER,
P_INSTANCE_PARTY_ID       IN NUMBER,
p_IP_ACCOUNT_ID  	  IN NUMBER,
p_PRICING_ATTRIBUTE_ID	  IN NUMBER,
p_RELATIONSHIP_ID	  IN NUMBER,
p_CUSTOMER_ID   IN NUMBER,
p_INVENTORY_ITEM_ID   IN NUMBER,
p_LOT_NUMBER  IN VARCHAR2,
p_CREATED_MANUALLY_FLAG  IN VARCHAR2,
p_MOST_RECENT_FLAG IN VARCHAR2,
p_REVISION				 IN VARCHAR2,
p_CURRENT_SERIAL_NUMBER  IN VARCHAR2,
p_TYPE_CODE  IN VARCHAR2,
p_SYSTEM_ID  IN NUMBER,
p_PRODUCT_AGREEMENT_ID   IN NUMBER,
p_INSTALLATION_DATE   IN DATE,
p_ORIGINAL_ORDER_LINE_ID IN NUMBER,
p_ORIGINAL_LINE_SERV_DETAIL_ID IN NUMBER,
p_ORIGINAL_NET_AMOUNT IN NUMBER,
p_SHIP_TO_SITE_USE_ID IN NUMBER,
p_BILL_TO_SITE_USE_ID IN NUMBER,
p_INSTALL_SITE_USE_ID IN NUMBER,
p_QUANTITY   IN NUMBER,
p_SHIPPED_FLAG  IN VARCHAR2,
p_DELIVERED_FLAG   IN VARCHAR2,
p_UNIT_OF_MEASURE_CODE   IN VARCHAR2,
p_PARENT_CP_ID  IN NUMBER,
p_CUSTOMER_PRODUCT_STATUS_ID   IN NUMBER,
p_SHIPPED_DATE  IN DATE,
p_ORG_ID  IN NUMBER,
p_REFERENCE_NUMBER IN NUMBER,
p_RETURN_BY_DATE   IN DATE,
p_ACTUAL_RETURNED_DATE   IN DATE,
p_RMA_LINE_ID   IN NUMBER,
p_SPLIT_FLAG  IN VARCHAR2,
p_PROJECT_ID  IN NUMBER,
p_TASK_ID  IN NUMBER,
p_CONFIG_ENABLED_FLAG IN VARCHAR2,
p_CONFIG_START_DATE   IN DATE,
p_CONFIG_END_DATE  IN DATE,
p_CONFIG_ROOT_ID   IN NUMBER,
p_CONFIG_PARENT_ID IN NUMBER,
p_CONFIG_TYPE   IN VARCHAR2,
p_PLATFORM_VERSION_ID IN NUMBER,
p_START_DATE_ACTIVE   IN DATE,
p_END_DATE_ACTIVE  IN DATE,
p_MERCHANT_VIEW_FLAG		 IN VARCHAR2,
p_CUSTOMER_VIEW_FLAG		 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_CONTEXT  IN VARCHAR2,
p_COMMENTS				 IN VARCHAR2,
p_PRICING_CONTEXT		IN VARCHAR2,
p_PRICING_ATTRIBUTE1		IN VARCHAR2,
p_PRICING_ATTRIBUTE2		IN VARCHAR2,
p_PRICING_ATTRIBUTE3		IN VARCHAR2,
p_PRICING_ATTRIBUTE4		IN VARCHAR2,
p_PRICING_ATTRIBUTE5		IN VARCHAR2,
p_PRICING_ATTRIBUTE6		IN VARCHAR2,
p_PRICING_ATTRIBUTE7		IN VARCHAR2,
p_PRICING_ATTRIBUTE8		IN VARCHAR2,
p_PRICING_ATTRIBUTE9		IN VARCHAR2,
p_PRICING_ATTRIBUTE10		IN VARCHAR2,
p_PRICING_ATTRIBUTE11		IN VARCHAR2,
p_PRICING_ATTRIBUTE12		IN VARCHAR2,
p_PRICING_ATTRIBUTE13		IN VARCHAR2,
p_PRICING_ATTRIBUTE14		IN VARCHAR2,
p_PRICING_ATTRIBUTE15		IN VARCHAR2,
p_PRICING_ATTRIBUTE16		IN VARCHAR2,
p_PRICING_ATTRIBUTE17		IN VARCHAR2,
p_PRICING_ATTRIBUTE18		IN VARCHAR2,
p_PRICING_ATTRIBUTE19		IN VARCHAR2,
p_PRICING_ATTRIBUTE20		IN VARCHAR2,
p_PRICING_ATTRIBUTE21		IN VARCHAR2,
p_PRICING_ATTRIBUTE22		IN VARCHAR2,
p_PRICING_ATTRIBUTE23		IN VARCHAR2,
p_PRICING_ATTRIBUTE24		IN VARCHAR2,
p_PRICING_ATTRIBUTE25		IN VARCHAR2,
p_PRICING_ATTRIBUTE26		IN VARCHAR2,
p_PRICING_ATTRIBUTE27		IN VARCHAR2,
p_PRICING_ATTRIBUTE28		IN VARCHAR2,
p_PRICING_ATTRIBUTE29		IN VARCHAR2,
p_PRICING_ATTRIBUTE30		IN VARCHAR2,
p_PRICING_ATTRIBUTE31		IN VARCHAR2,
p_PRICING_ATTRIBUTE32		IN VARCHAR2,
p_PRICING_ATTRIBUTE33		IN VARCHAR2,
p_PRICING_ATTRIBUTE34		IN VARCHAR2,
p_PRICING_ATTRIBUTE35		IN VARCHAR2,
p_PRICING_ATTRIBUTE36		IN VARCHAR2,
p_PRICING_ATTRIBUTE37		IN VARCHAR2,
p_PRICING_ATTRIBUTE38		IN VARCHAR2,
p_PRICING_ATTRIBUTE39		IN VARCHAR2,
p_PRICING_ATTRIBUTE40		IN VARCHAR2,
p_PRICING_ATTRIBUTE41		IN VARCHAR2,
p_PRICING_ATTRIBUTE42		IN VARCHAR2,
p_PRICING_ATTRIBUTE43		IN VARCHAR2,
p_PRICING_ATTRIBUTE44		IN VARCHAR2,
p_PRICING_ATTRIBUTE45		IN VARCHAR2,
p_PRICING_ATTRIBUTE46		IN VARCHAR2,
p_PRICING_ATTRIBUTE47		IN VARCHAR2,
p_PRICING_ATTRIBUTE48		IN VARCHAR2,
p_PRICING_ATTRIBUTE49		IN VARCHAR2,
p_PRICING_ATTRIBUTE50		IN VARCHAR2,
p_PRICING_ATTRIBUTE51		IN VARCHAR2,
p_PRICING_ATTRIBUTE52		IN VARCHAR2,
p_PRICING_ATTRIBUTE53		IN VARCHAR2,
p_PRICING_ATTRIBUTE54		IN VARCHAR2,
p_PRICING_ATTRIBUTE55		IN VARCHAR2,
p_PRICING_ATTRIBUTE56		IN VARCHAR2,
p_PRICING_ATTRIBUTE57		IN VARCHAR2,
p_PRICING_ATTRIBUTE58		IN VARCHAR2,
p_PRICING_ATTRIBUTE59		IN VARCHAR2,
p_PRICING_ATTRIBUTE60		IN VARCHAR2,
p_PRICING_ATTRIBUTE61		IN VARCHAR2,
p_PRICING_ATTRIBUTE62		IN VARCHAR2,
p_PRICING_ATTRIBUTE63		IN VARCHAR2,
p_PRICING_ATTRIBUTE64		IN VARCHAR2,
p_PRICING_ATTRIBUTE65		IN VARCHAR2,
p_PRICING_ATTRIBUTE66		IN VARCHAR2,
p_PRICING_ATTRIBUTE67		IN VARCHAR2,
p_PRICING_ATTRIBUTE68		IN VARCHAR2,
p_PRICING_ATTRIBUTE69		IN VARCHAR2,
p_PRICING_ATTRIBUTE70		IN VARCHAR2,
p_PRICING_ATTRIBUTE71		IN VARCHAR2,
p_PRICING_ATTRIBUTE72		IN VARCHAR2,
p_PRICING_ATTRIBUTE73		IN VARCHAR2,
p_PRICING_ATTRIBUTE74		IN VARCHAR2,
p_PRICING_ATTRIBUTE75		IN VARCHAR2,
p_PRICING_ATTRIBUTE76		IN VARCHAR2,
p_PRICING_ATTRIBUTE77		IN VARCHAR2,
p_PRICING_ATTRIBUTE78		IN VARCHAR2,
p_PRICING_ATTRIBUTE79		IN VARCHAR2,
p_PRICING_ATTRIBUTE80		IN VARCHAR2,
p_PRICING_ATTRIBUTE81		IN VARCHAR2,
p_PRICING_ATTRIBUTE82		IN VARCHAR2,
p_PRICING_ATTRIBUTE83		IN VARCHAR2,
p_PRICING_ATTRIBUTE84		IN VARCHAR2,
p_PRICING_ATTRIBUTE85		IN VARCHAR2,
p_PRICING_ATTRIBUTE86		IN VARCHAR2,
p_PRICING_ATTRIBUTE87		IN VARCHAR2,
p_PRICING_ATTRIBUTE88		IN VARCHAR2,
p_PRICING_ATTRIBUTE89		IN VARCHAR2,
p_PRICING_ATTRIBUTE90		IN VARCHAR2,
p_PRICING_ATTRIBUTE91		IN VARCHAR2,
p_PRICING_ATTRIBUTE92		IN VARCHAR2,
p_PRICING_ATTRIBUTE93		IN VARCHAR2,
p_PRICING_ATTRIBUTE94		IN VARCHAR2,
p_PRICING_ATTRIBUTE95		IN VARCHAR2,
p_PRICING_ATTRIBUTE96		IN VARCHAR2,
p_PRICING_ATTRIBUTE97		IN VARCHAR2,
p_PRICING_ATTRIBUTE98		IN VARCHAR2,
p_PRICING_ATTRIBUTE99		IN VARCHAR2,
p_PRICING_ATTRIBUTE100		IN VARCHAR2,
Px_CP_Object_Version_Number      IN OUT NOCOPY NUMBER,
Px_IP_Object_Version_Number      IN OUT NOCOPY NUMBER,
Px_IPA_Object_Version_Number     IN OUT NOCOPY NUMBER,
Px_PA_Object_Version_Number      IN OUT NOCOPY NUMBER,
p_form_mode                 IN VARCHAR2,
p_block                     IN VARCHAR2,
x_return_status		        OUT NOCOPY VARCHAR2,
x_msg_count		            OUT NOCOPY NUMBER,
x_msg_data		            OUT NOCOPY VARCHAR2) IS

    l_api_version           NUMBER   := 1;

Line: 647


    l_Api_Name              VARCHAR2(30) := 'Update_Row';

Line: 838


            CSI_ITEM_INSTANCE_PUB.update_item_instance  (
                          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_instance_rec          => l_Instance_Rec
                         ,p_ext_attrib_values_tbl => l_Ext_Attrib_Values_Tbl
                         ,p_party_tbl             => l_Party_Tbl
                         ,p_account_tbl           => l_Account_Tbl
                         ,p_pricing_attrib_tbl    => l_Pricing_Attrib_Tbl
                         ,p_org_assignments_tbl   => l_Org_Assignments_Tbl
                         ,p_txn_rec               => l_Txn_Rec
                         ,p_asset_assignment_tbl  => l_asset_Assignment_Tbl
                         ,x_instance_id_lst       => l_instance_Id_Lst
                         ,x_return_status         => x_Return_Status
                         ,x_msg_count             => x_Msg_Count
                         ,x_msg_data              => x_Msg_Data
                                                     );

Line: 859


                     Select Object_Version_Number
                     Into   px_Cp_Object_Version_Number
                     From   CSI_ITEM_INSTANCES
                     Where  instance_id = l_Instance_Rec.Instance_Id;

Line: 868


                     Select Object_Version_Number
                     Into   Px_IPA_Object_Version_Number
                     From   CSI_IP_ACCOUNTS
                     Where  ip_account_id = l_Account_Tbl(1).IP_Account_Id;

Line: 883


           CSI_ITEM_INSTANCE_PUB.update_item_instance  (
                          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_instance_rec          => l_Instance_Rec
                         ,p_ext_attrib_values_tbl => l_Ext_Attrib_Values_Tbl
                         ,p_party_tbl             => l_Party_Tbl
                         ,p_account_tbl           => l_Account_Tbl
                         ,p_pricing_attrib_tbl    => l_Pricing_Attrib_Tbl
                         ,p_org_assignments_tbl   => l_Org_Assignments_Tbl
                         ,p_txn_rec               => l_Txn_Rec
                         ,p_asset_assignment_tbl  => l_asset_Assignment_Tbl
                         ,x_instance_id_lst       => l_instance_Id_Lst
                         ,x_return_status         => x_Return_Status
                         ,x_msg_count             => x_Msg_Count
                         ,x_msg_data              => x_Msg_Data
                                                     );

Line: 903


     csi_gen_utility_pvt.put_line('Update Shipto, Installed Address success in non Transfer Mode');

Line: 906


                     Select Object_Version_Number
                     Into   px_Cp_Object_Version_Number
                     From   CSI_ITEM_INSTANCES
                     Where  instance_id = l_Instance_Rec.Instance_Id;

Line: 915


                     Select Object_Version_Number
                     Into   Px_IPA_Object_Version_Number
                     From   CSI_IP_ACCOUNTS
                     Where  ip_account_id = l_Account_Tbl(1).IP_Account_Id;

Line: 930


           CSI_ITEM_INSTANCE_PUB.update_item_instance  (
                               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_instance_rec          => l_Instance_Rec
                              ,p_ext_attrib_values_tbl => l_Ext_Attrib_Values_Tbl
                              ,p_party_tbl             => l_Party_Tbl
                              ,p_account_tbl           => l_Account_Tbl
                              ,p_pricing_attrib_tbl    => l_Pricing_Attrib_Tbl
                              ,p_org_assignments_tbl   => l_Org_Assignments_Tbl
                              ,p_txn_rec               => l_Txn_Rec
                              ,p_asset_assignment_tbl  => l_asset_Assignment_Tbl
                              ,x_instance_id_lst       => l_instance_Id_Lst
                              ,x_return_status         => x_Return_Status
                              ,x_msg_count             => x_Msg_Count
                              ,x_msg_data              => x_Msg_Data
                                                       );

Line: 950


       csi_gen_utility_pvt.put_line('Update Instance related info success in non Transfer Mode');

Line: 951


                     Select Object_Version_Number
                     Into   px_Cp_Object_Version_Number
                     From   CSI_ITEM_INSTANCES
                     Where  instance_id = l_Instance_Rec.Instance_Id;

Line: 994


END Update_Row;

Line: 1167


	SELECT *
	FROM CSI_ITEM_INSTANCES
	WHERE INSTANCE_ID = p_CUSTOMER_PRODUCT_ID
	FOR UPDATE of INSTANCE_ID NOWAIT;

Line: 1173


	SELECT *
	FROM CSI_I_PARTIES
	WHERE INSTANCE_PARTY_ID = p_INSTANCE_PARTY_ID
	FOR UPDATE of INSTANCE_PARTY_ID NOWAIT;

Line: 1179


	SELECT *
	FROM CSI_IP_ACCOUNTS
	WHERE IP_ACCOUNT_ID = p_IP_ACCOUNT_ID
	FOR UPDATE of IP_ACCOUNT_ID NOWAIT;

Line: 1185


	SELECT *
	FROM CSI_I_PRICING_ATTRIBS
	WHERE PRICING_ATTRIBUTE_ID = p_PRICING_ATTRIBUTE_ID
	FOR UPDATE of PRICING_ATTRIBUTE_ID NOWAIT;

Line: 1191


	SELECT *
	FROM CSI_II_Relationships
	WHERE RELATIONSHIP_ID = p_RELATIONSHIP_ID
	FOR UPDATE of RELATIONSHIP_ID NOWAIT;

Line: 1197


	SELECT *
	FROM CSI_I_Org_assignments
	WHERE INSTANCE_OU_ID = p_INSTANCE_OU_ID
	FOR UPDATE of INSTANCE_OU_ID NOWAIT;

Line: 1208


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

Line: 1216


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

Line: 1224


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

Line: 1232


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

Line: 1240


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

Line: 1248


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

Line: 1368


  SELECT Quantity
  FROM CSI_ITEM_INSTANCES
  WHERE Instance_Id = p_Cp_Id;