APPS.DPP_SLA_CLAIM_EXTRACT_PUB SQL Statements

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

Line: 88

		     SELECT TRANSACTION_HEADER_ID,
		     CLAIM_TYPE
		     INTO  l_transaction_header_id,
		           l_claim_type
		     FROM   DPP_TRANSACTION_CLAIMS_ALL
		     WHERE  CLAIM_ID=p_claim_id;

Line: 106

		     INSERT INTO DPP_XLA_HEADERS
		     (	TRANSACTION_HEADER_ID,
			PP_TRANSACTION_TYPE,
			BASE_TRANSACTION_HEADER_ID,
			PROCESSED_FLAG,
			CREATION_DATE,
			CREATED_BY,
			LAST_UPDATE_DATE,
			LAST_UPDATED_BY,
			LAST_UPDATE_LOGIN
		     )
		     VALUES
		     (
			l_transaction_header_id,
			l_claim_type,
			p_claim_id,
			l_processed_flag,
			SYSDATE,
			p_userid,
			SYSDATE,
			p_userid,
			p_userid
		     );

Line: 138

	   l_sla_line_tbl_type.delete;

Line: 145

				SELECT transaction_line_id
				INTO l_transaction_line_id
				FROM DPP_TRANSACTION_LINES_ALL
				WHERE transaction_header_id=l_transaction_header_id
				AND   inventory_item_id=p_claim_line_tbl(i).item_id
				AND   SUPP_DIST_CLAIM_ID=p_claim_line_tbl(i).claim_id;

Line: 152

				SELECT 	CUSTOMER_INV_LINE_ID
				INTO l_transaction_line_id
				FROM DPP_CUSTOMER_CLAIMS_ALL
				WHERE transaction_header_id=l_transaction_header_id
				AND   inventory_item_id=p_claim_line_tbl(i).item_id
				AND   SUPP_CUST_CLAIM_ID=p_claim_line_tbl(i).claim_id
				AND   CUST_ACCOUNT_ID=p_claim_line_tbl(i).dpp_cust_account_id;

Line: 160

				SELECT 	CUSTOMER_INV_LINE_ID
				INTO l_transaction_line_id
				FROM DPP_CUSTOMER_CLAIMS_ALL
				WHERE transaction_header_id=l_transaction_header_id
				AND   inventory_item_id=p_claim_line_tbl(i).item_id
				AND   CUSTOMER_CLAIM_ID=p_claim_line_tbl(i).claim_id;

Line: 186

	       l_sla_line_tbl_type(i).LAST_UPDATE_DATE:=SYSDATE;

Line: 187

	       l_sla_line_tbl_type(i).LAST_UPDATED_BY:=p_userid;

Line: 188

	       l_sla_line_tbl_type(i).LAST_UPDATE_LOGIN:=p_userid;

Line: 197

			INSERT INTO DPP_XLA_LINES
			(TRANSACTION_HEADER_ID,TRANSACTION_LINE_ID,
			BASE_TRANSACTION_HEADER_ID,
			BASE_TRANSACTION_LINE_ID,TRANSACTION_SUB_TYPE,
			CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,
			LAST_UPDATED_BY)
			VALUES (l_sla_line_tbl_type(i).transaction_header_id,
			l_sla_line_tbl_type(i).transaction_line_id,
			l_sla_line_tbl_type(i).base_transaction_header_id,
			l_sla_line_tbl_type(i).base_transaction_line_id,
			l_sla_line_tbl_type(i).transaction_sub_type,
			l_sla_line_tbl_type(i).creation_date,
			l_sla_line_tbl_type(i).created_by,
			l_sla_line_tbl_type(i).last_update_date,
			l_sla_line_tbl_type(i).last_updated_by
			);