APPS.JAI_AR_CR_TRIGGER_PKG SQL Statements

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

Line: 13

	SELECT	JAI_AR_CASH_RECEIPTS_S1.CURRVAL
	FROM DUAL;

Line: 18

	SELECT	LOC_CASH_RECEIPT_ID,
		RECEIPT_AMOUNT,
		CUSTOMER_ID,
		CONFIRM_FLAG,
		CURRENCY_CODE,
		EXCHANGE_RATE
	FROM 	JAI_AR_CASH_RECEIPTS_ALL
	WHERE 	TEMP_SEQUENCE_ID = PN_TEMP_SEQUENCE_ID
	AND 	CASH_RECEIPT_ID IS NULL;

Line: 36

	   SELECT b.regime_code
	     FROM JAI_RGM_REGISTRATIONS a,
	          JAI_RGM_DEFINITIONS b
	     WHERE a.attribute_code = 'AR_RECEIPT_CLASS'
	     AND   a.registration_type = 'OTHERS'
	     AND   a.attribute_type_code = 'OTHERS'
	     AND   a.regime_id = b.regime_id
	     AND a.attribute_value IN
	   (SELECT r_class.name
	      FROM ar_receipt_classes r_class,
	           ar_receipt_methods r_method
	      WHERE r_class.receipt_class_id = r_method.receipt_class_id
	        AND r_method.receipt_method_id = cp_receipt_method_id
	    );

Line: 80

				--raise_application_error(-20010,'Either of Receipt Amount or customer details or currency details are changed. Delete the record using Zoom function');

Line: 82

				pv_return_message := 'Either of Receipt Amount or customer details or currency details are changed. Delete the record using Tools Menu';

Line: 86

			UPDATE	jai_ar_cash_receipts_all
			SET 		cash_receipt_id = pr_new.cash_receipt_id,
							temp_sequence_id = NULL
			WHERE 	loc_cash_receipt_id = r_check_tmp_data.loc_cash_receipt_id;

Line: 91

			UPDATE	jai_cmn_document_taxes
			SET 		source_doc_id = pr_new.cash_receipt_id,
							source_doc_line_id = NULL
			WHERE 	source_doc_line_id = r_check_tmp_data.loc_cash_receipt_id
			AND 		source_table_name = 'JAI_AR_CASH_RECEIPTS_ALL';

Line: 139

	SELECT	confirm_flag
	FROM 		jai_ar_cash_receipts_all
	WHERE 	cash_receipt_id = cp_cash_receipt_id;

Line: 158

				DELETE 	jai_cmn_document_taxes
				WHERE 	source_table_name = 'JAI_AR_CASH_RECEIPTS_ALL'
				AND 		source_doc_id = pr_old.cash_receipt_id;

Line: 162

				DELETE 	jai_ar_cash_receipts_all
				WHERE 	cash_receipt_id = pr_old.cash_receipt_id;

Line: 206

	SELECT	confirm_flag
	FROM 		jai_ar_cash_receipts_all
	WHERE 	cash_receipt_id = cp_cash_receipt_id;

Line: 220

			DELETE 	jai_cmn_document_taxes
			WHERE 	source_table_name = 'JAI_AR_CASH_RECEIPTS_ALL'
			AND 		source_doc_id = pr_old.cash_receipt_id;

Line: 224

			DELETE 	jai_ar_cash_receipts_all
			WHERE 	cash_receipt_id = pr_old.cash_receipt_id;

Line: 227

			--raise_application_error(-20011, 'You can''t delete this receipt. Reverse the receipt');

Line: 229

			pv_return_message := 'You can''t delete this receipt. Reverse the receipt';